Thread: Could You help me
I have installed the following:
Maquina 1 Postgres 9.1 on Fedora 16 this is the Master
Maquina 2 Postgres 9.1 on Fedora 16 this is the slave
they work succesfull an the replication too, but when The Master crashes:
1.- How to promote to slave becomes a new Master and
2.- When Old Master restarts:
How to become old master to slave
How To configure failover in general
thanks
Maquina 1 Postgres 9.1 on Fedora 16 this is the Master
Maquina 2 Postgres 9.1 on Fedora 16 this is the slave
they work succesfull an the replication too, but when The Master crashes:
1.- How to promote to slave becomes a new Master and
2.- When Old Master restarts:
How to become old master to slave
How To configure failover in general
thanks
I.S.C. Noe Adahi Gutiérrez Romero
Oracle® Certified Professional, Java® SE 6 Programmer
IBM® InfoShere® Guardium® Technical Professional v1
On 07/25/2012 11:11 AM, Noe Gutierrez wrote: > they work succesfull an the replication too, but when The Master crashes: > > 1.- How to promote to slave becomes a new Master and > > 2.- When Old Master restarts: > > How to become old master to slave > > How To configure failover in general You are going to need to install some HAC components, such as pacemaker/corosync and automate the base backup creation for the old master. It is not complicated but it is comprehensive. Sincerely, Joshua D. Drake -- Command Prompt, Inc. - http://www.commandprompt.com/ PostgreSQL Support, Training, Professional Services and Development High Availability, Oracle Conversion, Postgres-XC @cmdpromptinc - 509-416-6579
On 25.07.2012 20:15, Joshua D. Drake wrote: > > You are going to need to install some HAC components, such as > pacemaker/corosync and automate the base backup creation for the old > master. It is not complicated but it is comprehensive. I was also looking something like this. Is there any complate tutorial for postgresql 9+ ?