Re: [HACKERS] pg_is_in_recovery=1

2010-12-13 Thread Robert Haas
On Mon, Dec 13, 2010 at 12:48 AM, aaliya zarrin 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_

[HACKERS] pg_is_in_recovery=1

2010-12-12 Thread aaliya zarrin
Hi All, When pg_is_in_recovery in the table changes to zero(status change)?? At the time when recovery stops? 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 r