Related

Join the DigitalOcean Community Community

Join 1M+ other developers and:

  • Get help and share knowledge in Q&A
  • Subscribe to topics of interest
  • Get courses & tools that help you grow as a developer or small business owner
 Join Now
How to disable read-only mode when managed database storage is full? Question Question
Database cluster constant connection Question Question

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?

Add a comment
lbcmsserver
By:
lbcmsserver

Related

Join the DigitalOcean Community Community

Join 1M+ other developers and:

  • Get help and share knowledge in Q&A
  • Subscribe to topics of interest
  • Get courses & tools that help you grow as a developer or small business owner
 Join Now
How to disable read-only mode when managed database storage is full? Question Question
Database cluster constant connection Question Question

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
bobbyiliev September 10, 2021

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.

How To Use Cron to Automate Tasks on Ubuntu 18.04
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.
Reply Report

Related

Looking for something else?

Ask a new question Search for more help