Re: remote pg_dump hangs always at same table

Axel Rau <Axel.Rau@chaos1.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