>> BTW, is there any reliable way to know a standby is promoting to
>> primary?
>
> You can know that from the server log. But there is no way to do that
> via SQL, I think.
Ok. It seems I need to patch PostgreSQL.
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese: http://www.sraoss.co.jp