| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Neil Morgan <N(dot)A(dot)Morgan(at)brighton(dot)ac(dot)uk> |
| Cc: | "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org> |
| Subject: | Re: pg_dump out of memory |
| Date: | 2012-10-17 17:57:19 |
| Message-ID: | 28051.1350496639@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
Neil Morgan <N(dot)A(dot)Morgan(at)brighton(dot)ac(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Shams Khan | 2012-10-17 19:15:24 | Postgresql switch over process |
| Previous Message | Neil Morgan | 2012-10-17 17:07:34 | pg_dump out of memory |