Skip site navigation (1) Skip section navigation (2)

Re: Automatic Failover Hot Standby / Streaming replication

From: Wissem <kiwan2005(at)gmail(dot)com>
To: Matheus de Oliveira <matioli(dot)matheus(at)gmail(dot)com>
Cc: 杨晓青 <xqy1522(at)gmail(dot)com>, pgsql-admin(at)postgresql(dot)org
Subject: Re: Automatic Failover Hot Standby / Streaming replication
Date: 2012-02-27 12:07:16
Message-ID: CAMx8-JUxX-Wv5jS7u0Z--ZMeUk8T-=mmY9713qAZAPNKvrj1uw@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-admin
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

In response to

Responses

pgsql-admin by date

Next:From: Matheus de OliveiraDate: 2012-02-27 12:24:21
Subject: Re: Automatic Failover Hot Standby / Streaming replication
Previous:From: Matheus de OliveiraDate: 2012-02-27 11:39:06
Subject: Re: Automatic Failover Hot Standby / Streaming replication

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group