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

[Khapare Joshi]

Hi,
 thanks, I just installed the pgpool-II 3.2 version. Maybe I am not
understanding but when I issue the following commands it tells me master
and slave :

postgres=# SHOW pool_nodes;
 node_id |    hostname     | port | status | lb_weight |  role
---------+-----------------+------+--------+-----------+--------
 0       | 192.168.10.1 | 5432 | 2      | 0.500000  | master
 1       | 192.168.10.2 | 5432 | 2      | 0.500000  | slave
(2 rows)

I have not configured the master slave mode. What it will do If i add
number third. ?

K

On Wed, Sep 19, 2012 at 1:07 PM, Lazáro Rubén García Martínez <
lgarciam at vnz.uci.cu> wrote:

> 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
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20120920/04299260/attachment.html>