[prev in list] [next in list] [prev in thread] [next in thread]
List: postgresql-admin
Subject: Re: [ADMIN] Running backups on a standby server
From: Scott Whitney <scott () journyx ! com>
Date: 2016-03-24 19:42:58
Message-ID: BY1PR11MB0390DA027A5C7A810CC40963A7820 () BY1PR11MB0390 ! namprd11 ! prod ! outlook ! com
[Download RAW message or body]
I ran into the same issues.
SELECT pg_xlog_replay_pause()
pg_dump, etc, etc...
pg_xlog_replay_resume().
________________________________
From: pgsql-admin-owner@postgresql.org <pgsql-admin-owner@postgresql.org> o=
n behalf of Mark Steben <mark.steben@drivedominion.com>
Sent: Thursday, March 24, 2016 2:10 PM
To: pgsql-admin
Subject: [ADMIN] Running backups on a standby server
Good afternoon,
We are running postgres 9.2.12 and populating our dr site with hot standby.=
I'd like to run
pg_dump backups of our dbs on the standby if possible. I tried and got thi=
s error after about 2 minutes.
ERROR: canceling statement due to conflict with recovery
DETAIL: User query might have needed to see row versions that must be re=
moved.
Hot standby documentation tells me that I should be able to run COPY TO.. s=
tatements in
a standby server. Any insights appreciated.
Thank you,
--
Mark Steben
Database Administrator
@utoRevenue<http://www.autorevenue.com/> | Autobase<http://www.autobase.net=
/>
CRM division of Dominion Dealer Solutions
95D Ashley Ave.
West Springfield, MA 01089
t: 413.327-3045
f: 413.383-9567
www.fb.com/DominionDealerSolutions<http://www.fb.com/DominionDealerSolution=
s>
www.twitter.com/DominionDealer<http://www.twitter.com/DominionDealer>
www.drivedominion.com<http://www.autorevenue.com/>
<http://autobasedigital.net/marketing/DD12_sig.jpg>
[https://lh6.googleusercontent.com/tBOSGongVuRhiDaCrssxCO7MhtC9P3dykHqNZb1k=
1NajNIaQO0MEpdsyE9vFnhshtystUQQf8rm_spyUuRwIqvhaqQM0aQ2yd-NUyXpOWkmlr6cc5yt=
sLr0xQiJhKRkRA4vfyzk]<http://www.drivedominion.com/nada>
Journyx, Inc.
7600 Burnet Road #300
Austin, TX 78757
www.journyx.com
p 512.834.8888
f 512-834-8858
Do you receive our promotional emails? You can subscribe or unsubscribe to =
those emails at http://go.journyx.com/emailPreference/e/4932/714/
[Attachment #3 (text/html)]
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<style type="text/css" style="display:none;"><!-- P {margin-top:0;margin-bottom:0;} \
--></style> </head>
<body dir="ltr">
<div id="divtagdefaultwrapper" \
style="font-size:12pt;color:#000000;background-color:#FFFFFF;font-family:Calibri,Arial,Helvetica,sans-serif;">
<p>I ran into the same issues.</p>
<p><br>
</p>
<p>SELECT pg_xlog_replay_pause()</p>
<p><br>
</p>
<p>pg_dump, etc, etc...</p>
<p><br>
</p>
<p>pg_xlog_replay_resume().</p>
<p><br>
</p>
<br>
<br>
<div style="color: rgb(0, 0, 0);">
<hr tabindex="-1" style="display:inline-block; width:98%">
<div id="divRplyFwdMsg" dir="ltr"><font face="Calibri, sans-serif" color="#000000" \
style="font-size:11pt"><b>From:</b> pgsql-admin-owner@postgresql.org \
<pgsql-admin-owner@postgresql.org> on behalf of Mark Steben \
<mark.steben@drivedominion.com><br> <b>Sent:</b> Thursday, March 24, 2016 2:10 \
PM<br> <b>To:</b> pgsql-admin<br>
<b>Subject:</b> [ADMIN] Running backups on a standby server</font>
<div> </div>
</div>
<div>
<div dir="ltr">Good afternoon,
<div><br>
</div>
<div>We are running postgres 9.2.12 and populating our dr site with hot \
standby. I'd like to run</div> <div>pg_dump backups of our dbs on the standby \
if possible. I tried and got this error after about 2 minutes.</div> <div><br>
</div>
<div> ERROR: canceling statement due to conflict with recovery
<div> DETAIL: User query might have needed to see row versions that must \
be removed.</div> <div><br>
</div>
<div>Hot standby documentation tells me that I should be able to run COPY TO.. \
statements in</div> <div>a standby server. Any insights appreciated.</div>
<div><br>
</div>
<div>Thank you,</div>
<div><br>
</div>
-- <br>
<div class="gmail_signature">
<div><span><font color="#888888"><span style="font-family:Calibri; \
font-size:11pt"><span style="color:rgb(51,51,51)"><b>Mark Steben</b></span> \
</span><br> Database Administrator<span style="font-family:'Century Gothic'; \
font-size:8pt"><span style="color:rgb(51,51,51)"></span><br> <a \
href="http://www.autorevenue.com/" target="_blank" style="color:rgb(79,129,189); \
font-size:8pt; font-weight:bold; text-decoration:none">@utoRevenue</a> <span \
style="color:rgb(79,129,189); font-size:10pt">|</span> <a \
href="http://www.autobase.net/" target="_blank" style="color:rgb(79,129,189); \
font-size:8pt; font-weight:bold; text-decoration:none">Autobase</a> <span \
style="color:rgb(79,129,189); font-size:10pt"></span> <br>
<span style="color:rgb(79,129,189); font-size:8pt; font-weight:bold; \
text-decoration:none"> CRM division of Dominion Dealer Solutions</span> <br>
<span style="color:gray; font-size:8pt">95D Ashley Ave.<br>
West Springfield, MA 01089</span> <br>
<span style="color:gray; font-size:8pt">t: <a \
value="+14132434800">413.327-3045</a></span> <br>
<span style="color:gray; font-size:8pt">f: <a \
value="+14132434800">413.383-9567</a></span> </span></font></span></div>
<p><span><font color="#888888"><span style="font-family:'Century Gothic'; \
font-size:8pt"><a href="http://www.fb.com/DominionDealerSolutions" \
target="_blank">www.fb.com/DominionDealerSolutions</a><br> <a \
href="http://www.twitter.com/DominionDealer" \
target="_blank">www.twitter.com/DominionDealer</a><br> <span style="color:gray; \
font-size:8pt"> <a href="http://www.autorevenue.com/" \
target="_blank">www.drivedominion.com</a><br> <br>
<a href="http://autobasedigital.net/marketing/DD12_sig.jpg" target="_blank"></a><br>
<br>
</span></span></font></span><br>
<span><font color="#888888"><span style="font-family:'Century Gothic'; \
font-size:8pt"><span style="color:gray; font-size:8pt"><br> \
</span></span></font></span></p> <font color="#888888"></font></div>
</div>
</div>
<br>
<span>
<p dir="ltr" style="line-height:1.38; margin-top:0pt; margin-bottom:0pt"><a \
href="http://www.drivedominion.com/nada" target="_blank"><span \
style="font-size:14.6667px; font-family:Arial; vertical-align:baseline; \
white-space:pre-wrap"><img width="427" height="59" style="border: none; \
-webkit-user-select: none;" \
src="https://lh6.googleusercontent.com/tBOSGongVuRhiDaCrssxCO7MhtC9P3dykHqNZb1k1NajNIa \
QO0MEpdsyE9vFnhshtystUQQf8rm_spyUuRwIqvhaqQM0aQ2yd-NUyXpOWkmlr6cc5ytsLr0xQiJhKRkRA4vfyzk"></span><span \
style="font-size:14.6667px; font-family:Arial; vertical-align:baseline; \
white-space:pre-wrap"></span></a></p> <br>
<p></p>
</span></div>
</div>
</div>
<div style="\"font-family:" \
timesnewroman,newyork,times,serif;font-size:12pt;color:#000000\?=""> <br>
<div><br>
</div>
<div><span name="\"x\""></span>
<div><span style="\"font-size:" 12pt;\?="">Journyx, Inc.</span></div>
<div>7600 Burnet Road #300 <br>
Austin, TX 78757 <br>
www.journyx.com <br>
</div>
<div><br>
</div>
<div>
<div><span style="\"font-size:" 12pt;\?data-mce-style="\"font-size:" \
12pt;\?="">p 512.834.8888 </span></div> <div>f 512-834-8858 </div>
<div><br>
</div>
</div>
<div>Do you receive our promotional emails? You can subscribe or unsubscribe to those \
emails at http://go.journyx.com/emailPreference/e/4932/714/ <br> </div>
</div>
</div>
</body>
</html>
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic