Re: Automatic Failover Hot Standby / Streaming replication

[Wissem <kiwan2005@xxxxxxxxx>]

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@xxxxxxxxx>

 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@xxxxxxxxx>

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