On Mon, Dec 13, 2010 at 12:48 AM, aaliya zarrin <aaliya.zar...@gmail.com> wrote: > When pg_is_in_recovery in the table changes to zero(status change)?? > At the time when recovery stops?
Ah... yep. > If switch over has to be done then, after receivibg the signal and telling > the postgres to run the startup process (got_SIGHUP = true), > shall we have to stop replication or wait for the recovery to get stop? > Can I change this pg_is_in_recovery = 0? Stopping replication and ending recovery are the same operation in this case. In the case of a crash, we do recovery just to get back to a consistent state. In the case of replication, we recover continuously until failover is performed. -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers