Re: How safe is pg_basebackup + continuous archiving? - Mailing list pgsql-general

From Jim Nasby
Subject Re: How safe is pg_basebackup + continuous archiving?
Date
Msg-id d64ef5e5-6de1-3e91-7e97-9fbd86194556@BlueTreble.com
Whole thread Raw
In response to Re: How safe is pg_basebackup + continuous archiving?  (Stephen Frost <sfrost@snowman.net>)
List pgsql-general
On 6/30/16 8:30 AM, Stephen Frost wrote:
>> > How can we check for backup corruption in this case? Thanks you very much.
> There has been some discussion about a specific tool for checking the
> checksums throughout the entire system.  I don't know of anyone activly
> working on that, unfortunately.

If someone did want that though, it could probably be done as an
extension. I believe you just have to pull all of each relation into
shared buffers for the checksums to be verified.
--
Jim Nasby, Data Architect, Blue Treble Consulting, Austin TX
Experts in Analytics, Data Architecture and PostgreSQL
Data in Trouble? Get it in Treble! http://BlueTreble.com
855-TREBLE2 (855-873-2532)   mobile: 512-569-9461


pgsql-general by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: 9.6 beta2 win-x64 download links still point to beta1
Next
From: "Sfiligoi, Igor"
Date:
Subject: Re: --EXTERNAL--Re: PSQL does not remove obvious useless joins