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
