How to close Heroku Postgres Database connections

Author - Kailash Kumar
28.06.2019
|
0 Comments
||

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

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

Leave a Reply

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