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<http://www.lcad.icmc.usp.br/> Instituto de Ciências Matemáticas e de Computação - ICMC<http://www.icmc.usp.br/> Universidade de São Paulo - USP <http://www.sc.usp.br/> 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<http://www.lcad.icmc.usp.br/> >> Instituto de Ciências Matemáticas e de Computação - >> ICMC<http://www.icmc.usp.br/> >> Universidade de São Paulo - USP <http://www.sc.usp.br/> >> >> >> >> >> >> 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 >>>> >>>> 杨晓青 >>>> >>> >>> >>> >>> -- >>> WIssem EL KHLIFI, >>> >>> Oracle ACE >>> Senior Oracle DBA >>> Database Team Leader >>> Computer Science Engineer >>> >>> >>> >>> >>> >> > > > -- > WIssem EL KHLIFI, > > Oracle ACE > Senior Oracle DBA > Database Team Leader > Computer Science Engineer > > > > >
