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(at)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(dot)Tishler(at)dothill(dot)com
Hazlet, NJ 07730 USA WWW: http://www.dothill.com