I need to install pglogical into my running postgres server

vambe
PRO

10 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)

Awaiting User Response

10 Replies

vambe
PRO

10 months ago

Hopefully I want to make this changes without time downs, but if it has I need to plan a hour and date


unicodeveloper
PRO

10 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 10 months ago


vambe
PRO

10 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 10 months ago


unicodeveloper
PRO

10 months ago

I'm not sure I understand what you mean. Please can you clarify better?


Status changed to Awaiting User Response Railway 10 months ago


vambe
PRO

10 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 10 months ago


10 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 10 months ago


vambe
PRO

10 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 10 months ago


10 months ago

Then you would need to create a Postgres image with those extensions installed / enabled.


Status changed to Awaiting User Response Railway 10 months ago


vambe
PRO

10 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 10 months ago


unicodeveloper
PRO

10 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 10 months ago