Re: [ADMIN] pg_dump out of memory

2012-10-17 Thread Tom Lane
Neil Morgan 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

[ADMIN] pg_dump out of memory

2012-10-17 Thread Neil Morgan
Dear All, 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. I have looked on the forums for memory issues, and can say that the data is not corrupt. We are running a VM with RHEL6, 4GB RAM, 2CPU and 80GB HDD Does any