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

Re: [HACKERS] Point in Time Recovery

From: Mark Kirkwood <markir(at)coretech(dot)co(dot)nz>
To: Simon Riggs <simon(at)2ndquadrant(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: [HACKERS] Point in Time Recovery
Date: 2004-07-22 01:51:04
Message-ID: 40FF1D88.30404@coretech.co.nz (view raw or flat)
Thread:
Lists: pgsql-adminpgsql-hackerspgsql-patches
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)
>
>
>  
>

In response to

Responses

pgsql-hackers by date

Next:From: Tom LaneDate: 2004-07-22 02:01:21
Subject: Re: check point segments leakage ?
Previous:From: Christopher Kings-LynneDate: 2004-07-22 01:50:31
Subject: Re: Why we really need timelines *now* in PITR

pgsql-admin by date

Next:From: Tom LaneDate: 2004-07-22 02:39:15
Subject: Re: [HACKERS] Point in Time Recovery
Previous:From: Tom LaneDate: 2004-07-22 00:43:07
Subject: Re: PITR COPY Failure (was Point in Time Recovery)

pgsql-patches by date

Next:From: Matthew T. O'ConnorDate: 2004-07-22 02:11:58
Subject: Re: autovacuum integration attempt #3
Previous:From: Bruce MomjianDate: 2004-07-22 01:01:59
Subject: Re: autovacuum integration attempt #3

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