PostgreSQL

healops integrations setup

POSTGRESQL_HOST=your-postgresql-host
POSTGRESQL_PORT=5432
POSTGRESQL_DATABASE=your-database
POSTGRESQL_USERNAME=healops_readonly
POSTGRESQL_PASSWORD=your-password
POSTGRESQL_SSL_MODE=prefer   # prefer, require, or disable

{
  "version": 1,
  "integrations": [
    {
      "id": "postgresql-prod",
      "service": "postgresql",
      "status": "active",
      "credentials": {
        "host": "prod-primary.postgres.example.com",
        "port": 5432,
        "database": "application_db",
        "username": "healops_readonly",
        "password": "your-password",
        "ssl_mode": "prefer"
      }
    }
  ]
}

-- Create the user
CREATE USER healops_readonly WITH PASSWORD 'secure-password';

-- Grant access to system views
GRANT pg_monitor TO healops_readonly;

-- Grant access to the target database
GRANT CONNECT ON DATABASE application_db TO healops_readonly;
\c application_db
GRANT USAGE ON SCHEMA public TO healops_readonly;
GRANT SELECT ON ALL TABLES IN SCHEMA public TO healops_readonly;

shared_preload_libraries = 'pg_stat_statements'
pg_stat_statements.track = all

CREATE EXTENSION IF NOT EXISTS pg_stat_statements;

healops integrations verify postgresql

Service: postgresql
Status: passed
Detail: Connected to PostgreSQL 16.1; target database: application_db