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 -v > pgpool-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<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 >>>>>> >>>>>> 杨晓青 >>>>>> >>>>> >>>>> >>>>> >>>>>
