On Sat, Jul 21, 2012 at 5:28 AM, Manoj Govindassamy
<manoj@nimblestorage.com> wrote:
> -- Anyway I can query the state of DB to know its status slave or master ??
> So, that i can issue write statements only after I know that the DB is the
> new master now
Yep. Use pg_is_in_recovery() - it's false on the master, true on slaves.
http://www.postgresql.org/docs/9.1/static/functions-admin.html#FUNCTIONS-RECOVERY-INFO-TABLE
ChrisA