Question
Is it possible to use the PostgreSQL migration feature when using the DOKS Database Operator?
- Posted on February 20, 2023
- DigitalOcean Managed KubernetesDigitalOcean Managed PostgreSQL Database
Asked by Hidde Jansen
Hi, I have a Managed PostgreSQL Database at DigitalOcean, which is attached and managed by a DigitalOcean Kuberenetes (DOKS) Database Operator. From the documentation, I gathered that it is not recommended to use control panel features to edit settings of Database Operator managed databases.
However, I have a PostgreSQL database self-hosted with another provider that I would want to migrate to this Managed Database at DigitalOcean. I noticed that DigitalOcean offers a PostgreSQL migration service through the control panel, which would be helpful for this. However, I wasn’t sure if this feature would work, given the information above. The operator documentation lists “migrating database clusters between region” as a current limitation. Is that referring to the PostgreSQL migration feature, or some other migration feature within DigitalOcean?
Thanks in advance!
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 there,
I believe that this should work as expected. You should be able to do this via your control panel directly.
The migration across regions is moving the database cluster itself from let’s say NYC to SFO for example.
On another note, all standard limitations listed here also apply:
https://docs.digitalocean.com/products/databases/postgresql/details/limits
Hope that this helps!
Best,
Bobby