try to use the sources and compile, I send a little help --package install-------------------------------------------------------------- aptitude install postgresql-9.0 aptitude install postgresql-server-dev-9.0 aptitude install build-essential aptitude install libssl-dev aptitude install libreadline5-dev aptitude install zlib-bin aptitude install zlib1g-dev aptitude install libpq-dev aptitude install krb5-multidev comerr-dev libssl-dev aptitude install libkrb5-dev
--compile source-------------------------------------------------------------- tar -xzf pgpool-II-3.1.tar.gz cd pgpool-II-3.1 ./configure --prefix=/opt/pgpool3 cd pgpool-II-3.1/sql/pgpool-regclass make make install psql -f pgpool-regclass.sql template1 cd pgpool-II-3.1/sql psql -f insert_lock.sql template1 cd pgpool-II-3.1/sql/pgpool-recovery make make install psql -f pgpool-recovery.sql template1 --execute-------------------------------------------------------------- /opt/pgpool3/bin/pgpool -n& 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: "Matheus de Oliveira" <matioli.math...@gmail.com> Cc: "杨晓青" <xqy1...@gmail.com>, pgsql-admin@postgresql.org Date: Monday, February 27, 2012, 12:53 PM Hello, I can't find pgpool.conf file anywhere on the server. Shoud I create it by hand and where? Thank you 2012/2/27 Wissem <kiwan2...@gmail.com> I installed the missing package and I have; pgpool -vpgpool-II version 3.1 (hatsuiboshi) 2012/2/27 Matheus de Oliveira <matioli.math...@gmail.com> You have to install the postgresql client libraries first, it's missing. Must be something like: yum install postgresql9.1-client But I'm not sure about the right package name. Regards, -- Matheus de Oliveira Bacharelado em Ciências de Computação Laboratório de Computação de Alto Desempenho - LCAD Instituto de Ciências Matemáticas e de Computação - ICMC Universidade de São Paulo - USP On Mon, Feb 27, 2012 at 9:07 AM, Wissem <kiwan2...@gmail.com> wrote: Hi Matheus, When I run ; $ pgpool -v I have: pgpool: error while loading shared libraries: libpq.so.5: cannot open shared object file: No such file or directory Could you please help installing pgpool ? Thanks,Wissem 2012/2/27 Matheus de Oliveira <matioli.math...@gmail.com> Wissem, Execute the command: $ pgpool -v And check if you are using the newst version, 3.1.2. If not, I recommend you to download and compile the pgpool source code by hand (it's easy). Regards, -- Matheus de Oliveira Bacharelado em Ciências de Computação Laboratório de Computação de Alto Desempenho - LCAD Instituto de Ciências Matemáticas e de Computação - ICMC Universidade de São Paulo - USP On Mon, Feb 27, 2012 at 7:17 AM, Wissem <kiwan2...@gmail.com> wrote: 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 杨晓青