Re: pg_dump throws no buffer space available error

From: Vishal Dixit <vishal_d(at)ureach(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: pg_dump throws no buffer space available error
Date: 2006-01-19 19:39:14
Message-ID: 200601191939.OAA19478@www23.ureach.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Marc Munro 2006-01-19 19:44:42 Re: Privilege for seeing queries using
Previous Message Dan Sugalski 2006-01-19 19:26:03 Re: Question about Hardware & Configuration for Massive