Received: from localhost (maia-5.hub.org [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id DAD089FB1C3 for ; Wed, 31 Jan 2007 14:14:50 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.182]) (amavisd-new, port 10024) with ESMTP id 46658-08 for ; Wed, 31 Jan 2007 14:14:45 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4 Received: from wx-out-0506.google.com (wx-out-0506.google.com [66.249.82.232]) by postgresql.org (Postfix) with ESMTP id 64D019F9F2A for ; Wed, 31 Jan 2007 14:14:46 -0400 (AST) Received: by wx-out-0506.google.com with SMTP id i28so301116wxd for ; Wed, 31 Jan 2007 10:14:46 -0800 (PST) DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:message-id:date:from:to:subject:mime-version:content-type; b=WAkSUlZnUgUh+iKdmK9Vn6DFVSwJzOdayirni8VD/RQ7Dx2l4XIbLN4sfnXD547+Ig5rb7vBtNaxMQA8SEjqJ6LWvVLwruvAZfbH89aAImBp5+hkZRJ14pQyUp4ahLqqDuQsmKZ7hifMcne8ISCvfPmoOBuKBkiVFcwbJgKCzso= Received: by 10.70.90.12 with SMTP id n12mr1520427wxb.1170267281824; Wed, 31 Jan 2007 10:14:41 -0800 (PST) Received: by 10.70.35.7 with HTTP; Wed, 31 Jan 2007 10:14:41 -0800 (PST) Message-ID: <896477840701311014t21d07275kd2bd5c01b9a92b67@mail.gmail.com> Date: Wed, 31 Jan 2007 18:14:41 +0000 From: "airbulb " To: pgsql-admin@postgresql.org Subject: Unable to pg_dump 8.1.2 - memory alloc error MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_7260_17440547.1170267281417" X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.611 tagged_above=0 required=5 tests=BAYES_20, HTML_10_20, HTML_MESSAGE, SPF_PASS X-Spam-Level: X-Archive-Number: 200702/70 X-Sequence-Number: 24535 ------=_Part_7260_17440547.1170267281417 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline Hello I get the following error when dumping a pg database with WIN_1252 encoding: pg_dump --clean --no-owner dumpfile | gzip >/home/postgres/globalen.dump.gz 2>>./err.out pg_dump: ERROR: invalid memory alloc request size 4294967293 pg_dump: SQL command to dump the contents of table "site" failed: PQendcopy() failed. pg_dump: Error message from server: ERROR: invalid memory alloc request size 4294967293 pg_dump: The command was: COPY public.site (site_id, url, status, created, "domain", title) TO stdout; Possibly related is a particular query with pgAdmin on same site table with above error yields ERROR: invalid multibyte character for locale I have upgraded from 8.1.2 to 8.1.6 but get the same error. Any help appreciated. Regards, David. ------=_Part_7260_17440547.1170267281417 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline Hello

I get the following error when dumping a pg database with WIN_1252 encoding:

pg_dump --clean --no-owner dumpfile | gzip >/home/postgres/globalen.dump.gz 2>>./err.out

pg_dump: ERROR:  invalid memory alloc request size 4294967293
pg_dump: SQL command to dump the contents of table "site" failed: PQendcopy() failed.
pg_dump: Error message from server: ERROR:  invalid memory alloc request size 4294967293
pg_dump: The command was: COPY public.site (site_id, url, status, created, "domain", title) TO stdout;

Possibly related is a particular query with pgAdmin on same site table with above error yields
ERROR:  invalid multibyte character for locale

I have upgraded from 8.1.2 to 8.1.6 but get the same error.

Any help appreciated.

Regards,
David.
------=_Part_7260_17440547.1170267281417--