------=_Part_12830_21391185.1211578470998
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
Hi ,
I have tried to taken backup while no one is connected. Should i change my
> RAM and then check it. Version are same of pg_dump and database version
8.1.
Yes try that . Though I dont think thats going to help. Just checking are
you using AMD server any chance .
Please provide complete config of your installation.
Hardware : what machine is it the process , RAM etc
Software : OS , PostgreSQL version
> Should I copy the data folder ? and then restore it with new
installation
> or what do you mean to say kindly brief it please. I will be thankful to
any
> help. thanks a lot.
Yes , shutdown PostgreSQL, copy the data folder and reinstall the server
and after initialisation restart the server. Before you attempt that make
sure you backup atleast the database folder.
Also during backup , post the log file to the community so they can look
at
it.
> On Fri, May 23, 2008 at 8:53 AM, Vishal Mailinglist
<list@[EMAIL PROTECTED]
>
> wrote:
>
>> 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@[EMAIL PROTECTED]
> 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
>
>
>
--
Regards,
Vishal Kashyap.
Need help visit
http://help.vishal.net.in
------=_Part_12830_21391185.1211578470998
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
Hi ,<br><br>
<blockquote class="gmail_quote" style="PADDING-LEFT: 1ex; MARGIN: 0px 0px
0px 0.8ex; BORDER-LEFT: #ccc 1px solid">I have tried to taken backup while
no one is connected. Should i change my RAM and then check it. Version are
same of pg_dump and database version 8.1.</blockquote>
<div> </div>
<div> </div>
<div>Yes try that . Though I dont think thats going to help. Just checking
are you using AMD server any chance .</div>
<div> </div>
<div>Please provide complete config of your installation.</div>
<div>Hardware : what machine is it the process , RAM etc</div>
<div>Software : OS , PostgreSQL version </div>
<div><br> </div>
<blockquote class="gmail_quote" style="PADDING-LEFT: 1ex; MARGIN: 0px 0px
0px 0.8ex; BORDER-LEFT: #ccc 1px solid">Should I copy the data folder ?
and then restore it with new installation or what do you mean to say
kindly brief it please. I will be thankful to any help. thanks a lot.
</blockquote>
<div> </div>
<div> </div>
<div>Yes , shutdown PostgreSQL, copy the data folder and reinstall
the server and after initialisation restart the server. Before you attempt
that make sure you backup atleast the database folder.</div>
<div> </div>
<div>Also during backup , post the log file to the community so they can
look at it.</div>
<div> </div>
<div> </div>
<div><br> </div>
<blockquote class="gmail_quote" style="PADDING-LEFT: 1ex; MARGIN: 0px 0px
0px 0.8ex; BORDER-LEFT: #ccc 1px solid">
<div><span class="e" id="q_11a1468d9c16fbf7_1">
<div class="gmail_quote">On Fri, May 23, 2008 at 8:53 AM, Vishal
Mailinglist <<a onclick="return top.js.OpenExtLink(window,event,this)"
href="mailto:list@[EMAIL PROTECTED]
"
target="_blank">list@[EMAIL PROTECTED]
>> wrote:<br>
<blockquote class="gmail_quote" style="PADDING-LEFT: 1ex; MARGIN: 0pt 0pt
0pt 0.8ex; BORDER-LEFT: rgb(204,204,204) 1px solid">
<div>Hi ,</div>
<div> </div>
<div>Make sure no one is connected to the database while doing the back
up. Usually memory alloc error comes if its a bad RAM .<br>check the
pg_dump version and your database version match (this could be a guess)
<br>try file level backup and restore into new database.<br>
<br> </div>
<div>
<div></div>
<div>
<div><span class="gmail_quote">On 22/05/2008, <b
class="gmail_sendername">Amit jain</b> <<a onclick="return
top.js.OpenExtLink(window,event,this)"
href="mailto:amitjain.bit@[EMAIL PROTECTED]
"
target="_blank">amitjain.bit@[EMAIL PROTECTED]
>> wrote:</span>
<blockquote class="gmail_quote" style="PADDING-LEFT: 1ex; MARGIN: 0px 0px
0px 0.8ex; BORDER-LEFT: rgb(204,204,204) 1px solid">Hello
All,<br><br>We are using postgresql version 8.1 and our database size is
7gb. Ram Size is 2 GB. <br>
<br>while trying to take backup through pg_dump i am getting following
error.<br>
<p style="MARGIN-BOTTOM: 0in"><a
name="11a1468d9c16fbf7_11a13cd5e9bbc3db_11a12c3a62f1240e_11a10e36e2d615cc_1fgb"></a>oka97:
pg_dump amtdb > amtdb.out<br>pg_dump: ERROR: invalid memory alloc
request size 4294967293<br>
pg_dump: SQL command to dump the contents of table "atbs2_logs"
failed: PQendcopy() failed.<br>pg_dump: Error message from server: ERROR:
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> "public.atbs2_logs" then again getting
following error.<br></b>
<p style="MARGIN-BOTTOM: 0in"></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></blockquote></div><br><br
clear="all"><br> </div></div><font color="#888888">--
<br>Regards,<br>Vishal Kashyap.<br>Need help visit<br><a onclick="return
top.js.OpenExtLink(window,event,this)" href="http://help.vishal.net.in/"
target="_blank">http://help.vishal.net.in</a>
</font></blockquote>
</div><br></span></div></blockquote><br><br clear="all"><br>--
<br>Regards,<br>Vishal Kashyap.<br>Need help visit<br><a
href="http://help.vishal.net.in">http://help.vishal.net.in</a>
------=_Part_12830_21391185.1211578470998--
|
