pg_dump error

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

In response to

  • Re: pgpool at 2006-07-06 12:13:51 from Guido Barosio

Responses

Browse pgsql-admin by date

  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

Browse pgsql-advocacy by date

  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