This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(291.2, 28.000000000000004%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAP%3C/text%3E%3C/svg%3E)
Is it possible to restore a postgres database from one server to another server using Azure APIs?
An Azure managed PostgreSQL database service for app development and deployment.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(220.8, 4%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESM%3C/text%3E%3C/svg%3E)
Hi
Alec Pasion •,
Welcome to Microsoft Q&A forum and thanks for using Azure Services.
As I understand, you want know if it is possible to restore a postgres database from one server to another server using Azure APIs.
I am checking on the ask internally and will get back to you. Thank you
Hi
Alec Pasion •,
In addition to the below answer, as per the internal team, Restoration can only be done with the same DB type, i.e. you cannot use single server's backup to restore a flexible server.
Please let us know if you have further questions. Thank you.
Hello,
I was not clear enough on my question. I have two azure postgres flexible servers that I use with the same databases. One for testing and one for production. I am wondering if I can restore a database from my production server to my testing server through the Azure API, so I don't need to manually do it using postgres commands.
Hi
Alec Pasion •,
Thank you.
Could you please check below listed documentation if not already did:
Restore Azure PostgreSQL databases using Azure data protection REST API
Restore a dropped Azure Database for PostgreSQL server
Restore your Azure Database for PostgreSQL server into a different Azure subscription, the right way.
Please check if above is useful for your usecase. Awaiting your reply. Thanks
Hi
Alec Pasion •,
Just checking if you were able to check previous comment and would let us know if this helped?
Thanks
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(236.8, 79%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ER%3C/text%3E%3C/svg%3E)
Hi @Alec Pasion
Thanks for your question.
While searching, I came across a document related to the Azure Database for PostgreSQL REST API.
You can create a database as a point in time restore using below REST API.
Please check and let us know if this helps.
Thank you!
Hello,
I was not clear enough on my question. I have two azure postgres flexible servers that I use with the same databases. One for testing and one for production. I am wondering if I can restore a database from my production server to my testing server through the Azure API, so I don't need to manually do it using postgres commands.