Greetings, * Ron (ronljohnsonjr@xxxxxxxxx) wrote: > On 1/24/19 8:11 AM, Stephen Frost wrote: > >* Ron (ronljohnsonjr@xxxxxxxxx) wrote: > >>On 1/24/19 7:26 AM, Stephen Frost wrote: > >>>* Ron (ronljohnsonjr@xxxxxxxxx) wrote: > >>>>The backups partition is running out of disk space, and I need to delete the > >>>>only backup. > >>>> > >>>>$ pgbackrest expire --stanza=localhost --retention-full=0 > >>>>ERROR: [032]: '0' is out of range for 'repo1-retention-full' option > >>>Yeah, pgbackrest doesn't ever really think you want to get rid of *all* > >>>of your backups. :) > >>It's rare, but *is* occasionally needed. > >> > >>>>So, in version 2.07, what's the secret sauce for deleting that final copy? > >>>If this is the only backup and the only cluster being backed up into > >>>that repository, you could just nuke the whole repo and recreate it with > >>>stanza-create once you're ready to have backups again.. > >>That occurred to me while lying in bed. Use "stanza-delete"? > >That's another option, > > What's the preferred method? Not sure that I have one.. > >though you'll have to use --force unless you're also shutting PG down. > > Won't be stopping postgres!!! > > Are these the steps, or am I missing something? > > $ pgbackrest stop This probably isn't really necessary. > $ pgbackrest stanza-delete --stanza=mystanza--force Well, you'd need a space before --force.. You'll also probably want to adjust your archive_command because otherwise it'll start failing and that would lead to WAL building up. Thanks! Stephen
Attachment:
signature.asc
Description: PGP signature
