PostgreSQL

Schema for configuring PostgreSQL database connection parameters

Properties

Name	Type	Description	Required
type	string	Connection type Constant Value: "postgresql"	yes
host	string	DB host	yes
port	integer	DB port Minimum: 1 Maximum: 65535	yes
database	string	DB name	yes
user	string	DB user	yes
password	string	DB password	no
connect_args	object	Additional arguments to use when connecting to the DB	no
query_args	object	Additional query string arguments to use when connecting to the DB	no

Example

hr:
  type: postgresql
  host: localhost
  port: 5432
  database: postgres
  user: postgres
  password: postgres
  connect_args:
    connect_timeout: 10
  query_args:
    sslmode: verify-ca
    sslrootcert: /opt/ssl/ca.crt
    sslcert: /opt/ssl/client.crt
    sslkey: /opt/ssl/client.key

connect_args: object

Additional arguments to use when connecting to the DB

Additional Properties: allowed

query_args: object

Additional query string arguments to use when connecting to the DB

Additional Properties: allowed