From: | manjula hettiarachchi <manjula_55(at)yahoo(dot)com> |
---|---|
To: | "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>, postgresql-l <postgresql-l(at)groups(dot)ittoolbox(dot)com> |
Subject: | pg_dump error |
Date: | 2006-07-06 12:25:24 |
Message-ID: | 20060706122524.71421.qmail@web50302.mail.yahoo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin pgsql-advocacy |
Hello List
I am using postgresql 7.4.7 in a voip production
setup.
I have been using pg_dump -Fc for regular backing up.
Since yesterday i am getting the following error for
the command:
root# pg_dump -h 'localhost' voipdb -t voipcall -Fc -f
voipcall.bak
The error is :
pg_dump: ERROR: invalid memory alloc request size
4294967293
pg_dump: SQL command to dump the contents of table
"voipcall" failed: PQendcopy() failed.
pg_dump: Error message from server: ERROR: invalid
memory alloc request size 4294967293
pg_dump: The command was: COPY public.voipcall (id,
accountid, .........., prefix) TO stdout;
However when i tried to Vacuum analyze the same table
its fine and no errors. Also the SQL access to the
same table runs fine without any errors.
Only the pg_dump is failing for this particular table.
Can anyone suggest a method to fix this?
Thanks in advance
Manjula
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
From | Date | Subject | |
---|---|---|---|
Next Message | Dilipkumar | 2006-07-06 12:29:11 | Re: pg_dump error |
Previous Message | Guido Barosio | 2006-07-06 12:13:51 | Re: pgpool |
From | Date | Subject | |
---|---|---|---|
Next Message | Dilipkumar | 2006-07-06 12:29:11 | Re: pg_dump error |
Previous Message | Guido Barosio | 2006-07-06 12:13:51 | Re: pgpool |