Use a PostgreSQL database for synthetic data

If you use the web application, create a new PostgreSQL connector from the Connectors page.

Steps

1. From the Connectors tab, click Create connector.
2. From the Create a new connector window, select PostgreSQL.
3. From the New connector window, configure the connector.
   1. For Name, enter a name that you can distinguish from other connectors.
   2. For Access type, select whether you want to use the connector as a source or destination.
   3. For Host, enter the database hostname.
   4. For Port, enter the database port.
      The default port for PostgreSQL databases is 5432.

   5. For Username and Password, enter your PostgreSQL database credentials.
   6. For Database, enter the name of the database.
4. To use an encrypted connection to the database, select Use SSL.
   1. For Root certificate, upload your server root certificate.
   2. For SSL certificate, upload your client certificate.
   3. For SSL certificate key, upload your client private key.
5. Click Save to save your new PostgreSQL connector.
   
   MOSTLY AI tests the connection. If you see an error, check the connection details, update them, and click Save again.
   
   You can click Save anyway to save the connector disregarding any errors.

If you use the Python client, create a PostgreSQL connector with mostly.connect() and provide a connector configuration dictionary as shown below.

c = mostly.connect({
    "name": "PostgreSQL Connector",
    "type": "POSTGRES",
    "access_type": "SOURCE",
    "config": {
        "host": "postgres.hostname.com",
        "port": "5432",
        "username": "postgres",
        "database": "db_name"
    },
    "secrets": {
        "password": "******"
    },
    "test_connection": True
})