9 months ago
We need to create a RO replica for our PG DB in a project but get the message "Replication is not available for services that have a cron schedule or a volume attached."
Pinned Solution
9 months ago
There is also a HA pg template that comes with 3 pg nodes with repmgr and pgpool for built-in failovers, connection pooling, load balancing etc.
https://railway.com/deploy/ha-postgres
3 Replies
9 months ago
This thread has been marked as public for community involvement, as it does not contain any sensitive or personal information. Any further activity in this thread will be visible to everyone.
Status changed to Open brody • 9 months ago
9 months ago
Railway doesn't support replicas for services with volumes attached. If you need to create RO replica(s) of a master then you need to create them as a separate services with their own separate volumes attached since no 2 containers must access the same volume.
Then by writing 2 custom postgres.conf file (1 for master and 1 for replicas) to have replicas sync to master.
For backups, you backup just the master and have replica disposables.
Do let me know if you need help with this.
9 months ago
There is also a HA pg template that comes with 3 pg nodes with repmgr and pgpool for built-in failovers, connection pooling, load balancing etc.
https://railway.com/deploy/ha-postgres
9 months ago
Hey aesop7, is this still an issue ?
Status changed to Solved chandrika • 9 months ago