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.
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. On Fri, May 23, 2008 at 8:53 AM, Vishal Mailinglist <[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 <[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
