Re: Automatic Failover Hot Standby / Streaming replication

From: Wissem <kiwan2005(at)gmail(dot)com>
To: 杨晓青 <xqy1522(at)gmail(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Automatic Failover Hot Standby / Streaming replication
Date: 2012-02-27 10:17:11
Message-ID: CAMx8-JU0ejjzJ8NNDsC7PM0vQgXE2GWraEEY5nFLVN9zTwontw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

Browse pgsql-admin by date

  From Date Subject
Next Message Matheus de Oliveira 2012-02-27 11:39:06 Re: Automatic Failover Hot Standby / Streaming replication
Previous Message Brian Weaver 2012-02-25 19:51:20 Re: Problems with pg_restore (plpgsql already exists)