Axel Rau <Axel(dot)Rau(at)chaos1(dot)de> 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