Re: Postgres Hot Standby. How or when does the recovery db move recovery.conf to recovery.done?

From: "Merlin Moncure" <mmoncure(at)gmail(dot)com>
To: "Dhaval Shah" <dhaval(dot)shah(dot)m(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Postgres Hot Standby. How or when does the recovery db move recovery.conf to recovery.done?
Date: 2007-03-21 14:21:15
Message-ID: b42b73150703210721v3a740acay97d08e487fb25ef2@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 3/21/07, Dhaval Shah <dhaval(dot)shah(dot)m(at)gmail(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Brandon Aiken 2007-03-21 14:25:24 Re: Lifecycle of PostgreSQL releases
Previous Message Robert Treat 2007-03-21 14:01:26 Re: phpPgAdmin - prior version available?