How-to Guide: Locating The Required Details to Connect Postgres

This guide will help you set up integrations with your PostgreSQL database, including locating important details and allowing access from Ledge’s static IP address (34.231.208.110).

Your database administrator should have the details available and can help in setting up permissions.

For convenience, below are instructions on getting the required details based on your cloud provider (Azure, Google Cloud Platform, or AWS).

Note: you will need admin privileges to complete this guide.

Azure

Step 1: Locate Your PostgreSQL Server URL and Port

1. Sign in to the Azure Portal.

2. Navigate to Azure Database for PostgreSQL by searching for "PostgreSQL" in the search bar.

3. Select your PostgreSQL server from the list.

4. Under the Overview tab, find the Server name. It looks something like:

your-server-name.postgres.database.azure.com

1. The port for PostgreSQL is usually 5432.

---

Step 2: Locate Your Schema and Tables

1. Open a PostgreSQL client like pgAdmin or use Azure Data Studio.

2. Connect to your PostgreSQL server using the server name, port, username, and password.

3. Once connected, expand the database in the left-hand menu to view schemas and tables.

   • Schema: Groups tables and other objects in your database.

   • Tables: Data is stored in tables, typically listed under each schema.

---

Step 3: Add IP Address 34.231.208.110 to the Allow List

1. In the Azure Portal, go to your PostgreSQL server.

2. Under Settings, select Networking or Connection Security.

3. Add a new firewall rule:

   • Rule name: Allow-34.231.208.110

   • Start IP: 34.231.208.110

   • End IP: 34.231.208.110

4. Save the changes.

---

Google Cloud Platform (GCP)

Step 1: Locate Your PostgreSQL Server URL and Port

1. Sign in to the Google Cloud Console.
2. Navigate to Cloud SQL by searching for "Cloud SQL" in the search bar.

3. Select your PostgreSQL instance from the list.

4. In the Instance Details, locate the Public IP address under the Connect to this instance section.

   • Example: 192.168.13.37

5. The port for PostgreSQL is usually 5432.

---

Step 2: Locate Your Schema and Tables

1. Open a PostgreSQL client like pgAdmin or connect using the Cloud Shell.

2. Connect to your PostgreSQL instance using the public IP address, port, username, and password.

3. Once connected, view schemas and tables by expanding the database objects in your client.

---

Step 3: Add IP Address 34.231.208.110 to the Allow List

1. In the Google Cloud Console, go to your PostgreSQL instance.

2. Under the Connections tab, find the Authorized networks section.

3. Add a new network:

   • Name: Allow-34.231.208.110

   • Network: 34.231.208.110/32

4. Save the changes.

---

AWS

Step 1: Locate Your PostgreSQL Server URL and Port

1. Sign in to the AWS Management Console.
2. Navigate to RDS (Relational Database Service).

3. Select your PostgreSQL instance from the list.

4. Under Connectivity & security, find the Endpoint. It looks something like:

   your-instance-name.abc123xyz.region.rds.amazonaws.com

5. The port for PostgreSQL is usually 5432.

---

Step 2: Locate Your Schema and Tables

1. Open a PostgreSQL client like pgAdmin or use an EC2 instance to connect to your database.

2. Connect to your PostgreSQL instance using the endpoint, port, username, and password.

3. Once connected, explore the database to view schemas and tables.

---

Step 3: Add IP Address 34.231.208.110 to the Allow List

1. In the AWS Management Console, navigate to RDS.

2. Under Connectivity & security, find the VPC security groups section.

3. Click on the security group associated with your database.

4. In the Security Groups page, go to the Inbound rules tab.

5. Add a new rule:

   • Type: PostgreSQL

   • Protocol: TCP

   • Port Range: 5432

   • Source: 34.231.208.110/32

6. Save the changes.

---

With these steps completed, your PostgreSQL integration is set up, and the IP address 34.231.208.110 has access. If you need further help, reach out to your Ledge CSM or contact your IT support team.