Dear Mr. Masao
My name is Damon. I read your comments regarding pg_standby warm backup. "New trigger option of pg_standby". I got several questions on this article. 1. I don't know why I have to trigger twice when switching from pg_standby status to normal status? I saw this Patch file, how do I use it? Is it a trigger file? Or something else? ( <http://archives.postgresql.org/pgsql-hackers/2009-03/binbkUmMAXWMP.bin> pgstandby_new_trigger_0325.patch) Here's the content in the recovery.conf file: restore_command = '/usr/local/pgsql/bin/pg_standby -l -d -s 5 -k 5 -t /tmp/stopstandby.bin /home/wal_log/ %f %p %r 2>>standby.log' Thanks a lot. Damon Xu