Postgres Pro
Downloads
Home   >   mailing lists

Running backups on a standby server - Mailing list pgsql-admin

From Mark Steben
Subject Running backups on a standby server
Date
Msg-id CADyzmywjRTexKfKv+d-30tK5DtrZqjS7v+zeYg0LunPZ3173qw@mail.gmail.com
Whole thread Raw
Responses Re: Running backups on a standby server  (Scott Whitney <scott@journyx.com>)
List pgsql-admin
Tree view
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 | Autobase 
  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







pgsql-admin by date:

Previous
From: Nicolas Aubert
Date:
Subject: Re: vacuum analyse waiting
Next
From: Scott Whitney
Date:
Subject: Re: Running backups on a standby server