How to close Heroku Postgres Database connections

|
| By Webner

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

Solution:
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 *