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 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin pgsql-hackers pgsql-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
From | Date | Subject | |
---|---|---|---|
Next Message | Gaetano Mendola | 2004-07-17 10:07:11 | Re: Replication in main PostgreSQL codebase |
Previous Message | Oliver Elphick | 2004-07-17 08:39:41 | Re: add to table which name is in table |
From | Date | Subject | |
---|---|---|---|
Next Message | Gaetano Mendola | 2004-07-17 13:24:53 | NT and aborted transaction |
Previous Message | Bruce Momjian | 2004-07-17 00:39:29 | Release status report |
From | Date | Subject | |
---|---|---|---|
Next Message | Christopher Kings-Lynne | 2004-07-17 10:01:54 | Re: pg_autovacuum integration attempt #2 |
Previous Message | Matthew T. O'Connor | 2004-07-17 05:48:47 | Re: pg_autovacuum integration attempt #2 |