Re: PostgreSQL on Win/2K

Kian,

On Wed, Jul 11, 2001 at 08:12:27AM -0700, Kian Parsee wrote:
> localhost seems to be defined correctly.  psql-h
> 127.0.0.1 template1 gives me the same error:
>
> kparsee@BFTTDEMO /usr/local/pgsql/bin
> $ psql -h 127.0.0.1 template1
> pq_flush: send() failed: Invalid argument
> pq_recvbuf: recv() failed: The descriptor is a file,
> not a socket
> psql: pqReadData() -- backend closed the channel
> unexpectedly.
>         This probably means the backend terminated
> abnormally
>         before or while processing the request.

For some reason Cygwin's recv() is returning ENOTSOCK.  Try using strace
to glean more information:

    $ strace -o psql.log psql -h 127.0.0.1 template1

Is there anything interesting in psql.log?

BTW, which Windows 2000 service pack are you using?

Some other suggestions:

    1. Try another machine (I have never seen this problem on various NT
       4.0 and 2000 machines)
    2. Try a Cygwin DLL snapshot

Jason

--
Jason Tishler
Director, Software Engineering       Phone: 732.264.8770 x235
Dot Hill Systems Corp.               Fax:   732.264.8798
82 Bethany Road, Suite 7             Email: Jason.Tishler@dothill.com
Hazlet, NJ 07730 USA                 WWW:   http://www.dothill.com