How to close Heroku Postgres Database connections

| By Webner

Problem: Heroku Postgres Database Fatal error too many database connections for role ‘username’

1. First install Heroku toolbelt with command
a. sudo snap install heroku –classic
2. Login from command line
a. heroku login
3. Check current database connections
a. heroku pg:info –app application_name
4. Display current processes
a. heroku pg:ps –app application_name
5. Kill connections
a. heroku pg:killall –app application_name
b. heroku pg:kill procpid

Leave a Reply

Your email address will not be published. Required fields are marked *