Re: Automatic Failover Hot Standby / Streaming replication

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
>
>
>
>
>