Thread: Running backups on a standby server

Running backups on a standby server

From
Mark Steben
Date:
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







Re: Running backups on a standby server

From
Scott Whitney
Date:

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> on 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 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









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/