|
I ran into the same issues.
SELECT pg_xlog_replay_pause()
pg_dump, etc, etc...
pg_xlog_replay_resume().
From: pgsql-admin-owner@xxxxxxxxxxxxxx <pgsql-admin-owner@xxxxxxxxxxxxxx> on behalf of Mark Steben <mark.steben@xxxxxxxxxxxxxxxxx>
Sent: Thursday, March 24, 2016 2:10 PM To: pgsql-admin Subject: 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 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/
|
