dbTalk Databases Forums  

[ADMIN] Could You help me

mailing.database.pgsql-admin mailing.database.pgsql-admin


Discuss [ADMIN] Could You help me in the mailing.database.pgsql-admin forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Noe Gutierrez
 
Posts: n/a

Default [ADMIN] Could You help me - 07-25-2012 , 01:11 PM






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*

Reply With Quote
  #2  
Old   
Joshua D. Drake
 
Posts: n/a

Default Re: [ADMIN] Could You help me - 07-25-2012 , 01:15 PM






On 07/25/2012 11:11 AM, Noe Gutierrez wrote:
Quote:
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

--
Sent via pgsql-admin mailing list (pgsql-admin (AT) postgresql (DOT) org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin

Reply With Quote
  #3  
Old   
Ascarabina
 
Posts: n/a

Default Re: [ADMIN] Could You help me - 08-01-2012 , 02:05 PM



On 25.07.2012 20:15, Joshua D. Drake wrote:
Quote:
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+ ?

--
Sent via pgsql-admin mailing list (pgsql-admin (AT) postgresql (DOT) org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2013, Jelsoft Enterprises Ltd.