From: | Erik Jones <ejones(at)engineyard(dot)com> |
---|---|
To: | Fujii Masao <masao(dot)fujii(at)gmail(dot)com> |
Cc: | Dan Hayes <dhayes501(at)gmail(dot)com>, pgsql-general(at)postgresql(dot)org |
Subject: | Re: PITR - warm standby switchover question |
Date: | 2009-04-15 22:53:06 |
Message-ID: | 63B0CE48-1FF6-489E-8A87-1D484FAA464A@engineyard.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Apr 15, 2009, at 12:42 AM, Fujii Masao wrote:
> Hi,
>
> On Wed, Apr 15, 2009 at 9:23 AM, Dan Hayes <dhayes501(at)gmail(dot)com>
> wrote:
>> Excellent! Thanks. One other quick question... What would happen
>> if I
>> didn't delete the recovery.conf file? Is that step just to prevent
>> accidentally restarting the server with it there?
>
> recovery.conf is automatically renamed recovery.done by
> postgres at the end of recovery, which would prevent
> accidentally restarting warm-standby. So, you don't need to
> delete or rename recovery.conf by hand after recovery.
Doh! Totally forgot that very nice piece of information (which is bad
as that's also why I never tested the alternate scenario mentioned in
my other response).
Erik Jones, Database Administrator
Engine Yard
Support, Scalability, Reliability
866.518.9273 x 260
Location: US/Pacific
IRC: mage2k
From | Date | Subject | |
---|---|---|---|
Next Message | Robert Haas | 2009-04-15 23:23:01 | Re: [GENERAL] Performance of full outer join in 8.3 |
Previous Message | ray | 2009-04-15 22:50:33 | Re: Part way there, how do I complete it |