Re: No buffer space available

Nik wrote:
> have an SQL file with a set of about 3000 insert statements. This
> file is executed twice from a remote client machine running Windows
> XP. The first time it is executed against a Windows 2003 Server
> running PostgreSQL 8.0. The second time it is executed against a
> Windows 2003 Server running PostgreSQL 8.2. This setup has been in
> place for about a year now and never had any issues.
>
> However, I noticed today that all the file executions fail with
> [nativecode=could not send data to server: No buffer space available
> (0x00002747/10055)] error.
>
> I attempted to run the same file using pgAdmin III version 1.6.2, but
> every time the file is executed the only return in messages pane is
> the colon sign ":". No data is inserted.
>
> I attempted to run the same file using psql.exe and this worked
> without any problems.
>
> I also noticed that if I use less inserts, for example only a few
> hundred, the file executes fine.
>
> What could be the issue?
>
>   


First, this is the wrong place to ask this question. pgsql-hackers is 
about development of postgres itself, not about usage questions. Perhaps 
you should ask on pgsql-general.

Second, if you can run the file using psql, then it does not appear to 
be a problem with postgres at all, but rather with the client you are 
using (you don't say what that client is). Perhaps your client is trying 
a naive method of batching inserts and thus running out of buffer space 
- it's hard to tell since you haven't given much information.

In the case of pgAdminIII, you might need to ask on its lists.

cheers

andrew