Received: from makus.postgresql.org (makus.postgresql.org [98.129.198.125]) by mail.postgresql.org (Postfix) with ESMTP id 05256F497BB for ; Mon, 27 Feb 2012 10:30:37 -0400 (AST) Received: from nm7.bullet.mail.bf1.yahoo.com ([98.139.212.166]) by makus.postgresql.org with smtp (Exim 4.72) (envelope-from ) id 1S21b1-00040S-Ka for pgsql-admin@postgresql.org; Mon, 27 Feb 2012 14:30:36 +0000 Received: from [98.139.212.146] by nm7.bullet.mail.bf1.yahoo.com with NNFMP; 27 Feb 2012 14:30:22 -0000 Received: from [98.139.212.232] by tm3.bullet.mail.bf1.yahoo.com with NNFMP; 27 Feb 2012 14:30:22 -0000 Received: from [127.0.0.1] by omp1041.mail.bf1.yahoo.com with NNFMP; 27 Feb 2012 14:30:22 -0000 X-Yahoo-Newman-Property: ymail-3 X-Yahoo-Newman-Id: 349894.10387.bm@omp1041.mail.bf1.yahoo.com Received: (qmail 91297 invoked by uid 60001); 27 Feb 2012 14:30:22 -0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s1024; t=1330353022; bh=xmzkxvl7yDhpsZ6QIUUshyiBVh3GgzvybQWZ8mjE5P8=; h=X-YMail-OSG:Received:X-Mailer:Message-ID:Date:From:Subject:To:Cc:In-Reply-To:MIME-Version:Content-Type; b=0BGViMoemTjC+9HFlRSslN7DOQ7u9Ifzb35WSa364Nydh8q+MSoFIHofNBfLadKwzm+bVolAZXF3UbLLTWENFQn9aDx0luya99GD9fn0r2Dl3UqpxYbzJ5cGq1yfy+2yCEPXV+iPn0d4YVep+kjDZk6yauGZn7JN/oaZAW0CgdQ= DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=X-YMail-OSG:Received:X-Mailer:Message-ID:Date:From:Subject:To:Cc:In-Reply-To:MIME-Version:Content-Type; b=V6cy7NTvxDsb1Jl3m87y6/Ol28wYzUsPnaBXmgcF0LsxPDkJvXjxG33dcI984kUDX66GzlycYj5+aEtil5KloSomYPPidaEnILMd2DhGRCwIeb6jefeauPy1YcG3s1c4hd6Kg4JVXmw1D9d18SFgOHY8byful2sFiMXKD0Rb288=; X-YMail-OSG: ISALJE0VM1lhBWgSepziNPtduADPsHlf29N9qJ5L0_3dCVr EbYijKDE7LBleXj.9TvydV8ncY.__jRbNvdmAmWSO4tTjhDXsNr7VXSUfk.5 9Y9YYbmvbqmCcYtNWcbgrxq1JzSjNQ3u924gxR4Ld9gKvrgH86s4oWTqwhTe 0_EPkaA.yp_mi66Hzym7HB3rOpyEOJjx5ICB5HmB6MXW92JwJ1Cx3vPFlvEz nwz3PPTNlccZZsQHWVQFRjLDTgT9ZKUjyNK_YkMVLM4ijUzGp7WBwyeRdz7I EoBhNy8p3mhy7n3Z8EwbHmYedcAR7ZFFEL72udMCEmOr27hN38Fs12Sx1pHT GOW4xyG2DQaoTqEbHc9yuCgv9wz0.mgwASme8PjanThWNokaNe2GgPPsp9HS xMcC5VmTk40U7v9kKFF2ceKXnSKCr_5DNX05avy0gFVF_0VH51O6hO0vGJ1E _rodRyXFwdzIiH9TSGEWWUO2uolvFrtzTtMv1uZPkgKEbK8QHFP5xbzBW9XB QWKxd3zxQmRXcZjA2JRUbVpPy79SXkidmgXJ08L2IyoYfX.t9z5ouPM4k013 4X3XZcm8kz7e2AYchcItEAO.eP227G0cT3MVvPQjVp8D4wvPp7HcglR3dSYg B7BFg2_umrjTZseUXSoJL7OylawV0gSQ0AM9j5Vn.OfzA9bwDkJCvGYMwZtv w Received: from [161.196.9.231] by web162205.mail.bf1.yahoo.com via HTTP; Mon, 27 Feb 2012 06:30:22 PST X-Mailer: YahooMailClassic/15.0.4 YahooMailWebService/0.8.116.338427 Message-ID: <1330353022.50177.YahooMailClassic@web162205.mail.bf1.yahoo.com> Date: Mon, 27 Feb 2012 06:30:22 -0800 (PST) From: Lennin Caro Subject: Re: Automatic Failover Hot Standby / Streaming replication To: =?utf-8?B?5p2o5pmT6Z2S?= , Wissem Cc: pgsql-admin@postgresql.org In-Reply-To: MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="-1589821586-846086837-1330353022=:50177" X-Pg-Spam-Score: -1.9 (-) X-Archive-Number: 201202/117 X-Sequence-Number: 39177 ---1589821586-846086837-1330353022=:50177 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable Are you running the pgpool start as root? Ing. Lennin Caro P=C3=A9rez =0AUsuario:GNU/LINUX =0APHP Developer =0APostgreSQL DBA =0AOracle DBA =0ALinux counter id 474393 --- On Mon, 2/27/12, Wissem wrote: From: Wissem Subject: Re: [ADMIN] Automatic Failover Hot Standby / Streaming replication To: "=E6=9D=A8=E6=99=93=E9=9D=92" 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 lin= ux 5); yum install pgpool-II-91.i386 Is it correct? this will install full and complete pgpool librairies necess= ary for the=C2=A0Hot Standby / Streaming replication on 2 servers=C2=A0on m= y machine?=0A Thanks 2012/2/13 =E6=9D=A8=E6=99=93=E9=9D=92 =0A=C2=A0This document may help you. =C2=A0http://www.pgpool.net/pgpool-web= /pgpool-II/doc/pgpool-en.html=C2=A0=0A=0A=C2=A0 =C2=A0=C2=A0 =C2=A0see "Fai= lover with Streaming Replication" section.=C2=A0 2012/2/13 Wissem =0A=0A Hello, I am new user of Postgresql, I have=C2=A0successfully=C2=A0set up a=C2=A0Ho= t Standby / Streaming replication on 2 servers running on Redhat Linux 5 (P= ostgresql version 9.1).=0A=0A=0A 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 a= rticle (step by step) to setup it. =0A=0A=0ACould you please help me and share any useful document with me? thanks, W=C2=A0 =0A --=20 ------------------------------------------- best regards =E6=9D=A8=E6=99=93=E9=9D=92 =0A --=20 WIssem EL KHLIFI, Oracle ACE Senior Oracle DBA Database Team Leader Computer Science Engineer =0A =0A=0A ---1589821586-846086837-1330353022=:50177 Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: quoted-printable
Are you running = the pgpool start as root?
Ing. Lennin Caro P=C3=A9rez
=0AUsuario:GNU/LINUX
=0APHP Developer=0APostgreSQL DBA
=0AOracle DBA
=0ALinux counter id 474393

= --- On Mon, 2/27/12, Wissem <kiwan2005@gmail.com> wrote= :

From: Wissem <kiwan2005@gmail.com><= br>Subject: Re: [ADMIN] Automatic Failover Hot Standby / Streaming replicat= ion
To: "=E6=9D=A8=E6=99=93=E9=9D=92" <xqy1522@gmail.com>
Cc: p= gsql-admin@postgresql.org
Date: Monday, February 27, 2012, 10:17 AM
<= br>
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 necessar= y for the Hot Standby / Streaming replication on 2 servers on my = machine?
=0A

Thanks

2012/2/13 =E6=9D=A8=E6=99=93=E9=9D=92 <= xqy1522@gmail.com>
=0A
 This document may help you.  http://www.pgpool.net/pgpool-web/pgpo= ol-II/doc/pgpool-en.html 
=0A=0A   
   see "Failover with Streaming Replication" section. = ;

2012/2/13 Wissem <kiwan2005@gmail.c= om>
=0A=0A

Hello,

I am new user of Postgre= sql, I have successfully set up a Hot Standby / Streaming re= plication on 2 servers running on Redhat Linux 5 (Postgresql version 9.1).<= /div>=0A=0A
=0A
I need to set up an automatic failover an= d discovered that there is a tool named; pgpool. I have searched a lot on t= he net and didn't found a useful article (step by step) to setup it.
<= div>
=0A=0A=0A
Could you please help me and share any useful d= ocument with me?

thanks,

= W 


=0A



--
-------------------------------------------
best= regards

=E6=9D=A8=E6=99=93=E9=9D=92
=0A
=



--
WIssem EL KHLIFI,

=
Oracle ACE
Senior Oracle DBA
Database Team Leader
Computer Sc= ience Engineer


=0A

=0A
= =0A
---1589821586-846086837-1330353022=:50177--