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 11:39:06
Message-ID: CAJghg4KkOWdmjHom3OX0tyYY-qE8+jE4roKwEpbFKb1+xM2skg@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-admin
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
>
>
>
>
>

In response to

Responses

pgsql-admin by date

Next:From: WissemDate: 2012-02-27 12:07:16
Subject: Re: Automatic Failover Hot Standby / Streaming replication
Previous:From: WissemDate: 2012-02-27 10:17:11
Subject: Re: Automatic Failover Hot Standby / Streaming replication

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