Questions regarding PostgreSQL warm backup.

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