Restart Issue in Cluster environment

From: "Itnal, Prakash (NSN - IN/Bangalore)" <prakash(dot)itnal(at)nsn(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Subject: Restart Issue in Cluster environment
Date: 2011-02-22 07:26:23
Message-ID: 269F5EA66E69934CA286B3E6CB6B907E524F5F@SGSIEXC009.nsn-intra.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

We are using postrges 9.0.3 cluster environment, with replication patch.

In a normal condition, if I restart current active postgres in standby
mode and current standby postgres in active mode, we are facing one
blocking issue.

On restarting current standby postgres in active mode, the flag
internally maintained by postgres engine (select pg_is_in_recovery()) is
not getting changed. Because of this even though postgres is started
properly it is in read-only mode.

The restart of current standby postgres in active mode is valid because
both postgres are in sync and as long as both postgres are in sync I can
start any postgres in active mode.

So in such scenario, is there any option to forcefully change the flag?
Or postgres ideally should change this flag?

Regards,
Prakash

Browse pgsql-general by date

  From Date Subject
Next Message Pavel Stehule 2011-02-22 07:38:23 Re: string_agg hanging?
Previous Message ivan_14_32 2011-02-22 07:03:36 Notify rule