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: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-admin(at)postgresql(dot)org
Subject: Re: [HACKERS] Point in Time Recovery
Date: 2004-07-23 00:05:13
Message-ID: 41005639.9040107@coretech.co.nz (view raw or flat)
Thread:
Lists: pgsql-adminpgsql-hackerspgsql-patches
I have tested the "cold" backup - and retested my previous scenarios 
using "hot" backup (just to be sure) . They all work AFAICS!

cheers

Mark 

Simon Riggs wrote:

>On Thu, 2004-07-22 at 21:19, Tom Lane wrote:
>  
>
>>Mark Kirkwood <markir(at)coretech(dot)co(dot)nz> writes:
>>    
>>
>>>2) Is is possible to make the recovery kick in even though pg_control 
>>>says the database state is shutdown?
>>>      
>>>
>>Yeah, I think you are right: presence of recovery.conf should force a
>>WAL scan even if pg_control claims it's shut down.  Fix committed.
>>
>>    
>>
>
>This *should* be possible but I haven't tested it.
>
>There is a code path on secondary checkpoints that indicates that crash
>recovery can occur even when the database was shutdown, since the code
>forces recovery whether it was or not. On that basis, this may work, but
>is yet untested. I didn't mention this because it might interfere with
>getting hot backup to work...
>
>Best Regards, Simon Riggs
>
>  
>

In response to

Responses

pgsql-hackers by date

Next:From: Joe ConwayDate: 2004-07-23 01:07:47
Subject: Re: Tutorial
Previous:From: eleinDate: 2004-07-22 23:57:13
Subject: Re: Tutorial

pgsql-admin by date

Next:From: Tom LaneDate: 2004-07-23 02:01:24
Subject: Re: [HACKERS] Point in Time Recovery
Previous:From: Simon RiggsDate: 2004-07-22 23:48:34
Subject: Re: [HACKERS] Point in Time Recovery

pgsql-patches by date

Next:From: Tom LaneDate: 2004-07-23 02:01:24
Subject: Re: [HACKERS] Point in Time Recovery
Previous:From: Bruce MomjianDate: 2004-07-22 23:53:22
Subject: Re: initdb authentication

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