YAML for PostgreSQL
PostgreSQL target for executing queries on a PostgreSQL database.
YAML examples for PostgreSQL
PostgreSQL target with SSL verification
yaml
- target: postgresql-prod
type: POSTGRESQL
name: Production PostgreSQL
host: db.internal.example.com
port: '5432'
database: production
ssl_mode: VERIFY_FULL
ca_certificate: |
-----BEGIN CERTIFICATE-----
<paste the CA that signed the server certificate here>
-----END CERTIFICATE-----
auth:
username: postgres
password: secured
With Proxy
yaml
- target: postgresql-behind-bastion
type: POSTGRESQL
name: PostgreSQL in a private network
host: db.internal.example.com
port: '5432'
database: production
ssl_mode: REQUIRE
proxy: ssh-bastion
auth:
username: postgres
password: secured
Minimal
yaml
- target: postgresql
type: POSTGRESQL
host: db.internal.example.com
auth:
username: postgres
password: secured