Обсуждение: 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? (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