Received: from makus.postgresql.org (makus.postgresql.org [98.129.198.125]) by mail.postgresql.org (Postfix) with ESMTP id 25ACDF497BF for ; Mon, 27 Feb 2012 10:33:56 -0400 (AST) Received: from nm16.bullet.mail.bf1.yahoo.com ([98.139.212.175]) by makus.postgresql.org with smtp (Exim 4.72) (envelope-from ) id 1S21e9-00042B-0Z for pgsql-admin@postgresql.org; Mon, 27 Feb 2012 14:33:52 +0000 Received: from [98.139.212.151] by nm16.bullet.mail.bf1.yahoo.com with NNFMP; 27 Feb 2012 14:33:36 -0000 Received: from [98.139.212.211] by tm8.bullet.mail.bf1.yahoo.com with NNFMP; 27 Feb 2012 14:33:36 -0000 Received: from [127.0.0.1] by omp1020.mail.bf1.yahoo.com with NNFMP; 27 Feb 2012 14:33:36 -0000 X-Yahoo-Newman-Property: ymail-3 X-Yahoo-Newman-Id: 94417.91574.bm@omp1020.mail.bf1.yahoo.com Received: (qmail 35360 invoked by uid 60001); 27 Feb 2012 14:33:35 -0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s1024; t=1330353215; bh=eLq1E4oNHYqdJYp8zHiRwtW3KM9bqkH4SJO4PQ0qk2Q=; h=X-YMail-OSG:Received:X-Mailer:Message-ID:Date:From:Subject:To:Cc:In-Reply-To:MIME-Version:Content-Type; b=Sfsep6yvZiQ4q10ooGJzO1UxGkum9V2Kf6wbLYXy1Sc5glZ0bdKYs6MuIzVeCtfnPRcLy7gBVyOU3/6TDl1M0UfvK1us8DPiJtFwBRl8L73fGHa0PiNk+kRs7unhgBr/x7LrPgR4otDjYaOuMEUSBy/m7vAfb3Tlm9/ImeoSClk= 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=Y4NA18mRdn7vzwG/Y+7bE9DEvhDBCNU44K8h9fRbs2WUWdC/6KU59gGY5YOGR+n/fbWvwoToQy/7fjIiGcJocLadZwJdbX9lppxs3sEbHffjEFpxkOoKRoMeS2AU5jINi/uiDKKAuM8ouyCdAvOczXafzB4JGoR4mOCbdCljt3o=; X-YMail-OSG: A0BE2dAVM1kIvURptapkHCIiWj4FtWXeKARGditcp6q.hks vtv2O.zRRqgRo9eMYK5X6ytdTgTNSzhQ1R1e.pQfI1v4HJPut_g8Imdj0jiw f6xvn0eaoSkPhurAzRa8VmZ4SvJr6.hca5wrv6OAIQEMvcH8kqUOv5zMk9Vm znvIiDGQepku2nGKqA_yjMROVeNdsBGoVGVD6aI7bHEtinAleLcJxnVv3Cmf 015dFPXm3m3wkquhQHucmrXuTxkJ01F8KxuBe4ZO8qLWxNWq1AUT45DI2vKZ WBo4U2XtIUaZwLWzCVwu1s6Jzhw7f5XBKKwn9skOe2wPVuaIojVbYFFCbHIb huuJieqzbrIR.6dZ1.BjMM2wcmVcSk1Vat9iXBiBoN5CuViZQvhbqqUskGlL spf92oSAmCFZynR9yw1UBw8dqjl6SpSqM2rxyM9Frej2gSAhv_rjm2U..i1p 7xv42mMDw.3xkwToBepQUtRSAFWQIW_TwOJymkHhVfh5Xsd41sRApmveSImQ YUmfXygjWKNCJUIPfdU5_G3pTkjJXl1jB.2etZvT9hJfK4IIEKE3pCRf6mL0 znyJfXUo2e29DvJbUcVNaetRrz4mf_ig1gvIFaiHrMLqrWyBvG77K3XQKoCI 7qZ0zGt6OquAbFII1cGTeboUyyV4- Received: from [161.196.9.231] by web162206.mail.bf1.yahoo.com via HTTP; Mon, 27 Feb 2012 06:33:35 PST X-Mailer: YahooMailClassic/15.0.4 YahooMailWebService/0.8.116.338427 Message-ID: <1330353215.32377.YahooMailClassic@web162206.mail.bf1.yahoo.com> Date: Mon, 27 Feb 2012 06:33:35 -0800 (PST) From: Lennin Caro Subject: Re: Automatic Failover Hot Standby / Streaming replication To: Matheus de Oliveira , Wissem Cc: =?utf-8?B?5p2o5pmT6Z2S?= , pgsql-admin@postgresql.org In-Reply-To: MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="1120943518-82168999-1330353215=:32377" X-Pg-Spam-Score: -0.9 (/) X-Archive-Number: 201202/119 X-Sequence-Number: 39179 --1120943518-82168999-1330353215=:32377 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable try to use the sources and compile, I send a little help --package install----------------------------------------------------------= ---- aptitude install postgresql-9.0 aptitude install postgresql-server-dev-9.0 aptitude install build-essential aptitude install libssl-dev aptitude install libreadline5-dev aptitude install zlib-bin aptitude install zlib1g-dev aptitude install libpq-dev aptitude install krb5-multidev comerr-dev libssl-dev aptitude install libkrb5-dev --compile source-----------------------------------------------------------= --- tar -xzf pgpool-II-3.1.tar.gz=20 cd pgpool-II-3.1 ./configure --prefix=3D/opt/pgpool3 cd pgpool-II-3.1/sql/pgpool-regclass make make install psql -f pgpool-regclass.sql template1 cd pgpool-II-3.1/sql psql -f insert_lock.sql template1 cd pgpool-II-3.1/sql/pgpool-recovery make make install psql -f pgpool-recovery.sql template1 --execute-------------------------------------------------------------- /opt/pgpool3/bin/pgpool -n&=C2=A0=C2=A0=20 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: "Matheus de Oliveira" Cc: "=E6=9D=A8=E6=99=93=E9=9D=92" , pgsql-admin@postgres= ql.org Date: Monday, February 27, 2012, 12:53 PM 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 =0AI installed the missing package and I have; pgpool -vpgpool-II version 3.1 (hatsuiboshi)=0A 2012/2/27 Matheus de Oliveira =0A=0AYou have to install the postgresql client libraries first, it's missi= ng. Must be something like: yum install postgresql9.1-client =0A=0A But I'm not sure about the right package name. =0A=0A Regards, -- Matheus de Oliveira Bacharelado em Ci=C3=AAncias de Computa=C3=A7=C3=A3o Laborat=C3=B3rio de Computa=C3=A7=C3=A3o de Alto Desempenho - LCAD Instituto de Ci=C3=AAncias Matem=C3=A1ticas e de Computa=C3=A7=C3=A3o - ICM= C =0A=0A=0A=0AUniversidade de S=C3=A3o Paulo - USP =0A On Mon, Feb 27, 2012 at 9:07 AM, Wissem wrote: =0A=0A=0AHi=C2=A0Matheus, When I run ; $ pgpool -v=0A I have: =0Apgpool: error while loading shared libraries: libpq.so.5: cannot open sh= ared object file: No such file or directory=0A Could you please help installing pgpool ?=0A Thanks,Wissem =0A 2012/2/27 Matheus de Oliveira =0A=0A=0A=0A=0AWissem, 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 h= and (it's easy). =0A=0A=0A=0A=0A=0A=0A Regards, -- Matheus de Oliveira Bacharelado em Ci=C3=AAncias de Computa=C3=A7=C3=A3o Laborat=C3=B3rio de Computa=C3=A7=C3=A3o de Alto Desempenho - LCAD Instituto de Ci=C3=AAncias Matem=C3=A1ticas e de Computa=C3=A7=C3=A3o - ICM= C =0A=0A=0A=0A=0A=0A=0AUniversidade de S=C3=A3o Paulo - USP =0A On Mon, Feb 27, 2012 at 7:17 AM, Wissem wrote: =0A=0A=0A=0A=0A=0A=0AHello, 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=0A=0A=0A=0A=0A=0A=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=0A=0A=0A=0A=0A=0A=0A=C2=A0 =C2=A0= =C2=A0 =C2=A0see "Failover with Streaming Replication" section.=C2=A0 2012/2/13 Wissem =0A=0A=0A=0A=0A=0A=0A=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=0A=0A=0A=0A=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=0A=0A=0A=0A=0A=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 =0A =0A=0A --1120943518-82168999-1330353215=:32377 Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: quoted-printable
try to use the sources and compile= , I send a little help

--package install-= -------------------------------------------------------------
aptitude i= nstall postgresql-9.0
aptitude install postgresql-server-dev-9.0
apti= tude install build-essential
aptitude install libssl-dev
aptitude ins= tall libreadline5-dev
aptitude install zlib-bin
aptitude install zlib= 1g-dev
aptitude install libpq-dev
aptitude install krb5-multidev come= rr-dev libssl-dev
aptitude install libkrb5-dev

--compile source------------------------------------------------------------= --
tar -xzf pgpool-II-3.1.tar.gz
cd pgpool-II-3.1
./configu= re --prefix=3D/opt/pgpool3
cd pgpool-II-3.1/sql/pgpool-regclass
make<= br>make install
psql -f pgpool-regclass.sql template1
cd pgpool-II-3.= 1/sql
psql -f insert_lock.sql template1
cd pgpool-II-3.1/sql/pgpool-r= ecovery
make
make install
psql -f pgpool-recovery.sql template1
--execute= -------------------------------------------------------= -------
/opt/pgpool3/bin/pgpool -n&  


Ing. Lennin= Caro P=C3=A9rez
=0AUsuario:GNU/LINUX
=0APHP Developer
=0APostgreS= QL DBA
=0AOracle DBA
=0ALinux counter id 474393

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

From: Wissem <kiwan2005@gmail.com>
Subject: R= e: [ADMIN] Automatic Failover Hot Standby / Streaming replication
To: "M= atheus de Oliveira" <matioli.matheus@gmail.com>
Cc: "=E6=9D=A8=E6= =99=93=E9=9D=92" <xqy1522@gmail.com>, pgsql-admin@postgresql.org
D= ate: Monday, February 27, 2012, 12:53 PM

H= ello,

I can't find pgpool.conf file anywhere on the serv= er. Shoud I create it by hand and where?

Thank you=

2012/2/27 Wissem <kiwan2005@gmai= l.com>
=0A
I i= nstalled the missing package and I have;

pgpool -v
=
pgpool-II version 3.1 (hatsuiboshi)
=0A



<= div>
2012/2/27 Matheus de Olivei= ra <matioli.matheus@gmail.com>
=0A=0A
You have to install the postgresql client lib= raries first, it's missing.

Must be something like:

yum install postgresql9.1-client=
=0A=0A
But I'm not sure about the right package name.
On Mon, Feb 27, 2012 at 9:07 AM, Wissem <kiwan200= 5@gmail.com> wrote:
=0A
=0A=0AHi Matheus,

When I run ;
=
$ pgpool -v
=0A

I have:

=0A
pgp= ool: error while loading shared libraries: libpq.so.5: cannot open shared o= bject file: No such file or directory
=0A
Could you please help installing pgpool ?
=0A
Thanks,
=0A=0A=0A=0A=0A=0A= =0A
Regards,
--
Matheus de Oliveira

Bacharela= do em Ci=C3=AAncias de Computa=C3=A7=C3=A3o
Laborat=C3=B3rio de Compu= ta=C3=A7=C3=A3o de Alto Desempenho - LCAD
Instituto de Ci=C3=AAncias Mat= em=C3=A1ticas e de Computa=C3=A7=C3=A3o - ICMC
=0A=0A=0A=0A=0A=0A=0A= Univer= sidade de S=C3=A3o Paulo - USP



=0A

On Mon, Feb 27, 2012 at 7:17 AM, Wissem <kiwan200= 5@gmail.com> wrote:
=0A=0A=0A=0A=0A=0A=0AHello,

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=0A=0A=0A=0A=0A=0A=0A

Thanks
<= br>
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/pgpool-II/doc/= pgpool-en.html 
=0A=0A=0A=0A=0A=0A=0A=0A=0A =  
   see "Failover with Streaming Replication" se= ction. 

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

H= ello,

I am new user of Postgresql, I have suc= cessfully set up a Hot Standby / Streaming replication on 2 serve= rs running on Redhat Linux 5 (Postgresql version 9.1).
=0A=0A=0A=0A=0A= =0A=0A=0A=0A
=0A
I need to set up an automatic failover a= nd 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.
=

=0A=0A=0A=0A=0A=0A=0A=0A=0A=0A
Could you please help me = and share any useful document with me?

thanks,

W 


=0A



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

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



<= /div>
=0A
=0A=0A
--1120943518-82168999-1330353215=:32377--