Report this

What is the reason for this report?

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

Posted on September 8, 2021

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?



This textbox defaults to using Markdown to format your 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.

The developer cloud

Scale up as you grow — whether you're running one virtual machine or ten thousand.

Get started for free

Sign up and get $200 in credit for your first 60 days with DigitalOcean.*

*This promotional offer applies to new accounts only.