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

September 5, 2019 76 views
DigitalOcean Ubuntu 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?

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?

Have another answer? Share your knowledge.