How to close Heroku Postgres Database connections

Author - Kailash Kumar
28.06.2019
|
0 Comments
|
Big Data, Cloud
|
Post Views: 3,232

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

Related posts:

  1. Heroku | The datasource configuration “default” was not found in database.php
  2. Adding Multiple database server connections in PHPmyAdmin
  3. PostgreSQL | Create a connection to a local postgres database in pgAdmin |||
  4. Heroku | How to delete prior database backups
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.