From: Mark Kirkwood <markir@coretech.co.nz>
To: Simon Riggs <simon@2ndquadrant.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: [HACKERS] Point in Time Recovery
Date: Thu, 22 Jul 2004 13:51:04 +1200
Message-ID: <40FF1D88.30404@coretech.co.nz> (raw)
In-Reply-To: <1089789682.17493.3890.camel@stromboli>
References: <200407132242.i6DMgg612564@candle.pha.pa.us>
<1089760416.17493.3327.camel@stromboli>
<40F49AE9.2060805@familyhealth.com.au>
<1089789682.17493.3890.camel@stromboli>
Here is one for the 'idiot proof' category:
1) initdb and set archive_command
2) shutdown
3) do a backup
4) startup and run some transactions
5) shutdown and remove PGDATA
6) restore backup
7) startup
Obviously this does not work as the backup is performed with the
database shutdown.
This got me wondering for 2 reasons:
1) Some alternative database servers *require* a procedure like this to
enable their version of PITR - so the potential foot-gun thing is there.
2) Is is possible to make the recovery kick in even though pg_control
says the database state is shutdown?
Simon Riggs wrote:
>
>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)
>
>
>
>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: markir@coretech.co.nz, simon@2ndquadrant.com
Subject: Re: [HACKERS] Point in Time Recovery
In-Reply-To: <40FF1D88.30404@coretech.co.nz>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox