Hi guys, I'm using PostgreSQL 9.2 and I got one master and one slave with streaming replication.
Currently, I got a backup script that runs daily from the master, it generates a dump file with 30GB of data. I changed the script to start running from the slave instead the master, and I'm getting this errors now: pg_dump: Dumping the contents of table "invoices" failed: PQgetResult() > failed. > pg_dump: Error message from server: ERROR: canceling statement due to > conflict with recovery > DETAIL: User was holding a relation lock for too long. Isn't that possible? I can't run pg_dump from a slave? Cheers Patrick
