Links

Postgres

Connect & Ingest data from / to a Postgres database

Sling CLI Setup

The following credentials keys are accepted:
  • host (required) -> The hostname / ip of the instance
  • user (required) -> The username to access the instance
  • database (required) -> The database name of the instance
  • schema (optional) -> The default schema to use
  • password (optional) -> The password to access the instance
  • port (optional) -> The port of the instance. Default is 5432.
  • sslmode (optional) -> The sslmode of the instance. Default is disable.
  • ssh_tunnel (optional) -> The URL of the SSH server you would like to use as a tunnel (example ssh://user:[email protected]:22)
  • ssh_private_key (optional) -> The private key to use to access a SSH server.
Here is an example of setting a connection named POSTGRES. We must provide the type=postgres property:
$ sling conns set POSTGRES type=postgres host=<host> user=<user> database=<database> password=<password> port=<port>
# OR use url
$ sling conns set POSTGRES url=postgresql://myuser:[email protected]:5432/mydatabase?sslmode=require

Environment Variable

export POSTGRES='postgresql://myuser:[email protected]:5432/mydatabase?sslmode=require'

Database user creation

To allow Sling to access your database, we need to create a user with the proper privileges. Please follow the steps below:
  1. 1.
    Create a user sling (or whatever you prefer) by running:
    CREATE USER sling WITH PASSWORD '<password>';
  2. 2.
    If you are planning to load data into this connection, grant the following privileges to that user:
    GRANT CREATE ON DATABASE <database_name> TO sling;
  3. 3.
    If you are planning to extract data from this connection, you need to give permission to read the tables you'd like Sling to extract.
    -- Need this to read table & column names
    GRANT SELECT ON ALL TABLES IN SCHEMA information_schema TO sling;
    GRANT SELECT ON ALL TABLES IN SCHEMA pg_catalog TO sling;
    -- run this to grant SELECT permission to all tables in schema `marketing` to user sling
    GRANT SELECT ON ALL TABLES IN SCHEMA marketing TO sling;
If you are facing issues connecting, please reach out to us at [email protected].
Last modified 1mo ago