Re: [pgbackrest] Expiring the last backup? - Mailing list pgsql-general

From Stephen Frost
Subject Re: [pgbackrest] Expiring the last backup?
Date
Msg-id 20190124151327.GO2528@tamriel.snowman.net
Whole thread Raw
In response to Re: [pgbackrest] Expiring the last backup?  (Ron <ronljohnsonjr@gmail.com>)
List pgsql-general
Greetings,

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

Attachment

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Casting Integer to Boolean in assignment
Next
From: Adrian Klaver
Date:
Subject: Re: Casting Integer to Boolean in assignment