2

We have a Postgre database in Azure and we had a problem where all rows from a table where deleted. We tried using the Point In Time Restore option in de azure portal but the database that is created has the same data as the currently running database. we also tried other other dates and times.

  • database problem was at 06-05-21 - 10:30 AM.
  • restore database was set to 06-05-21 - 10:25 AM. (same data as currently running database)
  • restore database was set tot 05-05-21 - 11:50 PM. (same data as currently running database)

What step are we missing.

Jeroen van Heel
  • 53
  • 5
  • Can you confirm you restore db successfully done without any issue ?https://learn.microsoft.com/en-us/azure/postgresql/howto-restore-server-portal and check the problem occurrence time as well – Rahul Shukla May 06 '21 at 13:38
  • @RahulShukla The restore was done without a issue. Today I tested the restore on a new database server and everything was working as expected. Going to test some more on our current database. Keep you updated. – Jeroen van Heel May 07 '21 at 05:36
  • @JeroenvanHeel, did you have a lot of FW rules and VNET service endpoints associated to the database ? Once you restore in the new server, those are lost. Have you find a way to do that automatically ? – Roberto Hernandez Aug 26 '21 at 07:26

0 Answers0