Обсуждение: Could You help me

Поиск
Список
Период
Сортировка

Could You help me

От
Noe Gutierrez
Дата:
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





I.S.C. Noe Adahi Gutiérrez Romero
Oracle® Certified Professional, Java® SE 6 Programmer
IBM® InfoShere® Guardium® Technical Professional v1
 

Re: Could You help me

От
"Joshua D. Drake"
Дата:
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

Re: Could You help me

От
Ascarabina
Дата:
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+ ?