Received: from localhost (unknown [200.46.204.183]) by developer.postgresql.org (Postfix) with ESMTP id 9D0F12E008A for ; Fri, 23 May 2008 01:22:19 -0300 (ADT) Received: from developer.postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 81909-02-4 for ; Fri, 23 May 2008 01:22:09 -0300 (ADT) X-Greylist: delayed 00:54:01.446002 by SQLgrey-1.7.6 Received: from po-out-1718.google.com (po-out-1718.google.com [72.14.252.154]) by developer.postgresql.org (Postfix) with ESMTP id 9BA042E009D for ; Fri, 23 May 2008 01:19:46 -0300 (ADT) Received: by po-out-1718.google.com with SMTP id y22so1171302pof.3 for ; Thu, 22 May 2008 21:19:45 -0700 (PDT) Received: by 10.140.127.20 with SMTP id z20mr418484rvc.77.1211513003786; Thu, 22 May 2008 20:23:23 -0700 (PDT) Received: by 10.140.201.2 with HTTP; Thu, 22 May 2008 20:23:23 -0700 (PDT) Message-ID: <33632cf0805222023o208f4ac2i73c24a636e639760@mail.gmail.com> Date: Fri, 23 May 2008 08:53:23 +0530 From: "Vishal Mailinglist" To: "Amit jain" Subject: Re: Error while executing pg_dump "invalid memory alloc request size 4294967293" Cc: tgl@sss.pgh.pa.us, pgsql-admin@postgresql.org, pgsql-hackers@postgresql.org In-Reply-To: MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_10642_31144480.1211513003772" References: X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200805/192 X-Sequence-Number: 29276 ------=_Part_10642_31144480.1211513003772 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline Hi , Make sure no one is connected to the database while doing the back up. Usually memory alloc error comes if its a bad RAM . check the pg_dump version and your database version match (this could be a guess) try file level backup and restore into new database. On 22/05/2008, Amit jain wrote: > > Hello All, > > We are using postgresql version 8.1 and our database size is 7gb. Ram Size > is 2 GB. > > while trying to take backup through pg_dump i am getting following error. > > oka97: pg_dump amtdb > amtdb.out > pg_dump: ERROR: invalid memory alloc request size 4294967293 > pg_dump: SQL command to dump the contents of table "atbs2_logs" failed: > PQendcopy() failed. > pg_dump: Error message from server: ERROR: invalid memory alloc request > size 4294967293 > pg_dump: The command was: COPY public.atbs2_logs (sno, request_time, > msisdn, phone_make, error_code, error_desc, reply_message, request_query, > responce_time, request_type) TO stdout; > > When I tried to take a single table backup i.e is mentioned in the error > named* "public.atbs2_logs" then again getting following error. > * > > pg_dump: SQL command failed > pg_dump: Error message from server: server closed the connection > unexpectedly > This probably means the server terminated abnormally > before or while processing the request. > pg_dump: The command was: FETCH 100 FROM _pg_dump_cursor > > > So we are unable to take backup , we have tried the vacuum and reindex but > not of any use. > > Kindly help us Any help would be highly appreciate. Thanx in Advance. > > > Amit Jain > > +91-9818450022 > > > > > > > -- Regards, Vishal Kashyap. Need help visit http://help.vishal.net.in ------=_Part_10642_31144480.1211513003772 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline
Hi ,
 
Make sure no one is connected to the database while doing the back up. Usually memory alloc error comes if its a bad  RAM .
check the pg_dump version and your database version match (this could be a guess)
try file level backup and restore into new database.

 
On 22/05/2008, Amit jain <amitjain.bit@gmail.com> wrote:
Hello  All,

We are using postgresql version 8.1 and our database size is 7gb. Ram Size is 2 GB. 

while trying to take backup through pg_dump i am getting following error.

oka97:  pg_dump amtdb > amtdb.out
pg_dump: ERROR:  invalid memory alloc request size 4294967293
pg_dump: SQL command to dump the contents of table "atbs2_logs" failed: PQendcopy() failed.
pg_dump: Error message from server: ERROR:  invalid memory alloc request size 4294967293
pg_dump: The command was: COPY public.atbs2_logs (sno, request_time, msisdn, phone_make, error_code, error_desc, reply_message, request_query, responce_time, request_type) TO stdout;


When I tried to take a single table backup i.e is mentioned in the error named "public.atbs2_logs"  then again getting following error.

pg_dump: SQL command failed
pg_dump: Error message from server: server closed the connection unexpectedly
This probably means the server terminated abnormally
before or while processing the request.
pg_dump: The command was: FETCH 100 FROM _pg_dump_cursor



So we are unable to take backup , we have tried the vacuum and reindex but not of any use.

Kindly help us Any help would be highly appreciate. Thanx in Advance.



Amit Jain

+91-9818450022









--
Regards,
Vishal Kashyap.
Need help visit
http://help.vishal.net.in ------=_Part_10642_31144480.1211513003772--