Standby server lagging behind

Поиск
Список
Период
Сортировка
От Huda Booley (huda@careerjunction.co.za)
Тема Standby server lagging behind
Дата
Msg-id 3CE7330FFA8B1846B1D1C7237196FAB13559DAE612@cj-rba-exch01.careerjunction.local
обсуждение исходный текст
Ответы Re: Standby server lagging behind  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
Список pgsql-hackers
<div class="Section1"><p class="MsoNormal"><span
style="font-size:10.0pt;font-family:"Verdana","sans-serif"">Hi</span><pclass="MsoNormal"><span
style="font-size:10.0pt;font-family:"Verdana","sans-serif""> </span><pclass="MsoNormal"><span
style="font-size:10.0pt;font-family:"Verdana","sans-serif"">Weare running postgres8.3.9 and have enabled log shipping
replication.Our standby server is about 1000 files BEHIND – everything I’ve read indicates that the standby server
shouldbe very close behind the live server – at the rate we’re going it will take 8 hours to apply all the logs to
standby!How can I speed up the recovery process on the standby server?</span><p class="MsoNormal"><span
style="font-size:10.0pt;font-family:"Verdana","sans-serif""> </span><pclass="MsoNormal"><span
style="font-size:10.0pt;font-family:"Verdana","sans-serif"">Someinfo</span><p class="MsoNormal"><span
style="font-size:10.0pt;font-family:"Verdana","sans-serif"">Liveserver –16CPU, 80G Ram</span><p class="MsoNormal"><span
style="font-size:10.0pt;font-family:"Verdana","sans-serif"">wewrite about 2to3 16MB WAL files per minute</span><p
class="MsoNormal"><spanstyle="font-size:10.0pt;font-family:"Verdana","sans-serif"">These get copied to the standby so
itsall there, just not being applied fast enough. </span><p class="MsoNormal"><span
style="font-size:10.0pt;font-family:"Verdana","sans-serif""> </span><pclass="MsoNormal"><span
style="font-size:10.0pt;font-family:"Verdana","sans-serif""> </span><pclass="MsoNormal"><span
style="font-size:10.0pt;font-family:"Verdana","sans-serif"">Anyadvice would be most welcome</span><p
class="MsoNormal"><spanstyle="font-size:10.0pt;font-family:"Verdana","sans-serif""> </span><p class="MsoNormal"><span
style="font-size:10.0pt;font-family:"Verdana","sans-serif"">Ta</span><span
style="font-size:10.0pt;font-family:Wingdings">J</span><spanstyle="font-size: 
10.0pt;font-family:"Verdana","sans-serif""></span><p class="MsoNormal"><span
style="font-size:10.0pt;font-family:"Verdana","sans-serif""> </span><pclass="MsoNormal"><span
style="font-size:10.0pt;font-family:"Verdana","sans-serif""> </span><pclass="MsoNormal"><span
style="font-size:10.0pt;font-family:"Verdana","sans-serif";
color:blue">Huda Booley<br /> DBA | CareerJunction | Better jobs. More often.<br /> Web:<u>
www.careerjunction.co.za</u>|Email: <a href="mailto:huda@careerjunction.co.za"> <span
style="color:blue">huda@careerjunction.co.za</span></a><br/> Phone: +27 21 818 8635 | Mobile: +27 82 9587818 | Fax: +27
21818 8609</span><span style="font-size:12.0pt;font-family:"Times New Roman","serif";color:blue"> </span></div><br
/><hr/><font color="Gray" face="Verdana" size="1">Disclaimer<br /> This message contains information intended solely
forthe addressee, which is confidential or private in nature. If you are not the intended recipient, you may not
peruse,use, disseminate, distribute or copy this message or any file attached to this message. Any such unauthorised
use,is prohibited and may be unlawful. If you have received this message in error, please notify the sender immediately
bye-mail, facsimile or telephone and thereafter delete the original message from your machine.<br /> Furthermore, the
informationcontained in this message, and any attachments thereto, is for information purposes only and may contain the
personalviews and opinions of the author, which are not necessarily the views and opinions of CareerJunction or its
subsidiariesand associated companies. CareerJunction therefore does not accept liability for any claims, loss or
damagesof whatsoever nature, arising as a result of the reliance on such information by anyone.<br /> Whilst all
reasonablesteps are taken to ensure the accuracy and integrity of information transmitted electronically and to
preservethe confidentiality thereof, CareerJunction accepts no liability or responsibility whatsoever if information or
datais, for whatever reason, incorrect, corrupted or does not reach its intended destination.<br /></font> 

В списке pgsql-hackers по дате отправления:

Предыдущее
От: Leonardo F
Дата:
Сообщение: Re: About "Our CLUSTER implementation is pessimal" patch
Следующее
От: Dimitri Fontaine
Дата:
Сообщение: Re: Streaming Replication on win32