On 15 Sep 2017, at 07:55, Vladimir Sitnikov <sitnikov.vladimir@gmail.com> wrote:
> 1) pgjdbc is configured with a full set of connection URLs, targetServerType=master (default value is "any”)
Ok, so it uses a connection pool (c3p0) and he managed to figure out this
config line on his machine (that only have a ONE local PGSQL):
jdbc:postgresql://localhost,server2,server3/fc?targetServerType=master
It connected just fine to his local server AND tried server2 and server3 if he
shut that down.
HOWEVER, that doesn’t solve my problem with load balancing :(.
So my my question is still, if I give it
jdbc:postgresql://round-robin/fc?targetServerType=master
where ‘round-robin’ is a DNS round-robin entry for ALL the servers,
master AND all the replicas, will this still work?