6 months ago
How could I do this two actions:
The source database must have pglogical extension installed.
no pglogical extension installed on databases: postgres; railway
The source database 'wal_level' configuration must be equal to 'logical'.
wal_level should be set to logical instead of replica
I am implementing redundancy of my database on real time, so if the service colapses (has happen two times in the past I have a real time backup)
10 Replies
6 months ago
Hopefully I want to make this changes without time downs, but if it has I need to plan a hour and date
6 months ago
You can make use of the HA Postgres. https://railway.app/template/ha-postgres
Check here: https://docs.railway.app/guides/postgresql#deploy-1
Status changed to Awaiting User Response railway[bot] • 7 months ago
6 months ago
Yeah but I need a database that is synced in real time with my in another provider (as railway failed in the past). If I use that template is a bit the same problem
Status changed to Awaiting Railway Response railway[bot] • 7 months ago
6 months ago
I'm not sure I understand what you mean. Please can you clarify better?
Status changed to Awaiting User Response railway[bot] • 7 months ago
6 months ago
I need to install this:
The source database must have pglogical extension installed.
no pglogical extension installed on databases: postgres; railway
The source database 'wal_level' configuration must be equal to 'logical'.
wal_level should be set to logical instead of replica
To my existing postgres database that is running
Status changed to Awaiting Railway Response railway[bot] • 7 months ago
6 months ago
I would highly recommend you use the HA Postgres template, by default it will deploy each replica into a different region, thus achieving your desired results.
Status changed to Awaiting User Response railway[bot] • 7 months ago
6 months ago
More than that I need to replicate the postgres in another service outside railway just in case
Status changed to Awaiting Railway Response railway[bot] • 7 months ago
6 months ago
Then you would need to create a Postgres image with those extensions installed / enabled.
Status changed to Awaiting User Response railway[bot] • 7 months ago
6 months ago
Any image suggestion? Or a railway base image code and I can enable it changing it and having railway one as a base
Status changed to Awaiting Railway Response railway[bot] • 7 months ago
6 months ago
Hi, I think you can just use any Postgres image on Dockerhub and build upon that.
Status changed to Awaiting User Response railway[bot] • 6 months ago