Re: Unknown winsock error 10061while dumping a big database

From: Richard Huxton <dev(at)archonet(dot)com>
To: cyril(dot)velter(at)metadys(dot)com
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Unknown winsock error 10061while dumping a big database
Date: 2007-11-28 08:07:40
Message-ID: 474D21CC.8070603@archonet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Greg Smith 2007-11-28 08:19:08 Re: Linux v.s. Mac OS-X Performance
Previous Message Peter Childs 2007-11-28 07:42:13 Re: Unused item pointers - can someone explain?