I need to install pglogical into my running postgres server
vambe
PROOP

a year 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)

Solved

10 Replies

vambe
PROOP

a year 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

a year 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 over 1 year ago


vambe
PROOP

a year 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 over 1 year ago


unicodeveloper
PRO

a year ago

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


Status changed to Awaiting User Response Railway over 1 year ago


vambe
PROOP

a year 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 over 1 year ago


brody
EMPLOYEE

a year 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 over 1 year ago


vambe
PROOP

a year 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 over 1 year ago


brody
EMPLOYEE

a year ago

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


Status changed to Awaiting User Response Railway over 1 year ago


vambe
PROOP

a year 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 over 1 year ago


unicodeveloper
PRO

a year ago

Hi, I think you can just use any Postgres image on Dockerhub and build upon that.


Status changed to Awaiting User Response Railway over 1 year ago


Railway
BOT

5 months ago

This thread has been marked as solved automatically due to a lack of recent activity. Please re-open this thread or create a new one if you require further assistance. Thank you!

Status changed to Solved Railway 6 months ago


Loading...