a year ago
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?
16 Replies
a year ago
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
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?
a year ago
the pgbuncer service comes with a connection string and you should reference that instead
a year ago
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
a year ago
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?
a year ago
you should not be setting any of these variables manually, please send a screenshot of your project
a year ago
open pgboucers raw editor and change the namespace from Postgres to whatever the name of your postgres database is
a year ago
no need, please try my suggestion
a year ago
no problem!