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 <kiwan2...@gmail.com> wrote: From: Wissem <kiwan2...@gmail.com> Subject: Re: [ADMIN] Automatic Failover Hot Standby / Streaming replication To: "杨晓青" <xqy1...@gmail.com> Cc: pgsql-admin@postgresql.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 杨晓青 <xqy1...@gmail.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 <kiwan2...@gmail.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
