Re: pg_upgrade and rsync - Mailing list pgsql-hackers

From Jim Nasby
Subject Re: pg_upgrade and rsync
Date
Msg-id 54C6D76D.3050000@BlueTreble.com
Whole thread Raw
In response to Re: pg_upgrade and rsync  (David Steele <david@pgmasters.net>)
List pgsql-hackers
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



pgsql-hackers by date:

Previous
From: Jim Nasby
Date:
Subject: Re: Shortcoming in CLOBBER_FREED_MEMORY coverage: disk buffer pointers
Next
From: Greg Stark
Date:
Subject: Re: Shortcoming in CLOBBER_FREED_MEMORY coverage: disk buffer pointers