pg.ddx.io pgsql-admin@postgresql.org mailing list archivehelp / color / mirror / Atom feed
How to auto switch the roles of master and standby 2+ messages / 2 participants [nested] [flat]
* How to auto switch the roles of master and standby @ 2011-07-13 10:31 Sanjay Rao <srao@noida.interrasystems.com> 2011-07-14 01:45 ` Re: How to auto switch the roles of master and standby jenopob <jenopob@126.com> 0 siblings, 1 reply; 2+ messages in thread From: Sanjay Rao @ 2011-07-13 10:31 UTC (permalink / raw) To: 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 ^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: How to auto switch the roles of master and standby 2011-07-13 10:31 How to auto switch the roles of master and standby Sanjay Rao <srao@noida.interrasystems.com> @ 2011-07-14 01:45 ` jenopob <jenopob@126.com> 0 siblings, 0 replies; 2+ messages in thread From: jenopob @ 2011-07-14 01:45 UTC (permalink / raw) To: pgsql-admin hi you could use pgpool-II failover_command to trigger the script what you want to something you can take at http://pgpool.projects.postgresql.org/pgpool-II/doc/pgpool-en.html and pgpool-II works in Master/Slave Mode will meet your requirements best regards jenopob -- View this message in context: http://postgresql.1045698.n5.nabble.com/How-to-auto-swtich-the-roles-of-primary-and-standby-tp454663... Sent from the PostgreSQL - admin mailing list archive at Nabble.com. ^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2011-07-14 01:45 UTC | newest] Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2011-07-13 10:31 How to auto switch the roles of master and standby Sanjay Rao <srao@noida.interrasystems.com> 2011-07-14 01:45 ` jenopob <jenopob@126.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions for how to clone and mirror all data and code used for this inbox