From: pgsql-hackers-ow...@postgresql.org > [mailto:pgsql-hackers-ow...@postgresql.org] On Behalf Of Tatsuo Ishii > 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.
Yes, I don't think pg_is_in_recovery() is the best, but there doesn't seem to be a better solution. pg_is_in_recovery(), as its name clearly suggests, returns true if the server is performing recovery. For example, it returns true if hot_standby=on is present in postgresql.conf and the recovery from backup is in progress. It's not a standby. Regards Takayuki Tsunakawa -- Sent via pgsql-hackers mailing list (firstname.lastname@example.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers