Skip site navigation (1) Skip section navigation (2)

Questions regarding PostgreSQL warm backup.

From: "Damon Xu" <xu_tianjing(at)hoperun(dot)com>
To: <pgsql-hackers(at)postgresql(dot)org>
Subject: Questions regarding PostgreSQL warm backup.
Date: 2009-07-01 07:44:26
Message-ID: 003f01c9fa1f$c4c11c50$db13a8c0@Hoperun.com (view raw or flat)
Thread:
Lists: pgsql-hackers
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

pgsql-hackers by date

Next:From: Simon RiggsDate: 2009-07-01 07:58:06
Subject: Re: 8.5 development schedule
Previous:From: Robert HaasDate: 2009-07-01 06:14:07
Subject: Re: 8.5 development schedule

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group