Thank you. Now, I have the Master / Slave setup.
Virtual machine: Postgresql Master installed + pgpool installed Virtual machine: Postgresql Slave installed, The Hot Standby / Streaming replication on 2 servers works perfecly with manual failover. Now, I want to configure pgpool to do the automatic failover, my questions are: 1- How to configure pgpool so it knows the HS/SR configuration I already setup? 2- How pgpool will know about my HS/SR setup? 3- How to setup the automnatic failover with pgpool? Thank you 2012/2/27 Matheus de Oliveira <matioli.math...@gmail.com> > The default location is /usr/local/etc, but you can change it when you > call the pgpool. > > I'm attaching the samples that come with pgpool 3.1.2. > > > 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:53 AM, Wissem <kiwan2...@gmail.com> wrote: > >> 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 >>>>>>>> >>>>>>>> 杨晓青 >>>>>>>> >>>>>>> >>>>>>> >>>>>>> >>>>>>> >> >
