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