How to add pgBouncer to existing Postgres database
Are there any guide on adding pgBouncer to an existing Postgres DB on Railway?
I saw this template but I'm sure this deploys a brand new DB?
https://railway.app/template/OpUzwe
Solution:Jump to solution
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...15 Replies
Project ID:
c0958e3e-4cd8-4f89-9376-7c4003820f57c0958e3e-4cd8-4f89-9376-7c4003820f57
Solution
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 projectWould 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:
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
Postgresopen pgboucers raw editor and change the namespace from
Postgres to whatever the name of your postgres database isSHould I rename the db and redeploy?
no need, please try my suggestion
Success! Thank you
no problem!