Re: pg_dump out of memory - Mailing list pgsql-admin

Neil Morgan <N.A.Morgan@brighton.ac.uk> writes:
> I am running a PostgreSQL 8.3 server (not my choice, would prefer 9.1) but I am experiencing memory issues when using
pg_dump.

8.3.what?

> Does anyone have any ideas please?

For starters, turn on log_statements so you can see what query is
triggering this.  It'd be even better if you can get a stack trace
from the point of the errfinish call.
https://wiki.postgresql.org/wiki/Generating_a_stack_trace_of_a_PostgreSQL_backend

            regards, tom lane