[pgpool-general: 3899] Re: PGPool questions

[Gervais de Montbrun]

Hi lk,

I can comment on some of these... pgpool can be configured in many different combinations. I am using a dual server setup with both servers running pgpool and postgresql with replication and load balancing enabled. if pgpool fails on the server acting as the main/master pgpool server, then it fails over to the other. The pgpool slave takes over and brings up an interface with the same IP that pgpool uses. Both postgres servers are used for writes and either server is used for reads.

1. pgpool has a watchdog feature that talks to other pgpool servers
2. the watchdog triggers scripts that you configure to bring interfaces up/down as need be
3. multipl pgpool servers with multiple postgresql backend db servers
4. can't comment... no windows for me

Cheers,
Gervais

> On Jul 29, 2015, at 11:37 AM, lk gen <lkgen11 at gmail.com> wrote:
> 
> Hi,
> 
>   I have some questions about pgpool:
> 
> 1. Does PG pool use a witness server? how does PGPool prevents split-brain situations
> 2. Suppose there was an automatic failover, can the application use the same IP/port address as before the failover? what is the mechanism for that?
> 3, How do you prevent a single point of failure when connecting to the pgpool?
> 4. How difficult is it to port PGPool to Windows
> 
> Regards
> 
>   lk
> _______________________________________________
> pgpool-general mailing list
> pgpool-general at pgpool.net
> http://www.pgpool.net/mailman/listinfo/pgpool-general

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20150729/0758efc3/attachment.html>