Re: pg_upgrade and rsync - Mailing list pgsql-hackers

From David Steele
Subject Re: pg_upgrade and rsync
Date
Msg-id 54CADB13.9020207@pgmasters.net
Whole thread Raw
In response to Re: pg_upgrade and rsync  (Jim Nasby <Jim.Nasby@BlueTreble.com>)
List pgsql-hackers
On 1/29/15 8:09 PM, Jim Nasby wrote:
> On 1/29/15 7:02 PM, David Steele wrote:
>> On 1/29/15 7:55 PM, Jim Nasby wrote:
>>> On 1/29/15 6:25 PM, David Steele wrote:
>>>> Safe backups can be done without LSNs provided you are willing to
>>>> trust
>>>> your timestamps.
>>>
>>> Which AFAICT simply isn't safe to do at all... except maybe with the
>>> manifest stuff you've talked about?
>>
>> Yes - that's what I'm talking about.  I had hoped to speak about this at
>> PgConfNYC, but perhaps I can do it in a lightning talk instead.
>
> Sounds like maybe it should be part of our documentation too...

I think the warnings Bruce has added to the documentation about using
checksums are sufficient for now.  The manifest build and delay
methodology are part of PgBackRest, the backup solution I'm working on
as an alternative to barman, etc.  It's not something that can be
implemented trivially.

--
- David Steele
david@pgmasters.net



pgsql-hackers by date:

Previous
From: Jim Nasby
Date:
Subject: Re: pg_upgrade and rsync
Next
From: Jim Nasby
Date:
Subject: Re: Parallel Seq Scan