Received: from localhost (unknown [200.46.204.183])
	by developer.postgresql.org (Postfix) with ESMTP id 371D52E005B
	for <pgsql-admin-postgresql.org@developer.postgresql.org>;
	Thu, 22 May 2008 10:48:04 -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 76955-10
	for <pgsql-admin-postgresql.org@developer.postgresql.org>;
	Thu, 22 May 2008 10:47:47 -0300 (ADT)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6
Received: from ti-out-0910.google.com (ti-out-0910.google.com
 [209.85.142.188])
	by developer.postgresql.org (Postfix) with ESMTP id 579F52E0037
	for <pgsql-admin@postgresql.org>; Thu, 22 May 2008 10:47:52 -0300 (ADT)
Received: by ti-out-0910.google.com with SMTP id y8so54915tia.5
	for <pgsql-admin@postgresql.org>; Thu, 22 May 2008 06:47:48 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma;
	h=domainkey-signature:received:received:message-id:date:from:to:subject:mime-version:content-type;
	bh=8eSHNRRKCriVm0aoGHGV/Eska1T5IbAoy85gyDDkGqE=;
	b=D8vObJb8bM7ArrnRLAHayZ9etyipq6X7Sq/mzFd74wqCrgIxWRECRtp8RmxhLgEd7O8211RxycALqs6qzGPTgIG+tmnCcTnCvYUqYKdp+7PNr6jHPEh3hl4rwjpcM7gnP2xveb7IxgPhqwTJwhaX2UfcTcky1xUHpdoz7tSgxBY=
DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma;
	h=message-id:date:from:to:subject:mime-version:content-type;
	b=feyxiXODbxQhnuJi6nlRGz57rsubaqVsUlxt9fXsLAzR96yaU9uE4SvL6Deqfc4ivET2wvqTvzbY6hkx+ljfxx2DsJnCYScjG8X0kCjzKXn7KZ5vBCWf8m9WF+gGBs9HRWK8s+vM4VRR45WEzUt3AN/ZqTO/LzZe0gz3hTIOZzU=
Received: by 10.150.82.41 with SMTP id f41mr230861ybb.174.1211464066493;
	Thu, 22 May 2008 06:47:46 -0700 (PDT)
Received: by 10.151.67.20 with HTTP; Thu, 22 May 2008 06:47:45 -0700 (PDT)
Message-ID: <daf917830805220647u6deb00ddx899b96c5de7faadd@mail.gmail.com>
Date: Thu, 22 May 2008 19:17:45 +0530
From: "Amit jain" <amitjain.bit@gmail.com>
To: tgl@sss.pgh.pa.us, pgsql-admin@postgresql.org,
 pgsql-hackers@postgresql.org
Subject: Error while executing pg_dump "invalid memory alloc request size
	4294967293"
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_Part_4239_10278653.1211464066561"
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Archive-Number: 200805/184
X-Sequence-Number: 29268

------=_Part_4239_10278653.1211464066561
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

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

------=_Part_4239_10278653.1211464066561
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

Hello&nbsp; All,<br><br>We are using postgresql version 8.1 and our database size is 7gb. Ram Size is 2 GB.&nbsp; <br><br>while trying to take backup through pg_dump i am getting following error.<br>


	<meta http-equiv="CONTENT-TYPE" content="text/html; charset=utf-8"><title></title><meta name="GENERATOR" content="OpenOffice.org 2.2  (Linux)"><meta name="AUTHOR" content="Ashokraj"><meta name="CREATED" content="20080522;16413300"><meta name="CHANGEDBY" content="Ashokraj"><meta name="CHANGED" content="20080522;18390100">
	
	
	
	
	
	
	<style type="text/css">
	&lt;!--
		@page { size: 8.5in 11in; margin: 0.79in }
		P { margin-bottom: 0.08in }
	--&gt;
	</style>

<p style="margin-bottom: 0in;"><a name="1fgb"></a>oka97:&nbsp; pg_dump
amtdb &gt; amtdb.out<br>pg_dump: ERROR: &nbsp;invalid memory alloc
request size 4294967293<br>pg_dump: SQL command to dump the contents
of table &quot;atbs2_logs&quot; failed: PQendcopy() failed.<br>pg_dump:
Error message from server: ERROR: &nbsp;invalid memory alloc request
size 4294967293<br>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;</p><br>When I tried to take a single table backup i.e is mentioned in the error named<b> &quot;public.atbs2_logs&quot;&nbsp; then again getting following error.<br>
</b><p style="margin-bottom: 0in;">


	<meta http-equiv="CONTENT-TYPE" content="text/html; charset=utf-8"><title></title><meta name="GENERATOR" content="OpenOffice.org 2.2  (Linux)"><meta name="AUTHOR" content="Ashokraj"><meta name="CREATED" content="20080522;16413300"><meta name="CHANGEDBY" content="Ashokraj"><meta name="CHANGED" content="20080522;18541100">
	
	
	
	
	
	
	<style type="text/css">
	&lt;!--
		@page { size: 8.5in 11in; margin: 0.79in }
		P { margin-bottom: 0.08in }
	--&gt;
	</style>

</p><p style="margin-bottom: 0in;">pg_dump: SQL command failed<br>pg_dump:
Error message from server: server closed the connection
unexpectedly<br>This probably means the server terminated
abnormally<br>before or while processing the request.<br>pg_dump: The
command was: FETCH 100 FROM _pg_dump_cursor</p>
<br><p style="margin-bottom: 0in;"><br><font color="#888888"></font></p><p style="margin-bottom: 0in;">So we are unable to take backup , we have tried the vacuum and reindex but not of any use. <br></p><p style="margin-bottom: 0in;">
Kindly help us Any help would be highly appreciate. Thanx in Advance.</p><br><p style="margin-bottom: 0in;"><br></p><p style="margin-bottom: 0in;">Amit Jain</p><p style="margin-bottom: 0in;">+91-9818450022<br> 
</p>
<p></p><p style="margin-bottom: 0in;"><br></p>
<br><br><br><br>

------=_Part_4239_10278653.1211464066561--