3 months ago
Hi, we just had a major issue with our Postgres instance.
Our production DB was suddenly empty, and we had to restore from backup. At first all backups were showing the same size, and none of them restored correctly. Later the backup sizes changed and we were finally able to restore from a different backup, which did work.
So we basically had:
the DB suddenly replaced/emptied,
backups all showing identical size for a while,
then backup sizes updating later,
and only then being able to restore properly.
Can you explain what would cause:
the DB to be replaced or wiped,
backup sizes to all display the same value temporarily,
and why the correct backup only appeared later?
We didn’t delete or reset anything on our side, so we’re trying to understand what triggered this and how to prevent it in the future.
Thanks.
0 Replies