search

heroku / heroku-buildpack-pgbouncer

Run pgbouncer in a dyno along with your application
MIT License
338 stars 136 forks source link

ERROR db1: syntax error in connstring #167

Closed danlbob closed 2 years ago

danlbob commented 2 years ago

I'm seeing connection issues when trying to connect to my AWS RDS aurora cluster.

ERROR db1: syntax error in connstring

My connection string works outside of pgbouncer and doesn't have any obvious syntax errors... postgres://username:password@host.cluster-xxxxx.us-west-1.rds.amazonaws.com/db_name?sslca=config/amazon-rds-ca-cert.pem The connection string is 217 chars long if that is a contributing factor?

I've also tried without the sslca= query param but still see the error. I'm using the PGBOUNCER_URLS env var to target the reader/writer instances.

Thanks in advance.

danlbob commented 2 years ago

The issue was no port number in the connection string. 😑