[pgpool-general: 1018] Re: pgpool-ha

[Lazáro Rubén García Martínez]

My recomendation is: Don´t wait to pgpool be available in the repos, install it from the source code and the latest stable version.

The stable version can be downloaded from this address:

http://git.postgresql.org/gitweb/?p=pgpool2.git;a=shortlog;h=refs/heads/V3_2_STABLE

When a node is detached, pgpool executes a failover, after failover it execute the command especidied in the property follow_master_command:

follow_master_command: This parameter specifies a command to run in master/slave streaming replication mode only after a master failover.

If you need to know when the pg server was down you can configure this property or this failover_commnad, with mail commnad. Another alternative is installing nagios and checks the pg service periodicaly.


If one server was down, you can recover this server performing an online recovery.

Looks this link:

http://www.pgpool.net/pgpool-web/contrib_docs/simple_sr_setting2/index.html


Regards.
________________________________________
From: Khapare Joshi [khapare77 at gmail.com]
Sent: Wednesday, September 19, 2012 4:53 AM
To: Lazáro Rubén García Martínez
Subject: Re: [pgpool-general: 1014] pgpool-ha

Thanks

On Tue, Sep 18, 2012 at 4:33 PM, Lazáro Rubén García Martínez <lgarciam at vnz.uci.cu<mailto:lgarciam at vnz.uci.cu>> wrote:
>This sound cool. So, you configured two pgpool II server with watchdog ?  Can you share the configuration  ? that would be good. I installed pgpool-II from postgres repo and pgpool-II 3.2 is not available yet. I hope this will be available there too.

I have 4 servers, 2 servers with postgresql and 2 servers with pgpool, in each pgpool servers runs the watchdog for the high availability of pgpool-II.


Ok, if one of the postgres server (backend) fails/down, how would you know ? do you get alert or is there a way to monitor. And, let say your backed number 2 down/unavailable etc - then you fixed the backed number two, how would you put back online without restarting Pgpool or taking service down ? If we just put the backend 2 - then this postgres server has old data. How would you address such scenario ? any idea ?



When does pgpool-II 3.2 will be available in postges repo  ? does anybody know ?


KH

________________________________
Fin a la injusticia, LIBERTAD AHORA A NUESTROS CINCO COMPATRIOTAS QUE SE ENCUENTRAN INJUSTAMENTE EN PRISIONES DE LOS EEUU!
http://www.antiterroristas.cu
http://justiciaparaloscinco.wordpress.com

Fin a la injusticia, LIBERTAD AHORA A NUESTROS CINCO COMPATRIOTAS QUE SE ENCUENTRAN INJUSTAMENTE EN PRISIONES DE LOS EEUU!
http://www.antiterroristas.cu
http://justiciaparaloscinco.wordpress.com