Axel Rau <[email protected]> writes:
> I have a daily remote backup session like
> pg_dump -h db -i -Fp database | gzip > file
> which hangs after producing about 200 MB of compressed output:
Is it CPU-busy, or idle? If the latter, is it blocked on a lock
according to pg_locks?
The most informative thing you could do is attach to both pg_dump and
its connected backend with gdb and get stack traces. But looking at
pg_locks might solve the mystery without that.
regards, tom lane
--
Sent via pgsql-admin mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
