[pgpool-general: 6828] Re: Using standby pgpool instances

[Muhammad Usama]

Hi
The quick answer is you don’t need a virtual-IP if your setup doesn’t need one, and you can connect to standby pgpool without any problem 

Thanks
Best regards 
Muhammad Usama 

Sent from my iPhone

> On 27-Jan-2020, at 5:33 PM, Frodo Looijaard <frodo at frodo.looijaard.name> wrote:
> 
> Hello,
> 
> I am wondering whether we need a floating IP when using multiple pgpool
> instances with the watchdog (pgpool-II-4.1.0).
> 
> It seems you can just connect with a non-master pgpool instance.
> 
> Can we expect trouble when we connect to a non-master pgpool node? Can we
> expect trouble when some connections use the master node and others at the
> same time use a non-master node, accessing the same Postgres database?
> 
> If this can safely be done, we would not need a floating IP; it would
> suffice to add all pgpool-nodes as alternatives to a JDBC-URL.
> 
> If this is not safe, would it not be a nice feature to (perhaps optionally)
> disable connections to non-master pgpool nodes?
> 
> Thanks for your time,
>  Frodo Looijaard
> 
> _______________________________________________
> pgpool-general mailing list
> pgpool-general at pgpool.net
> http://www.pgpool.net/mailman/listinfo/pgpool-general