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