pg_dump error

Поиск
Список
Период
Сортировка
Искать
От
manjula hettiarachchi
Тема
pg_dump error
Дата
Msg-id
20060706122524.71421.qmail@web50302.mail.yahoo.com
Ответ на
Re: pgpool (Guido Barosio)
Список
Дерево обсуждения
Re: pgpool Christopher Browne <cbbrowne@acm.org>
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 
В списке pgsql-admin по дате отправления
От: Guido Barosio
Дата:
Сообщение: Re: pgpool
От: Dilipkumar
Дата:
Сообщение: Re: pg_dump error
FAQ