Skip site navigation (1) Skip section navigation (2)

Re: [HACKERS] Point in Time Recovery

From: Gaetano Mendola <mendola(at)bigfoot(dot)com>
To: Simon Riggs <simon(at)2ndquadrant(dot)com>
Subject: Re: [HACKERS] Point in Time Recovery
Date: 2004-07-17 09:39:07
Message-ID: 40F8F3BB.8030002@bigfoot.com (view raw or flat)
Thread:
Lists: pgsql-adminpgsql-hackerspgsql-patches
Simon Riggs wrote:

> On Wed, 2004-07-14 at 03:31, Christopher Kings-Lynne wrote:
> 
>>Can you give us some suggestions of what kind of stuff to test?  Is 
>>there a way we can artificially kill the backend in all sorts of nasty 
>>spots to see if recovery works?  Does kill -9 simulate a 'power off'?
>>
> 
> 
> I was hoping some fiendish plans would be presented to me...
> 
> But please start with "this feels like typical usage" and we'll go from
> there...the important thing is to try the first one.
> 
> I've not done power off tests, yet. They need to be done just to
> check...actually you don't need to do this to test PITR...
> 
> We need to exhaustive tests of...
> - power off
> - scp and cross network copies
> - all the permuted recovery options
> - archive_mode = off (i.e. current behaviour)
> - deliberately incorrectly set options (idiot-proof testing)

If you write also how to perform these tests it's also good in order to show
which problem PITR is addressing, I mean I know that is addressing a power off
but how I will recover it ?


Regards
Gaetano Mendola






In response to

pgsql-hackers by date

Next:From: Gaetano MendolaDate: 2004-07-17 13:24:53
Subject: NT and aborted transaction
Previous:From: Bruce MomjianDate: 2004-07-17 00:39:29
Subject: Release status report

pgsql-admin by date

Next:From: Gaetano MendolaDate: 2004-07-17 10:07:11
Subject: Re: Replication in main PostgreSQL codebase
Previous:From: Oliver ElphickDate: 2004-07-17 08:39:41
Subject: Re: add to table which name is in table

pgsql-patches by date

Next:From: Christopher Kings-LynneDate: 2004-07-17 10:01:54
Subject: Re: pg_autovacuum integration attempt #2
Previous:From: Matthew T. O'ConnorDate: 2004-07-17 05:48:47
Subject: Re: pg_autovacuum integration attempt #2

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group