Re: Automatic Failover Hot Standby / Streaming replication

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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@xxxxxxxxx>
I installed the missing package and I have;

pgpool -v
pgpool-II version 3.1 (hatsuiboshi)




2012/2/27 Matheus de Oliveira <matioli.matheus@xxxxxxxxx>
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@xxxxxxxxx> 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@xxxxxxxxx>
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@xxxxxxxxx> 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@xxxxxxxxx>
 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@xxxxxxxxx>

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,






--
-------------------------------------------
best regards

杨晓青





[Index of Archives]     [KVM ARM]     [KVM ia64]     [KVM ppc]     [Virtualization Tools]     [Spice Development]     [Libvirt]     [Libvirt Users]     [Linux USB Devel]     [Linux Audio Users]     [Yosemite Questions]     [Linux Kernel]     [Linux SCSI]     [XFree86]

  Powered by Linux