search

Azure / azure-postgresql

Azure Database for PostgreSQL (fully managed service for PostgreSQL in Azure)
MIT License
77 stars 78 forks source link

Azure Database for Postgres Restore to point in time not working #92

Open papakpmartin opened 3 years ago

papakpmartin commented 3 years ago

I have an Azure Database for Postgres instance that I wanted to roll back a few hours to grab some rows that I'd deleted. Using these instructions I tried to roll back one hour, a few hours, and a few days, but in all cases I'm seeing that the new database that's created from the Restore event has data in it that's newer than the selected point in time.

Is there some special step that I need to take to make this work as expected?

In case it helps, the Restore screen says that it has 35 days of backups.

papakpmartin commented 3 years ago

This seems worse (or at least more confusing) than I originally thought.

I have database-x. I wanted to go back in time so I created a Restore for a point of time in the past and called this instance database-x-restore--2021-09-25t09-00-00z.

Looking at database-x-restore--2021-09-25t09-00-00z I see data more recent than the Restore point in time. (That's the original reason I filed this issue.)

But now, as I continue to work with database-x by adding new rows, I'm seeing database-x-restore--2021-09-25t09-00-00z also has those rows! but I have nothing connected to or interacting with this temporary database instance.

The original instance is a "Basic, 1 vCore(s), 10 GB" configuration, in case that matters.