pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Could You help me
3+ messages / 3 participants
[nested] [flat]

* Could You help me
@ 2012-07-25 18:11  Noe Gutierrez <noebartino@gmail.com>
  0 siblings, 1 reply; 3+ messages in thread

From: Noe Gutierrez @ 2012-07-25 18:11 UTC (permalink / raw)
  To: pgsql-admin

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*

^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: Could You help me
@ 2012-07-25 18:15  Joshua D. Drake <jd@commandprompt.com>
  parent: Noe Gutierrez <noebartino@gmail.com>
  0 siblings, 1 reply; 3+ messages in thread

From: Joshua D. Drake @ 2012-07-25 18:15 UTC (permalink / raw)
  To: Noe Gutierrez <noebartino@gmail.com>; +Cc: pgsql-admin


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



^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: Could You help me
@ 2012-08-01 19:05  Ascarabina <ascarabina@gmail.com>
  parent: Joshua D. Drake <jd@commandprompt.com>
  0 siblings, 0 replies; 3+ messages in thread

From: Ascarabina @ 2012-08-01 19:05 UTC (permalink / raw)
  To: pgsql-admin

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+ ?



^ permalink  raw  reply  [nested|flat] 3+ messages in thread


end of thread, other threads:[~2012-08-01 19:05 UTC | newest]

Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2012-07-25 18:11 Could You help me Noe Gutierrez <noebartino@gmail.com>
2012-07-25 18:15 ` Joshua D. Drake <jd@commandprompt.com>
2012-08-01 19:05   ` Ascarabina <ascarabina@gmail.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