Re: Backup "Best Practices"

From: Israel Brewster <israel(at)ravnalaska(dot)net>
To: John R Pierce <pierce(at)hogranch(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Backup "Best Practices"
Date: 2016-11-23 19:50:08
Message-ID: 429924E6-88AC-400D-9DCB-19EDE1C46C04@ravnalaska.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Nov 23, 2016, at 10:31 AM, John R Pierce <pierce(at)hogranch(dot)com> wrote:
>
> On 11/23/2016 11:20 AM, Israel Brewster wrote:
>> How do I determine which those are? Just based on the timestamp if the WAL file, such that I could do something like take the timestamp of the last basebackup and delete all WAL files older than that? Or is there a better way?
>
> there's a tool, barman, I've never used but its supposed to greatly simplify this whole process...
>
> http://www.pgbarman.org/ <http://www.pgbarman.org/>

Definitely looks like something to try. Thanks!

-----------------------------------------------
Israel Brewster
Systems Analyst II
Ravn Alaska
5245 Airport Industrial Rd
Fairbanks, AK 99709
(907) 450-7293
-----------------------------------------------
>
> --
> john r pierce, recycling bits in santa cruz
>
>
>
> --
> Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Joe Conway 2016-11-23 19:59:11 Re: Backup "Best Practices"
Previous Message John R Pierce 2016-11-23 19:31:21 Re: Backup "Best Practices"