Secrets in PostgreSQL

Store PostgreSQL credentials as secrets for PostgreSQL destination nodes.

  less than a minute  

Store PostgreSQL credentials as secrets for PostgreSQL destination nodes.

PostgreSQL Destination

Secret to create:

Secret NameDescription
postgres-passwordPostgreSQL password

PostgreSQL Destination Node:

- name: postgres_destination
  type: postgres_output
  host: postgres.example.com
  port: 5432
  database: logs_db
  username: logs_user
  password: '{{ SECRET postgres-password }}'

Multiple PostgreSQL Databases

If you send data to multiple PostgreSQL databases, create separate secrets for each.

Secrets to create:

Secret NameDescription
postgres-prod-passwordProduction PostgreSQL password
postgres-analytics-passwordAnalytics PostgreSQL password

Multiple PostgreSQL Destinations:

- name: postgres_prod
  type: postgres_output
  host: postgres-prod.example.com
  port: 5432
  database: prod_logs
  username: prod_user
  password: '{{ SECRET postgres-prod-password }}'

- name: postgres_analytics
  type: postgres_output
  host: postgres-analytics.example.com
  port: 5432
  database: analytics_db
  username: analytics_user
  password: '{{ SECRET postgres-analytics-password }}'

See Also