From: Lennin Caro <lennin.caro@yahoo.com>
To: 杨晓青 <xqy1522@gmail.com>
To: Wissem <kiwan2005@gmail.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: Automatic Failover Hot Standby / Streaming replication
Date: Mon, 27 Feb 2012 06:30:22 -0800 (PST)
Message-ID: <1330353022.50177.YahooMailClassic@web162205.mail.bf1.yahoo.com> (raw)
In-Reply-To: <CAMx8-JU0ejjzJ8NNDsC7PM0vQgXE2GWraEEY5nFLVN9zTwontw@mail.gmail.com>
Are you running the pgpool start as root?
Ing. Lennin Caro Pérez
Usuario:GNU/LINUX
PHP Developer
PostgreSQL DBA
Oracle DBA
Linux counter id 474393
--- On Mon, 2/27/12, Wissem <kiwan2005@gmail.com> wrote:
From: Wissem <kiwan2005@gmail.com>
Subject: Re: [ADMIN] Automatic Failover Hot Standby / Streaming replication
To: "杨晓青" <xqy1522@gmail.com>
Cc: pgsql-admin@postgresql.org
Date: Monday, February 27, 2012, 10:17 AM
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@gmail.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@gmail.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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: lennin.caro@yahoo.com, xqy1522@gmail.com, kiwan2005@gmail.com
Subject: Re: Automatic Failover Hot Standby / Streaming replication
In-Reply-To: <1330353022.50177.YahooMailClassic@web162205.mail.bf1.yahoo.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox