Received: from localhost (maia-2.hub.org [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id 5FA1E9FB2B3 for ; Tue, 6 Feb 2007 05:51:40 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-new, port 10024) with ESMTP id 15050-05 for ; Tue, 6 Feb 2007 05:51:33 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4 Received: from an-out-0708.google.com (an-out-0708.google.com [209.85.132.248]) by postgresql.org (Postfix) with ESMTP id C1AE59FB2A6 for ; Tue, 6 Feb 2007 05:51:36 -0400 (AST) Received: by an-out-0708.google.com with SMTP id c24so1145937ana for ; Tue, 06 Feb 2007 01:51:36 -0800 (PST) DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:references; b=HAsDzLGyeop3ZIgvEEewXNtLk4iEGQo9gqoxS9wrzBXYVB1A942xxkAzgHxcqhjNeHYkYHqB/BaLxGr7W/9Gm9+mHoEloiqL9DVihNo7443s3QlLcLiBZoffCA1e+320T1ykgqBxtV2Yt8Bq7mBBL+cJRFeLvXKS/tWfrNIBups= Received: by 10.65.154.4 with SMTP id g4mr12593459qbo.1170755495649; Tue, 06 Feb 2007 01:51:35 -0800 (PST) Received: by 10.65.206.17 with HTTP; Tue, 6 Feb 2007 01:51:35 -0800 (PST) Message-ID: Date: Tue, 6 Feb 2007 14:51:35 +0500 From: "Shoaib Mir" To: airbulb Subject: Re: Unable to pg_dump 8.1.2 - memory alloc error Cc: pgsql-admin@postgresql.org In-Reply-To: <896477840701311014t21d07275kd2bd5c01b9a92b67@mail.gmail.com> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_1567_29648561.1170755495607" References: <896477840701311014t21d07275kd2bd5c01b9a92b67@mail.gmail.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200702/78 X-Sequence-Number: 24543 ------=_Part_1567_29648561.1170755495607 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline Hmmm that looks like to me a HW problem causing data corruption. Try doing a REINDEX for the database, if possible restart the database server machine and then try taking the dump again to see if that works. But I will recommend doing memory tests for the hardware... -- Shoaib Mir EnterpriseDB (www.enterprisedb.com) On 1/31/07, airbulb wrote: > > 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_1567_29648561.1170755495607 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline Hmmm that looks like to me a HW problem causing data corruption. Try doing a REINDEX for the database, if possible restart the database server machine and then try taking the dump again to see if that works.

But I will recommend doing memory tests for the hardware...

--
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)

On 1/31/07, airbulb < airbulb@gmail.com> wrote:
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_1567_29648561.1170755495607--