Re: pg_upgrade and rsync

On 1/26/15 5:08 PM, David Steele wrote:
> I've written tests to show the rsync vulnerability and another to show
> that this can affect a running database.  However, to reproduce it
> reliably you need to force a checkpoint or have them happening pretty
> close together.

Related to this and Stephen's comment about testing... ISTM it would be very useful to have a published suite of tests
forPITR backups, perhaps even utilizing special techniques in Postgres to expose potential failure conditions.
Similarly,it'd also be nice to have a suite of tests you could run to validate a backup that you've restored.
 
-- 
Jim Nasby, Data Architect, Blue Treble Consulting
Data in Trouble? Get it in Treble! http://BlueTreble.com