Step 4: Configure the Collector
Configuring the collector
The collector configuration file lives in /etc/pganalyze-collector.conf
, and looks like this:
[pganalyze]
api_key = your_pga_organization_api_key
[server1]
db_host = localhost
db_name = your_database_name
db_username = your_monitoring_user
db_password = your_monitoring_user_password
Fill in the values step-by-step:
- The
api_key
can be found in the pganalyze Settings page for your organization, under the API keys tab - The
db_host
is the hostname of your PostgreSQL instance (usuallylocalhost
) - The
db_name
is the database on the PostgreSQL server you want to monitor - The
db_username
anddb_password
should be the credentials of the monitoring user we created in Step 1
Testing the new configuration
Run the following to make sure the configuration works:
sudo pganalyze-collector --test
Once you've confirmed the install is successful and you're receiving query data in pganalyze, we recommend setting up Log Insights as a follow-up step, to automatically track log events in your database.
Couldn't find what you were looking for or want to talk about something specific?
Start a conversation with us →