Software engineering facts, information, and skills categorized as pgbouncer

PG::Error (FATAL: too many connections for role "xxxxxxx")

Varghese Chacko 1 year, 4 months ago

PostgreSQL could be configured to limit number of simultaneous connections to the database. The heroku comes with plans having connection limits. The 'Hopby' plans comes with 20 connections where as standard plans comes startings with 120 conection. When we start developing and testing, especially automated testings, the hobby plans raise error PG::Error (FATAL: too many connections for role "xxxxxxx"). If we check the connections with heroku cli, we get