Re: Automatic Failover Hot Standby / Streaming replication - Mailing list pgsql-admin
From | Wissem |
---|---|
Subject | Re: Automatic Failover Hot Standby / Streaming replication |
Date | |
Msg-id | CAMx8-JWkvWRdv3Z=0ZymuopbicpfytBXjYSbg0Gz5_hJuRPiPw@mail.gmail.com Whole thread Raw |
In response to | Re: Automatic Failover Hot Standby / Streaming replication (Matheus de Oliveira <matioli.matheus@gmail.com>) |
List | pgsql-admin |
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 - USPOn 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 you2012/2/27 Wissem <kiwan2005@gmail.com>I installed the missing package and I have;pgpool -vpgpool-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 - USPOn Mon, Feb 27, 2012 at 9:07 AM, Wissem <kiwan2005@gmail.com> wrote:Hi Matheus,When I run ;$ pgpool -vI have:pgpool: error while loading shared libraries: libpq.so.5: cannot open shared object file: No such file or directoryCould you please help installing pgpool ?Thanks,Wissem2012/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 - USPOn 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.i386Is it correct? this will install full and complete pgpool librairies necessary for the Hot Standby / Streaming replication on 2 servers on my machine?Thanks2012/2/13 杨晓青 <xqy1522@gmail.com>This document may help you. http://www.pgpool.net/pgpool-web/pgpool-II/doc/pgpool-en.htmlsee "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
杨晓青
pgsql-admin by date: