Skip site navigation (1) Skip section navigation (2)

Re: Automatic Failover Hot Standby / Streaming replication

From: Lennin Caro <lennin(dot)caro(at)yahoo(dot)com>
To: 杨晓青 <xqy1522(at)gmail(dot)com>, Wissem <kiwan2005(at)gmail(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Automatic Failover Hot Standby / Streaming replication
Date: 2012-02-27 14:30:22
Message-ID: 1330353022.50177.YahooMailClassic@web162205.mail.bf1.yahoo.com (view raw or flat)
Thread:
Lists: pgsql-admin
Are you running the pgpool start as root?

Ing. Lennin Caro Pérez

Usuario:GNU/LINUX

PHP Developer

PostgreSQL DBA

Oracle DBA

Linux  counter id 474393

--- On Mon, 2/27/12, Wissem <kiwan2005(at)gmail(dot)com> wrote:

From: Wissem <kiwan2005(at)gmail(dot)com>
Subject: Re: [ADMIN] Automatic Failover Hot Standby / Streaming replication
To: "杨晓青" <xqy1522(at)gmail(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Date: Monday, February 27, 2012, 10:17 AM

Hello,
To install pgpool, I run this command in my virtual machine (OS: Redhat linux 5);
yum install pgpool-II-91.i386
Is it correct? this will install full and complete pgpool librairies necessary for the Hot Standby / Streaming replication on 2 servers on my machine?

Thanks

2012/2/13 杨晓青 <xqy1522(at)gmail(dot)com>

 This document may help you.  http://www.pgpool.net/pgpool-web/pgpool-II/doc/pgpool-en.html 

      see "Failover with Streaming Replication" section. 
2012/2/13 Wissem <kiwan2005(at)gmail(dot)com>



Hello,
I am new user of Postgresql, I have successfully set up a Hot Standby / Streaming replication on 2 servers running on Redhat Linux 5 (Postgresql version 9.1).



I need to set up an automatic failover and discovered that there is a tool named; pgpool. I have searched a lot on the net and didn't found a useful article (step by step) to setup it.



Could you please help me and share any useful document with me?
thanks,
W 





-- 
-------------------------------------------
best regards

杨晓青




-- 
WIssem EL KHLIFI,

Oracle ACE
Senior Oracle DBA
Database Team Leader
Computer Science Engineer







In response to

pgsql-admin by date

Next:From: WissemDate: 2012-02-27 14:33:05
Subject: Re: Automatic Failover Hot Standby / Streaming replication
Previous:From: Lukasz BrodziakDate: 2012-02-27 13:25:12
Subject: Large amount of postgres processes

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group