Postgres Pro
Downloads
Home   >   mailing lists

Re: Unknown winsock error 10061while dumping a big database - Mailing list pgsql-general

From Richard Huxton
Subject Re: Unknown winsock error 10061while dumping a big database
Date
Msg-id 474D21CC.8070603@archonet.com
Whole thread Raw
In response to Unknown winsock error 10061while dumping a big database  ("Cyril VELTER" <cyril.velter@metadys.com>)
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: "Peter Childs"
Date:
Subject: Re: Unused item pointers - can someone explain?
Next
From: Greg Smith
Date:
Subject: Re: Linux v.s. Mac OS-X Performance