"server does not support SSL, but SSL was required" error appearing when starting PgBouncer #202
Description
pid=20 tid=418 WARN: ActiveRecord::ConnectionNotEstablished: connection to server at "127.0.0.1", port 6000 failed: server does not support SSL, but SSL was required
I have an app on Heroku where after adding the buildpack and then adding the bin/start-pgbouncer to my run commands I get the above error. The interesting part is that I have a second staging app on Heroku with the same codebase that is able to run without the above error.
Primary difference I can tell is that staging is on Standard 0 Postgres 15.13 and main is on Standard 4 15.13. Staging also is on heroku-24 vs main app's heroku-22.
Looking into the script, we should be switching over to the DATABASE_URL_PGBOUNCER env which doesn't have an SSL string but not sure why in this specific app it gets retained.