Question

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

Posted September 5, 2019 3k 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://user:password@host.db.ondigitalocean.com:25061/pool-name?sslmode=require
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.

×
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?

Submit an Answer