Question

How to setup the replication to a server outside of digitalocean, as a slave-replica to an managed 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?

Subscribe
Share

Submit an answer
You can type!ref in this text area to quickly search our full set of tutorials, documentation & marketplace offerings and insert the link!

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.

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.