PostgreSQL Managed Database: What can be a reason of error `pgbouncer cannot connect to server`?

Posted September 5, 2019 7.2k views
DigitalOceanUbuntu 18.04

I’ve created a connection pool for PostgreSQL managed database. Using connection settings provided for the connection pool, I get the following error:

psql postgresql://
psql: ERROR: pgbouncer cannot connect to server

What am I doing wrong here?

These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.

Submit an Answer
1 answer

Have you allowed the 25061 port via your firewall on your droplet? And on your managed database have you allowed your droplet’s IP?