I need to install pglogical into my running postgres server

vambePRO

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)

Awaiting User Response

10 Replies

vambePRO

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


unicodeveloperEMPLOYEE

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


vambePRO

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


unicodeveloperEMPLOYEE

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


vambePRO

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


vambePRO

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


vambePRO

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


unicodeveloperEMPLOYEE

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