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

Re: Automatic Failover Hot Standby / Streaming replication

From: Matheus de Oliveira <matioli(dot)matheus(at)gmail(dot)com>
To: Wissem <kiwan2005(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 13:06:40
Message-ID: CAJghg4KXNa0+6YrKqmA_H1X3-zdP4a1-_Jn+aP13BPeeK1eSaw@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-admin
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 <kiwan2005(at)gmail(dot)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 <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
>>>>>>>
>>>>>>> 杨晓青
>>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>

Attachment: pgpool_conf_samples.zip
Description: application/zip (17.5 KB)

In response to

Responses

pgsql-admin by date

Next:From: Lukasz BrodziakDate: 2012-02-27 13:25:12
Subject: Large amount of postgres processes
Previous:From: WissemDate: 2012-02-27 12:53:19
Subject: Re: Automatic Failover Hot Standby / Streaming replication

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