How to restore Azure database for postgre single server, if it's Redundancy option is configured as Geo-restore

Himanshu Garg 0 Reputation points
2024-03-21T18:32:42.51+00:00

Hello,

I have one production Azure database postgre single server which is configured as below

Backup Redundancy options: Geo-restore

Backup Retention Period: 7days

If I want to restore this database using Azure portal which is configured as Geo-restore.

Then it will show me the point in time option or not?

Any option to select the date and time for which I need to restore it?

Restore will able to create a new postgre SQL single server or not, as from Azure portal now we are not getting options to create it because it's getting retired soon.

Azure Database for PostgreSQL
0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. GeethaThatipatri-MSFT 27,567 Reputation points Microsoft Employee
    2024-03-21T19:02:21.24+00:00

    Hi, @Himanshu Garg Welcome to Microsoft Q&A thanks for posting your question.

    I understand you want to know how to restore an Azure database for Postgres single server if its redundancy option is configured as Geo-restore.

    Point-in-time restore (PITR) is not currently supported on Geo-restore for Azure Database for PostgreSQL single server. however, you should be able to restore and yes it will create a single server.

    also, we recommend migrating to from single server to flexible server as it is getting retired soon.

    Let me know if you have any additional questions.

    Regards

    Geetha

  2. Himanshu Garg 0 Reputation points
    2024-03-22T06:15:06.59+00:00

    Hi @GeethaThatipatri-MSFT thanks for your response.

    So, it means we don't have the backup of last 7days in Geo-restore.

    If we will restore the Azure Database for PostgreSQL single server for Geo-restore then it will create the copy of our database in different region with the current date and time only???

    Actually my requirement is, We lost some table or data for database inside my Azure Database for PostgreSQL single server and I want to restore it with the past 2days backup, so what are the required options I can use?