Step 1: Add Log Drain
Log output support is only available on Heroku Postgres Standard, Premium and higher plans.
Log output for Heroku Postgres databases is sent to the application that the database is attached to, so we need to add a log drain to that application that forwards log lines to the pganalyze collector app running in your account.
The collector receives log drains at the following URL:
[ALIAS] value we recommend you use the add-on attachment name you've chosen
in the initial setup, which you can determine by viewing the current Heroku
configuration of your collector app:
heroku config -a [your-collector-app-name]
=== [your-collector-app-name] Config Vars TESTAPP_URL: postgres://...:...@...:.../... PGA_API_KEY: ...
So in this case we would use
TESTAPP_URL as our alias, and then we would add the log drain
heroku drains:add https://[your-collector-app-name].herokuapp.com/logs/TESTAPP_URL -a [your-app-name]
Make sure to replace
[your-collector-app-name] with the name of your own collector application
that you've deployed in your Heroku account, and
[your-app-name] with the name of your main
application (the one that owns the database for which you want to collect logs).
Couldn't find what you were looking for or want to talk about something specific?
Start a conversation with us →