pg_dump error

Поиск
Список
Период
Сортировка
От manjula hettiarachchi
Тема pg_dump error
Дата
Msg-id 20060706122524.71421.qmail@web50302.mail.yahoo.com
обсуждение исходный текст
Ответ на Re: pgpool  ("Guido Barosio" <gbarosio@gmail.com>)
Ответы Re: pg_dump error  (Dilipkumar <dilipkumar_parikh@sifycorp.com>)
Список pgsql-admin
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