Skip to main content

PostgreSQL Database Connector

PostgreSQL is relational databases offering robust data storage, management, and querying features tailored for different scales and use cases.

info

For the common steps on adding connectors in Unstract, see Working with Connectors.

Adding PostgreSQL Connector in Unstract​

When configuring the PostgreSQL connector, you'll need to provide the following connection details:

Required Configuration Fields​

  • Name of the connector: Enter a descriptive name for your PostgreSQL connector
  • Connection Method: Can be one of Postgres URL or Postgres Params
  • If the Connection Method is Postgres URL, enter your PostgreSQL connection string in the format: 
    postgresql://username:password@hostname:port/database
    For example: postgresql://myuser:mypassword@db.example.com:5432/mydatabase

PostgreSQL Connector Configuration

  • If the Connection Method is Postgres Params, fill in the required fields
  • For Host, enter the Host
  • For Port, enter the Port
  • For Database, enter the database name to connect to
  • For Schema, enter the database schema to connect to. Defaults to public
  • For User, enter the DB user for authentication. Queries will be run as this user
  • For Password, enter the password for authentication