Report this

What is the reason for this report?

Managed Postgres Logical Streaming or WAL Replication from DO to outside DO

Posted on August 26, 2019

Hi, interested in using DO for a managed Postgres cluster.

As we know the risks of relying on a single cloud provider are great, as sometimes accidents happen and cloud providers lock customers out of accounts by accident.

[I won’t mention specific instances, but all the big cloud providers have had accidental customer lock-out accidents, creating customer down-time]

I would LOVE! to use a DO managed PG cluster for our service.

But!, WE ABSOLUTELY must have live Logical Replication (Publish/Subscribe) or WAL streaming from DO to servers outside Digital Ocean for business continuity and SLA type agreements.

We can do this today, by hand with non-managed solutions.

Is this possible today with DO’s managed Postgres offering?

If not, would you mind forwarding this request to the product manager, for feedback.

I feel and suspect other CTOs will require this type of capability before moving super critical postgres infrastructure to DO’s managed Postgres.

If you have this now, awesome!, can’t wait to get started, if not, can’t wait until you do.

Thank you Cameron



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.

Hi,

We would also be interested in that feature. We have employees in China and the GFW makes reading data from DO Postgres cluster super slow. Writing data is alright cause they mostly have to read and our job queue for writing data works well.

Thank you.

Hello,

Just came across this answer and decided to write some general guidelines for anyone who comes across this in the future despite the old question.

As of now, DigitalOcean Managed Databases for PostgreSQL only support replication within the DigitalOcean platform. Nonetheless, I understand the importance of external replication for business continuity and SLAs. While I can’t forward your request directly to the product manager, I suggest visiting the DigitalOcean Community Ideas page to submit your feature request. Our team reviews these suggestions regularly.

In the meantime, you may consider using a non-managed PostgreSQL solution and configuring logical replication or WAL streaming manually, as you mentioned, to meet your requirements.

For more information on DigitalOcean Managed Databases, please refer to our documentation.

Hope that this helps!

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.