Postgres

PostgreSQL connections enable integration with PostgreSQL databases for health checks, SQL queries in playbooks, and database monitoring.

Used By

• Postgres Health Check - Verify database connectivity and run health queries
• SQL Action - Execute SQL queries in playbooks
• Postgres Scraper - Scrape database configurations

Field	Description	Scheme
database*	Database name to connect to	EnvVar
host*	Database server hostname or IP address	EnvVar
password*	Database password for authentication	EnvVar
username*	Database user for authentication	EnvVar
insecureTLS	Skip TLS certificate verification	boolean
port	Database server port (default: 5432)	integer

Example

postgres-connection.yaml
apiVersion: mission-control.flanksource.com/v1
kind: Connection
metadata:
  name: payments-database
  namespace: default
spec:
  postgres:
    host:
      value: postgres.example.com
    port: 5432
    database:
      value: payments
    username:
      valueFrom:
        secretKeyRef:
          name: postgres-credentials
          key: POSTGRES_USER
    password:
      valueFrom:
        secretKeyRef:
          name: postgres-credentials
          key: POSTGRES_PASSWORD
    insecureTLS: false