Azure Database for PostgreSQL
An Azure managed PostgreSQL database service for app development and deployment.
How to recover a deleted Azure Postgresql server in Azure US Government Cloud?
![](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(96, 16%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESV%3C/text%3E%3C/svg%3E)
Sachin Vettiyattil
21
Reputation points
We accidentally deleted an Azure PostgreSQL Flexible Server that was still being used by one of our legacy services.
I’ve already gone through the steps outlined in the official Microsoft documentation: "Restore a dropped Azure Database for PostgreSQL server" to attempt recovery. However, it appears that the guidance provided may be specific to Azure Public Cloud.
We’re working within Azure Government Cloud, and I’m wondering if there’s a way to recover the deleted flexible server in this environment?
Any help or insights would be greatly appreciated.
Azure Database for PostgreSQL
{count} votes
-
![](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(249.60000000000002, 51%, 34%)' 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)
Adithya Prasad K 1,380 Reputation points Microsoft External Staff Moderator2025-03-14T00:43:03.2633333+00:00 Hi Sachin Vettiyattil
Restore Azure PostgreSQL-Flexible databaseFollow these steps:
Go to Backup vault > Backup Instances. Select the PostgreSQL-Flex server to be restored and select Restore.
Alternatively, go to Backup center and select Restore.
Select the point in time you would like to restore by using Select restore point. Change the date range by selecting Time period.
Choose the target storage account and container in Restore parameters tab. Select Validate to check the restore parameters permissions before the final review and restore.
Once the validation is successful, select Review + restore.
After final review of the parameters, select Restore to restore the selected PostgreSQL-Flex server backup in target storage account.
Submit the Restore operation and track the triggered job under Backup jobs.
Once the job is finished, the backed-up data is restored into the storage account. Below are the set of files recovered in your storage account after the restore:
The first file is a marker or timestamp file that gives the customer the time the backup was taken at. The file cannot be restored but if opened with a text editor should tell the customer the UTC time when the backup was taken.
The Second file ***database*** is an individual database backup for database called tempdata2 taken using pg_dump. Each database has a separate file with format **– {backup_name}*database*{db_name}.sql** The Third File **_roles**. Has roles backed up using pg_dumpall The Fourth file **_schemas**. backed up using pg_dumpall The Fifth file **_tablespaces**. Has the tablespaces backed up using pg_dumpall Post restoration completion to the target storage account, you can use pg_restore utility to restore the database and other files to a PostgreSQL Flexible server. Use the following command to connect to an existing postgresql flexible server and an existing database `az storage blob download --container-name <container-name> --name <blob-name> --account-name <storage-account-name> --account-key <storage-account-key> --file - | pg_restore -h <postgres-server-url> -p <port> -U <username> -d <database-name> -v -` - `--account-name`: Name of the Target Storage Account. - `--container-name`: Name of the blob container. - `--blob-name`: Name of the blob. - `--account-key`: Storage Account Key. - `-Fd`: The directory format. - `-j`: The number of jobs. - `-C`: Begin the output with a command to create the database itself and then reconnect to it. If you have more than one database to restore, re-run the earlier command for each database. Also, by using multiple concurrent jobs **-j**, you can reduce the time it takes to restore a large database on a multi-vCore target server. The number of jobs can be equal to or less than the number of vCPUs that are allocated for the target server.- To restore the other three files (roles, schema and tablespaces), use the psql utility to restore them to a PostgreSQL Flexible server.
az storage blob download --container-name <container-name> --name <blob-name> --account-name <storage-account-name> --account-key <storage-account-key> --file - | psql -h <hostname> -U <username> -d <db name> -f <dump directory> -v -Re-run the above command for each file. I would request you to refer the below mentioned links for more information
https://learn.microsoft.com/en-us/azure/backup/restore-azure-database-postgresql-flex?source=recommendations I hope this information helps. Please do let us know if you have any further queries.
- To restore the other three files (roles, schema and tablespaces), use the psql utility to restore them to a PostgreSQL Flexible server.
-
Sachin Vettiyattil 21 Reputation points
2025-03-14T04:27:31.36+00:00 Hello @Adithya Prasad K
Thank you for your response.
In my case, I don’t have a dedicated Backup Vault or any manual backups of the PostgreSQL server—only the default automated backups that were available at the time of server creation.
As I mentioned in my earlier post, in Azure Public Cloud, it's possible to recover the database using the Create Server REST API by updating the request body with the appropriate values for
"dropped server location","submissionTimestamp", and"resourceId".The challenge I’m facing is that when I attempt to use the "Try it" option, the request defaults to connecting with Azure Public Cloud, and not Azure US Government, which is the environment I'm working in.
Any guidance on how to proceed with this in the Azure Government Cloud context would be greatly appreciated.
Sign in to comment
Sign in to answer