Error while executing pg_dump "invalid memory alloc request size 4294967293"

------=_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;!--
		@[EMAIL PROTECTED]
 { 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;!--
		@[EMAIL PROTECTED]
 { 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--