Postgres Pro
Downloads
Home   >   mailing lists

Thread: Automatic Failover Hot Standby / Streaming replication

Automatic Failover Hot Standby / Streaming replication

From
Wissem
Date:

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 


Re: Automatic Failover Hot Standby / Streaming replication

From
杨晓青
Date:
 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

杨晓青

Re: Automatic Failover Hot Standby / Streaming replication

From
Devrim GÜNDÜZ
Date:
On Sun, 2012-02-12 at 18:01 +0100, Wissem wrote:
>
> 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.

Alternatively, you can use Red Hat Cluster Suite, and create the
trigger_file upon failover, with some minor customization in the cluster
files.

http://www.gunduz.org/download.php?dlid=190

will give you ideas about setting up RHCS with PostgreSQL. I don't have
any doc for triggering failover with RHCS, though. Should be very
simple.

Regards,
--
Devrim GÜNDÜZ
Principal Systems Engineer @ EnterpriseDB: http://www.enterprisedb.com
PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer
Community: devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr
http://www.gunduz.org  Twitter: http://twitter.com/devrimgunduz
Attachment

Re: Automatic Failover Hot Standby / Streaming replication

From
Wissem
Date:
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




Re: Automatic Failover Hot Standby / Streaming replication

From
Matheus de Oliveira
Date:
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
Instituto de Ciências Matemáticas e de Computação - ICMC
Universidade de São Paulo - USP




On Mon, Feb 27, 2012 at 7:17 AM, Wissem <kiwan2005@gmail.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@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





Re: Automatic Failover Hot Standby / Streaming replication

From
Wissem
Date:
Hi Matheus,

When I run ;

$ pgpool -v

I have:

pgpool: error while loading shared libraries: libpq.so.5: cannot open shared object file: No such file or directory

Could you please help installing pgpool ?

Thanks,
Wissem

2012/2/27 Matheus de Oliveira <matioli.matheus@gmail.com>
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
Instituto de Ciências Matemáticas e de Computação - ICMC
Universidade de São Paulo - USP





On Mon, Feb 27, 2012 at 7:17 AM, Wissem <kiwan2005@gmail.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@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








--
WIssem EL KHLIFI,

Oracle ACE
Senior Oracle DBA
Database Team Leader
Computer Science Engineer




Re: Automatic Failover Hot Standby / Streaming replication

From
Matheus de Oliveira
Date:
You have to install the postgresql client libraries first, it's missing.

Must be something like:

yum install postgresql9.1-client

But I'm not sure about the right package name.

Regards,
--
Matheus de Oliveira

Bacharelado em Ciências de Computação
Laboratório de Computação de Alto Desempenho - LCAD
Instituto de Ciências Matemáticas e de Computação - ICMC
Universidade de São Paulo - USP




On Mon, Feb 27, 2012 at 9:07 AM, Wissem <kiwan2005@gmail.com> wrote:
Hi Matheus,

When I run ;

$ pgpool -v

I have:

pgpool: error while loading shared libraries: libpq.so.5: cannot open shared object file: No such file or directory

Could you please help installing pgpool ?

Thanks,
Wissem

2012/2/27 Matheus de Oliveira <matioli.matheus@gmail.com>
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
Instituto de Ciências Matemáticas e de Computação - ICMC
Universidade de São Paulo - USP





On Mon, Feb 27, 2012 at 7:17 AM, Wissem <kiwan2005@gmail.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@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








--
WIssem EL KHLIFI,

Oracle ACE
Senior Oracle DBA
Database Team Leader
Computer Science Engineer





Re: Automatic Failover Hot Standby / Streaming replication

From
Wissem
Date:
Hi,

I already have postgresql 9.1 server installed on this server.

2012/2/27 Matheus de Oliveira <matioli.matheus@gmail.com>
You have to install the postgresql client libraries first, it's missing.

Must be something like:

yum install postgresql9.1-client

But I'm not sure about the right package name.


Regards,
--
Matheus de Oliveira

Bacharelado em Ciências de Computação
Laboratório de Computação de Alto Desempenho - LCAD
Instituto de Ciências Matemáticas e de Computação - ICMC
Universidade de São Paulo - USP




On Mon, Feb 27, 2012 at 9:07 AM, Wissem <kiwan2005@gmail.com> wrote:
Hi Matheus,

When I run ;

$ pgpool -v

I have:

pgpool: error while loading shared libraries: libpq.so.5: cannot open shared object file: No such file or directory

Could you please help installing pgpool ?

Thanks,
Wissem

2012/2/27 Matheus de Oliveira <matioli.matheus@gmail.com>
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
Instituto de Ciências Matemáticas e de Computação - ICMC
Universidade de São Paulo - USP





On Mon, Feb 27, 2012 at 7:17 AM, Wissem <kiwan2005@gmail.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@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

杨晓青


Re: Automatic Failover Hot Standby / Streaming replication

From
Wissem
Date:
I installed the missing package and I have;

pgpool -v
pgpool-II version 3.1 (hatsuiboshi)




2012/2/27 Matheus de Oliveira <matioli.matheus@gmail.com>
You have to install the postgresql client libraries first, it's missing.

Must be something like:

yum install postgresql9.1-client

But I'm not sure about the right package name.


Regards,
--
Matheus de Oliveira

Bacharelado em Ciências de Computação
Laboratório de Computação de Alto Desempenho - LCAD
Instituto de Ciências Matemáticas e de Computação - ICMC
Universidade de São Paulo - USP




On Mon, Feb 27, 2012 at 9:07 AM, Wissem <kiwan2005@gmail.com> wrote:
Hi Matheus,

When I run ;

$ pgpool -v

I have:

pgpool: error while loading shared libraries: libpq.so.5: cannot open shared object file: No such file or directory

Could you please help installing pgpool ?

Thanks,
Wissem

2012/2/27 Matheus de Oliveira <matioli.matheus@gmail.com>
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
Instituto de Ciências Matemáticas e de Computação - ICMC
Universidade de São Paulo - USP





On Mon, Feb 27, 2012 at 7:17 AM, Wissem <kiwan2005@gmail.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@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








--
WIssem EL KHLIFI,

Oracle ACE
Senior Oracle DBA
Database Team Leader
Computer Science Engineer








--
WIssem EL KHLIFI,

Oracle ACE
Senior Oracle DBA
Database Team Leader
Computer Science Engineer




Re: Automatic Failover Hot Standby / Streaming replication

From
Wissem
Date:
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 <kiwan2005@gmail.com>
I installed the missing package and I have;

pgpool -v
pgpool-II version 3.1 (hatsuiboshi)




2012/2/27 Matheus de Oliveira <matioli.matheus@gmail.com>
You have to install the postgresql client libraries first, it's missing.

Must be something like:

yum install postgresql9.1-client

But I'm not sure about the right package name.
On Mon, Feb 27, 2012 at 9:07 AM, Wissem <kiwan2005@gmail.com> wrote:
Hi Matheus,

When I run ;

$ pgpool -v

I have:

pgpool: error while loading shared libraries: libpq.so.5: cannot open shared object file: No such file or directory

Could you please help installing pgpool ?

Thanks,
Wissem

2012/2/27 Matheus de Oliveira <matioli.matheus@gmail.com>
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
Instituto de Ciências Matemáticas e de Computação - ICMC
Universidade de São Paulo - USP





On Mon, Feb 27, 2012 at 7:17 AM, Wissem <kiwan2005@gmail.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@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

杨晓青




Re: Automatic Failover Hot Standby / Streaming replication

From
Matheus de Oliveira
Date:
The default location is /usr/local/etc, but you can change it when you call the pgpool.

I'm attaching the samples that come with pgpool 3.1.2.

Regards,
--
Matheus de Oliveira

Bacharelado em Ciências de Computação
Laboratório de Computação de Alto Desempenho - LCAD
Instituto de Ciências Matemáticas e de Computação - ICMC
Universidade de São Paulo - USP




On Mon, Feb 27, 2012 at 9:53 AM, Wissem <kiwan2005@gmail.com> wrote:
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 <kiwan2005@gmail.com>
I installed the missing package and I have;

pgpool -v
pgpool-II version 3.1 (hatsuiboshi)




2012/2/27 Matheus de Oliveira <matioli.matheus@gmail.com>
You have to install the postgresql client libraries first, it's missing.

Must be something like:

yum install postgresql9.1-client

But I'm not sure about the right package name.
On Mon, Feb 27, 2012 at 9:07 AM, Wissem <kiwan2005@gmail.com> wrote:
Hi Matheus,

When I run ;

$ pgpool -v

I have:

pgpool: error while loading shared libraries: libpq.so.5: cannot open shared object file: No such file or directory

Could you please help installing pgpool ?

Thanks,
Wissem

2012/2/27 Matheus de Oliveira <matioli.matheus@gmail.com>
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
Instituto de Ciências Matemáticas e de Computação - ICMC
Universidade de São Paulo - USP





On Mon, Feb 27, 2012 at 7:17 AM, Wissem <kiwan2005@gmail.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@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

杨晓青





Attachment

Re: Automatic Failover Hot Standby / Streaming replication

From
Lennin Caro
Date:
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




Re: Automatic Failover Hot Standby / Streaming replication

From
Wissem
Date:
Thank you.

Now, I have the Master / Slave setup.

Virtual machine: Postgresql Master installed + pgpool installed
Virtual machine: Postgresql Slave installed,

The Hot Standby / Streaming replication on 2 servers works perfecly with manual failover.

Now, I want to configure pgpool to do the automatic failover, my questions are:

1- How to configure pgpool so it knows the HS/SR configuration I already setup? 
2- How pgpool will know about my HS/SR setup?
3- How to setup the automnatic failover with pgpool?

Thank you


2012/2/27 Matheus de Oliveira <matioli.matheus@gmail.com>
The default location is /usr/local/etc, but you can change it when you call the pgpool.

I'm attaching the samples that come with pgpool 3.1.2.


Regards,
--
Matheus de Oliveira

Bacharelado em Ciências de Computação
Laboratório de Computação de Alto Desempenho - LCAD
Instituto de Ciências Matemáticas e de Computação - ICMC
Universidade de São Paulo - USP




On Mon, Feb 27, 2012 at 9:53 AM, Wissem <kiwan2005@gmail.com> wrote:
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 <kiwan2005@gmail.com>
I installed the missing package and I have;

pgpool -v
pgpool-II version 3.1 (hatsuiboshi)




2012/2/27 Matheus de Oliveira <matioli.matheus@gmail.com>
You have to install the postgresql client libraries first, it's missing.

Must be something like:

yum install postgresql9.1-client

But I'm not sure about the right package name.
On Mon, Feb 27, 2012 at 9:07 AM, Wissem <kiwan2005@gmail.com> wrote:
Hi Matheus,

When I run ;

$ pgpool -v

I have:

pgpool: error while loading shared libraries: libpq.so.5: cannot open shared object file: No such file or directory

Could you please help installing pgpool ?

Thanks,
Wissem

2012/2/27 Matheus de Oliveira <matioli.matheus@gmail.com>
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
Instituto de Ciências Matemáticas e de Computação - ICMC
Universidade de São Paulo - USP





On Mon, Feb 27, 2012 at 7:17 AM, Wissem <kiwan2005@gmail.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@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

杨晓青










Re: Automatic Failover Hot Standby / Streaming replication

From
Lennin Caro
Date:
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
cd pgpool-II-3.1
./configure --prefix=/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&  


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: "Matheus de Oliveira" <matioli.matheus@gmail.com>
Cc: "杨晓青" <xqy1522@gmail.com>, pgsql-admin@postgresql.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 <kiwan2005@gmail.com>
I installed the missing package and I have;

pgpool -v
pgpool-II version 3.1 (hatsuiboshi)




2012/2/27 Matheus de Oliveira <matioli.matheus@gmail.com>
You have to install the postgresql client libraries first, it's missing.

Must be something like:

yum install postgresql9.1-client

But I'm not sure about the right package name.
On Mon, Feb 27, 2012 at 9:07 AM, Wissem <kiwan2005@gmail.com> wrote:
Hi Matheus,

When I run ;

$ pgpool -v

I have:

pgpool: error while loading shared libraries: libpq.so.5: cannot open shared object file: No such file or directory

Could you please help installing pgpool ?

Thanks,
Wissem

2012/2/27 Matheus de Oliveira <matioli.matheus@gmail.com>
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
Instituto de Ciências Matemáticas e de Computação - ICMC
Universidade de São Paulo - USP





On Mon, Feb 27, 2012 at 7:17 AM, Wissem <kiwan2005@gmail.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@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

杨晓青