Axel Rau <Axel.Rau@xxxxxxxxx> 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 (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
