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
В списке pgsql-admin по дате отправления: