c0958e3e-4cd8-4f89-9376-7c4003820f57

that service may use the postgres icon, but it does not come with a database, that is just the bouncer service.

if your current postgres database is named Postgres then you will not need any config to hook the bouncer service up to your existing database when you deploy the template into your project

Would I then use the same connection string and append ?pgbouncer=true ?

It looks like this deploys pgBouncer to a new project. Is this correct or should it be deployed to the project I need it for?

the pgbuncer service comes with a connection string and you should reference that instead

yes deploying from the template page would deploy it into a new project, if you open your existing project first then click create and choose the template it will deploy into the same project

ok got it thanks!

no problem!

It provisioned the template in my project but these variables are empty strings so it crashes:

PGBOUNCER_DATABASE
POSTGRESQL_DATABASE
POSTGRESQL_HOST
POSTGRESQL_PASSWORD
POSTGRESQL_USERNAME

I assume I take the POSTGRESQL variables from my database but then what do I use for PGBOUNCER_DATABASE?

you should not be setting any of these variables manually, please send a screenshot of your project

I noticed my DB name is not Postgres

open pgboucers raw editor and change the namespace from Postgres to whatever the name of your postgres database is

SHould I rename the db and redeploy?

no need, please try my suggestion

Success! Thank you

no problem!