Postgres

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.

Here is an example of setting a connection named POSTGRES:

# YAML format
export POSTGRES="{type: postgres, host: <host>, user: <user>, database: <database>, password: <password>, port: <port>, sslmode: require}"

# URL
export POSTGRES="postgresql://myuser:mypass@host.ip:5432/mydatabase?sslmode=require"