Re: help! run postgresql in cygwin

David,

On Thu, Apr 19, 2001 at 10:02:36AM +0800, David Lee wrote:
> Thanks very much for providing the cygwin port of postgresql.  I think
> it's a very useful tool for me.

Your welcome -- I'm glad that you (will) find it useful.

> psql: pqReadData() -- backend closed the channel unexpectedly.
>         This probably means the backedn terminated abnormally
>         before or while processing the request.
> pq_flush: send() failed: The connection was aborted
> pq_recvbuf: recv() failed: error ESHUTDOWN triggered
>
> I don't know why it doesn't work? Could you tell me? or give me some
> advice on what should I do next.

The above is a known problem, please see the mailing thread that begins
with:

    http://www.cygwin.com/ml/cygwin-developers/2001-04/msg00092.html

Note that the problem has already been fixed in the current Cygwin CVS.

Currently, you have two options for a workaround:

1. Since the problem was introduced in the 2001-04-14 snapshot and as
you found out also exists in the 2001-04-16 one too, use the 2001-04-13
snapshot instead.

2. Build cygwin1.dll yourself from the current Cygwin CVS.

In the future please post to pgsql-cygwin@postgresql.org instead of
sending private email, so others can benefit too.

Thanks,
Jason

--
Jason Tishler
Director, Software Engineering       Phone: +1 (732) 264-8770 x235
Dot Hill Systems Corp.               Fax:   +1 (732) 264-8798
82 Bethany Road, Suite 7             Email: Jason.Tishler@dothill.com
Hazlet, NJ 07730 USA                 WWW:   http://www.dothill.com