remove_database_snapshot when S3 bucket gone
Hi,
I have an 5 month older database snapshot that i noticed today. I cant recall the details of that backup job, but the command to clean up and remove this snapshot fails due to S3 backup bucket being unavailable.
What is the proper way to clean up ?
dbadmin=> select remove_database_snapshot('snapshotname');
WARNING 2919: Could not stat file [s3://bucket/*/Snapshots/snapshotname]: The specified bucket does not exist
....
remove_database_snapshot
Removed:
(1 row)
Thanks in advance.
Tagged:
0
Answers
Can you try the below and see if it helps. Do you have more than 1 restore point associated with that snapshot?
select remove_database_snapshot('snapshot_test','true');
No, unfortunately , the outcome is the same. I assume the restore point information was saved on s3://<> , but that bucket is gone, so i cant really check that out. There must be a way to clean up a local DB snapshot.
Please try to run to see if it helps.
vbr -t collect-garbage -c configfile.ini