# 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](https://portal.azure.com).
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](https://console.cloud.google.com).
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](https://aws.amazon.com/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.


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.ledge.co/integration-guides/databases-and-data-warehouses/how-to-guide-locating-the-required-details-to-connect-postgres.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.