Question
How to setup the replication to a server outside of digitalocean, as a slave-replica to an managed database?
- Posted September 8, 2021
- 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.
Try DigitalOcean for free
Click below to sign up and get $100 of credit to try our products over 60 days!
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.
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.