Join us for our webinar on June 18th, 9:30am Pacific Time: Optimizing slow queries with EXPLAIN to fix bad query plans - register now.

Enterprise Server: How to Set Up Slack and PagerDuty Integration

In order to provide notifications about issues discovered in your database, pganalyze provides support for integrating with Slack or PagerDuty. These integrations require additional setup for pganalyze Enterprise Server.

Slack

First you will need to create your own Slack "app". You should be able to follow the Slack instructions. It does not need to be a published app. Once this is done, go through the following:

  1. Under Oauth & Permissions in the Slack app, the redirect URLs should include the address where you're hosting pganalyzee.g., https://app.pganalyze.com for the public pganalyze app
  2. On the same page, the Scopes should be "channels:read" and "chat:write"
  3. Copy the generated Client ID and Client Secret and set those as environment variables SLACK_CLIENT_ID and SLACK_CLIENT_SECRET in your pganalyze container configuration
  4. Restart the pganalyze Enterprise Server container to apply the new configuration
  5. Install your Slack app to your Slack workspace: You can do this in Slack through the Apps section in the left-hand menu
  6. In pganalyze, go to the Integrations tab in the Settings page and enable the Slack integration

PagerDuty

You will need to create a new integration in PagerDuty. You should be able to follow the PagerDuty instructions. Once this is done, go through the following:

  1. Under Event Integration in PagerDuty, the Simple Install Flow should include the address where you're hosting pganalyzee.g., https://app.pganalyze.com for the public pganalyze app (make sure to save your changes when done)
  2. Copy the app_id from Integration Setup URL in that same section section (note that this is not the same id you see in the URL bar), and add that as the PAGERDUTY_APP_ID environment variable to your pganalyze configuration
  3. Restart the pganalyze Enterprise Server container to apply the new configuration
  4. In pganalyze, go to the Integrations tab in the Settings page and enable PagerDuty integration

Couldn't find what you were looking for or want to talk about something specific?
Start a conversation with us →