Re: Automatic Failover Hot Standby / Streaming replication

I installed the missing package and I have;

pgpool -v
pgpool-II version 3.1 (hatsuiboshi)

2012/2/27 Matheus de Oliveira <matioli(dot)matheus(at)gmail(dot)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 <kiwan2005(at)gmail(dot)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(dot)matheus(at)gmail(dot)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 <kiwan2005(at)gmail(dot)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 杨晓青 <xqy1522(at)gmail(dot)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 <kiwan2005(at)gmail(dot)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
>>
>>
>>
>>
>>
>

--
WIssem EL KHLIFI,

Oracle ACE
Senior Oracle DBA
Database Team Leader
Computer Science Engineer