How to close Heroku Postgres Database connections

Author - Kailash Kumar

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

Webner Solutions is a Software Development company focused on developing Insurance Agency Management Systems, Learning Management Systems and Salesforce apps. Contact us at for your Insurance, eLearning and Salesforce applications.

Leave a Reply

Your email address will not be published.