| From: | Mark Steben <mark(dot)steben(at)drivedominion(dot)com> |
|---|---|
| To: | pgsql-admin <pgsql-admin(at)postgresql(dot)org> |
| Subject: | Running backups on a standby server |
| Date: | 2016-03-24 19:10:35 |
| Message-ID: | CADyzmywjRTexKfKv+d-30tK5DtrZqjS7v+zeYg0LunPZ3173qw@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
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
this 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
removed.
Hot standby documentation tells me that I should be able to run COPY TO..
statements 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
www.twitter.com/DominionDealer
www.drivedominion.com <http://www.autorevenue.com/>
<http://autobasedigital.net/marketing/DD12_sig.jpg>
--
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Scott Whitney | 2016-03-24 19:42:58 | Re: Running backups on a standby server |
| Previous Message | jonescam | 2016-03-24 17:30:55 | New Tool - Looking for BETA Testers! |