Question

remove_database_snapshot when S3 bucket gone

Forum|Forum|6 years ago
April 10, 2020
3 replies
17 views

+2

colin_loghin
Participating Frequently

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.

+1

SruthiA
Participating Frequently
Forum|Forum|6 years ago
April 10, 2020

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');

Like

+2

colin_loghin
Author
Participating Frequently
Forum|Forum|6 years ago
April 10, 2020

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.