Skip to content

Configuration Examples

The following examples show minimal, production, and development configurations for the Collector.

Minimal Configuration

This example shows the minimum settings required by the Collector.

datastore:
  host: localhost
  database: ai_workbench
  username: collector
  password_file: /etc/ai-workbench/password.txt

Production Configuration

This example shows a production configuration with SSL verification and a connection pool.

datastore:
  host: db.internal.example.com
  database: ai_workbench_prod
  username: ai_workbench
  password_file: /var/secrets/password.txt
  port: 5432
  sslmode: verify-full
  sslcert: /etc/ai-workbench/certs/client.pem
  sslkey: /etc/ai-workbench/certs/client-key.pem
  sslrootcert: /etc/ai-workbench/certs/ca.pem

pool:
  datastore_max_connections: 100
  datastore_max_idle_seconds: 300
  datastore_max_wait_seconds: 60
  max_connections_per_server: 10
  monitored_max_idle_seconds: 300
  monitored_max_wait_seconds: 120

connection_security:
  ssl_cert_dir: /etc/pgedge/ai-dba-workbench/certs

secret_file: /var/secrets/collector.secret

Development Configuration

This example shows a local development configuration with SSL disabled and a small connection pool.

datastore:
  host: localhost
  database: ai_workbench_dev
  username: postgres
  port: 5432
  sslmode: disable

pool:
  datastore_max_connections: 10
  max_connections_per_server: 3

secret_file: ./ai-dba-collector.secret