Re: pg_dump throws no buffer space available error

Поиск
Список
Период
Сортировка
От Vishal Dixit
Тема Re: pg_dump throws no buffer space available error
Дата
Msg-id 200601191939.OAA19478@www23.ureach.com
обсуждение исходный текст
Ответ на pg_dump throws no buffer space available error  (Vishal Dixit <vishal_d@ureach.com>)
Ответы Re: pg_dump throws no buffer space available error  (Bruce Momjian <pgman@candle.pha.pa.us>)
Re: pg_dump throws no buffer space available error  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
I modified pg_dump.c and aded a sleep of 1000 micro sec in the
loop for copying data and it fixed the problem. It looks like
for slower machines when it comes to reading larger tables,
pg_dump finds no data to read in new lines and assumes EOL while
there is still data to be dumped, as a result PQendcopy() throws
error. THROTTLE comments in pg_dump were helpful. Any thoughts.

Thanks.

________________________________________________
Get your own "800" number
Voicemail, fax, email, and a lot more
http://www.ureach.com/reg/tag

В списке pgsql-general по дате отправления:

Предыдущее
От: Dan Sugalski
Дата:
Сообщение: Re: Question about Hardware & Configuration for Massive
Следующее
От: Marc Munro
Дата:
Сообщение: Re: Privilege for seeing queries using