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:53:19
Message-ID: CAMx8-JWP2n9zLOuct9_pR5warEH7Q4m=zmfRi_HtZ58nbs8asg@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-admin
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 <kiwan2005(at)gmail(dot)com>

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

In response to

Responses

pgsql-admin by date

Next:From: Matheus de OliveiraDate: 2012-02-27 13:06:40
Subject: Re: Automatic Failover Hot Standby / Streaming replication
Previous:From: WissemDate: 2012-02-27 12:42:09
Subject: Re: Automatic Failover Hot Standby / Streaming replication

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