Questions regarding PostgreSQL warm backup. - Mailing list pgsql-hackers

From Damon Xu
Subject Questions regarding PostgreSQL warm backup.
Date
Msg-id 003f01c9fa1f$c4c11c50$db13a8c0@Hoperun.com
Whole thread Raw
List pgsql-hackers
<div class="Section1" style="layout-grid:15.6pt"><p class="MsoNormal"><font face="Arial" size="1"><span lang="EN-US"
style="font-size:
9.0pt;font-family:Arial">Dear Mr. Masao</span></font><p class="MsoNormal"><font face="Arial" size="1"><span
lang="EN-US"style="font-size: 
9.0pt;font-family:Arial"> </span></font><p class="MsoNormal"><font face="Arial" size="1"><span lang="EN-US"
style="font-size:
9.0pt;font-family:Arial">My name is Damon. </span></font><p class="MsoNormal"><font face="Arial" size="1"><span
lang="EN-US"style="font-size: 
9.0pt;font-family:Arial"> </span></font><p class="MsoNormal"><font face="Arial" size="1"><span lang="EN-US"
style="font-size:
9.0pt;font-family:Arial">I read your comments regarding pg_standby warm backup.<b><span style="font-weight:bold"> “New
triggeroption of pg_standby”. </span></b></span></font><p class="MsoNormal"><b><font face="Arial" size="1"><span
lang="EN-US"style="font-size:9.0pt;font-family:Arial;font-weight:bold"> </span></font></b><p class="MsoNormal"><b><font
face="Arial"size="1"><span lang="EN-US" style="font-size:9.0pt;font-family:Arial;font-weight:bold">I got several
questionson this article.</span></font></b><p class="MsoNormal"><b><font face="Arial" size="1"><span lang="EN-US"
style="font-size:9.0pt;font-family:Arial;font-weight:bold"> </span></font></b><pclass="MsoNormal"
style="margin-left:18.0pt;text-indent:-18.0pt;mso-list:l0level1 lfo1"><b><font face="Arial" size="1"><span lang="EN-US"
style="font-size:9.0pt;font-family:Arial;
font-weight:bold"><span style="mso-list:Ignore">1.<font face="Times New Roman" size="1"><span style="font:7.0pt "Times
NewRoman"">       </span></font></span></span></font></b><b><font face="Arial" size="1"><span lang="EN-US"
style="font-size:9.0pt;font-family:Arial;font-weight:bold">Idon’t know why I have to trigger twice when switching from
pg_standbystatus to normal status?  </span></font></b><p class="MsoNormal"><b><font face="Arial" size="1"><span
lang="EN-US"style="font-size:9.0pt;font-family:Arial;font-weight:bold">I saw this Patch file, how do I use it?  Is it a
triggerfile? Or something else? (</span></font><strong><b><font face="Times New Roman"><span lang="EN-US"><a
href="http://archives.postgresql.org/pgsql-hackers/2009-03/binbkUmMAXWMP.bin"><tt><fontface="宋体" size="3"><span
style="font-size:12.0pt">pgstandby_new_trigger_0325.patch</span></font></tt></a></span></font></b></strong></b><font
face="Arial"size="1"><span lang="EN-US" style="font-size:9.0pt;font-family:Arial">)</span></font><p
class="MsoNormal"><fontface="Arial" size="1"><span lang="EN-US" style="font-size: 
9.0pt;font-family:Arial"> </span></font><p class="MsoNormal"><font face="Arial" size="1"><span lang="EN-US"
style="font-size:
9.0pt;font-family:Arial">Here’s the content in the recovery.conf file:</span></font><p class="MsoNormal"><font
face="Arial"size="1"><span lang="EN-US" style="font-size: 
9.0pt;font-family:Arial">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'</span></font><p class="MsoNormal"><font face="Arial" size="1"><span
lang="EN-US"style="font-size: 
9.0pt;font-family:Arial"> </span></font><p class="MsoNormal"><font face="Arial" size="1"><span lang="EN-US"
style="font-size:
9.0pt;font-family:Arial">Thanks a lot.  </span></font><p class="MsoNormal"><font face="Arial" size="1"><span
lang="EN-US"style="font-size: 
9.0pt;font-family:Arial"> </span></font><p class="MsoNormal"><font face="Arial" size="1"><span lang="EN-US"
style="font-size:
9.0pt;font-family:Arial"> </span></font><p class="MsoNormal"><font face="Arial" size="1"><span lang="EN-US"
style="font-size:
9.0pt;font-family:Arial">Damon Xu</span></font></div>

pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: 8.5 development schedule
Next
From: David E. Wheeler
Date:
Subject: Re: Mention CITEXT in the FAQ