From: Tatsuo Ishii [mailto:is...@sraoss.co.jp] > But pg_is_in_recovery() returns true even for a promoting standby. So > you have to wait and retry to send pg_is_in_recovery() until it > finishes the promotion to find out it is now a primary. I am not sure > if backend out to be responsible for this process. If not, libpq would > need to handle it but I doubt it would be possible.
Yes, the application needs to retry connection attempts until success. That's not different from PgJDBC and other DBMSs. Regards Takayuki Tsunakawa