Cyril VELTER wrote:
>
> I recently upgraded a 8.0 database to 8.2 (server is running windows 2003
> server) and now I cannot dump the database any more.
>
> At some point in the dump, pg_dump (run on a centos 3 linux) return :
>
> pg_dump: Dumping the contents of table "c2674" failed: PQgetCopyData() failed.
> pg_dump: Error message from server: out of memory
That's the problem. Do you have maintenance_work_mem or work_mem set too
high perhaps?
--
Richard Huxton
Archonet Ltd