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 14:33:05
Message-ID: CAMx8-JWkvWRdv3Z=0ZymuopbicpfytBXjYSbg0Gz5_hJuRPiPw@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-admin
Thank you.

Now, I have the Master / Slave setup.

Virtual machine: Postgresql Master installed + pgpool installed
Virtual machine: Postgresql Slave installed,

The Hot Standby / Streaming replication on 2 servers works perfecly with
manual failover.

Now, I want to configure pgpool to do the automatic failover, my questions
are:

1- How to configure pgpool so it knows the HS/SR configuration I already
setup?
2- How pgpool will know about my HS/SR setup?
3- How to setup the automnatic failover with pgpool?

Thank you


2012/2/27 Matheus de Oliveira <matioli(dot)matheus(at)gmail(dot)com>

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

In response to

pgsql-admin by date

Next:From: Lennin CaroDate: 2012-02-27 14:33:35
Subject: Re: Automatic Failover Hot Standby / Streaming replication
Previous:From: Lennin CaroDate: 2012-02-27 14:30:22
Subject: Re: Automatic Failover Hot Standby / Streaming replication

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