Question

How to setup the replication to a server outside of digitalocean, as a slave-replica to an managed database?

Posted September 8, 2021 68 views
DatabasesDigitalOcean Managed PostgreSQL Database

how to setup the replication to a server outside of digitalocean, as a slave-replica to an managed database PostgreSQL (database cluster) hosted in digitalocean?

as i can see:
https://www.digitalocean.com/community/questions/local-hot-standby-slave-that-can-connect-to-a-remote-master-managed-database

https://www.digitalocean.com/community/questions/live-replication-to-managed-postresql

there is no way to do this, am i wrong?

what replication options are available and suggests to be used for the projects that need to have an external secondary DR DB for the case if DO-servers can fail or that main account is blocked?

These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.

×
Submit an Answer
1 answer

Hey @lbcmsserver,

I believe that this is not yet possible. But this sounds like it’d be super useful!

The best thing to do to get your voice heard regarding this would be to head over to our Product Ideas board and post a new idea, including as much information as possible for what you’d like to see implemented.

https://ideas.digitalocean.com/

As of the time being, for high availability, you could use the stand by nodes as explained here:

https://docs.digitalocean.com/products/databases/#high-availability

Also, you could also set up a script and run it as a corn job to backup your database to an offsite location.

Hope that helps!
- Bobby.

by Mark Drake
Cron is a time-based job scheduling daemon found in Unix-like operating systems, including Linux distributions. This guide provides an overview of how to schedule tasks using cron's special syntax on a machine running Ubuntu 18.04. It also goes over a few shortcuts one can use to make job schedules easier to write and understand.