Re: Running backups on a standby server - Mailing list pgsql-admin
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
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
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
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/
pgsql-admin by date: