Postgres Pro
Downloads
Home   >   mailing lists

Re: Postgres Hot Standby. How or when does the recovery db move recovery.conf to recovery.done? - Mailing list pgsql-general

From Merlin Moncure
Subject Re: Postgres Hot Standby. How or when does the recovery db move recovery.conf to recovery.done?
Date
Msg-id b42b73150703210721v3a740acay97d08e487fb25ef2@mail.gmail.com
Whole thread Raw
In response to Postgres Hot Standby. How or when does the recovery db move recovery.conf to recovery.done?  ("Dhaval Shah" <dhaval.shah.m@gmail.com>)
Responses Re: Postgres Hot Standby. How or when does the recovery db move recovery.conf to recovery.done?  ("Dhaval Shah" <dhaval.shah.m@gmail.com>)
List pgsql-general
Tree view 
On 3/21/07, Dhaval Shah <dhaval.shah.m@gmail.com> wrote:
> Resending.
>
> I have a "hot" standby. Now, if the primary fails
> how do I tell the secondary that come out of recovery mode and move
> the recovery.conf to recovery.done and start the db. I mean, what
> error code shall I return?

did you look at pg_standby utility? it has kill file mechanism that
automates this for you.

merlin

pgsql-general by date:

Previous
From: Thomas Pundt
Date:
Subject: Re: to_tsvector in 8.2.3
Next
From: "Brandon Aiken"
Date:
Subject: Re: Lifecycle of PostgreSQL releases