How to auto switch the roles of master and standby

From: Sanjay Rao <srao(at)noida(dot)interrasystems(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: How to auto switch the roles of master and standby
Date: 2011-07-13 10:31:42
Message-ID: 4E1D740E.6020000@noida.interrasystems.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi All,

I am using postgres 9.0 with streaming replication(master/standby). I
want to use pacemaker/corosync to create trigger file to indicate the
standby to take over. ho can I execute a script using pacemaker whenever
a failure happens.

Regards,
Sanjay Rao

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2011-07-13 15:29:55 Re: Importing the dump file in postgresql-7.4.23
Previous Message Raman kumar 2011-07-13 08:09:03 read only error..hard reboot not work as well