On Fri, Jan 18, 2019 at 5:33 PM Tsunakawa, Takayuki < tsunakawa.ta...@jp.fujitsu.com> wrote:
> From: Tsunakawa, Takayuki [mailto:tsunakawa.ta...@jp.fujitsu.com] > > As for prefer-standby/prefer-read, if host parameter specifies > host1,host2 > > in this order, and host1 is the primary with > > default_transaction_read_only=true, does the app get a connection to > host1? > > I want to connect to host2 (standby) only if host1 is down. > > Oops, reverse -- I wanted to say "I want to connect to host1 (primary) > only if host2 is down." > Thanks for finding out the problem, how about the following way of checking for prefer-read/prefer-standby. 1. (default_transaction_read_only = true and recovery = true) 2. If none of the host satisfies the above scenario, then recovery = true 3. Last check is for default_transaction_read_only = true Regards, Haribabu Kommi Fujitsu Australia
