> JDBC is sending "show transaction_read_only" to find whether it is master > or not. > Victor's patch also started with it, but later it was transformed into > pg_is_in_recovery > by him as it appeared more appropriate to identify the master / slave.
In my understanding pg_is_in_recovery() returns true if it's a standby node. However, even if it returns other than true, the server is not necessarily a primary. Even it's not configured as a streaming replication primary, it returns other than true. So if your intention is finding a primary, I am not sure if pg_is_in_recovery() is the best solution. Best regards, -- Tatsuo Ishii SRA OSS, Inc. Japan English: http://www.sraoss.co.jp/index_en.php Japanese:http://www.sraoss.co.jp -- Sent via pgsql-hackers mailing list (firstname.lastname@example.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers