Re: [pgbackrest] Expiring the last backup?

Greetings,

* Ron (ronljohnsonjr(at)gmail(dot)com) wrote:
> On 1/24/19 8:11 AM, Stephen Frost wrote:
> >* Ron (ronljohnsonjr(at)gmail(dot)com) wrote:
> >>On 1/24/19 7:26 AM, Stephen Frost wrote:
> >>>* Ron (ronljohnsonjr(at)gmail(dot)com) 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