Re: postgres on Win2K

Kian,

On Thu, Apr 26, 2001 at 02:34:16PM -0700, Kian Parsee wrote:
> I was looking through the user groups, and it seems
> like you're an Postgres expert...

I'm certainly no PostgreSQL expert...

> So you might be able to help me...

Nevertheless, I will try but *please* post to pgsql-cygwin@postgresql.org
instead of sending private email to so others can benefit too.

> I just recently downloaded Cygwin 1.3.1, the latest
> version of cygipc, and Postgres 7.1.  I built
> postgres, with no errors...

There was no need to build Cygwin PostgreSQL since it is one of the
contrib packages now.  Actually, please try the pre-built version since I
built it with a 1.1.8-like (1.1.8 with only cygwin1.dll replaced) Cygwin.
Maybe building PostgreSQL against 1.3.1 causes your problem.

> I start the ipc-daemon from inside of cygwin, and then
> I start the postmaster with the command posmaster -i&.
>
> When I try to do a createdb, I get this error:
>
> pq_flush: send() failed: Invalid argument
> pq_recvbuf: recv() failed: The descriptor is a file, not a socket
                                                       ^^^^^^^^^^^^

The above certainly looks suspicious.

> psql: pqReadData() -- backend closed the channel
> unexpectedly.
>         This probably means the backend terminated
> abnormally
>         before or while processing the request.
> createdb: database creation failed
>
> Do you have any idea what is causing this?

Sorry, but I cannot reproduce the above problem on my Windows 2000 SP1 or
Windows NT 4.0 SP6a machines with the following setup:

    Cygwin 1.3.1
    PostgreSQL 7.1 (from Cygwin contrib)
    cygipc 1.09-2

Another suggestion is to try connecting via TCP instead of UNIX domain
sockets:

    $ createdb -h localhost foo

Does this work?  Or, does it fail the same way?

Maybe someone else on the list has some other ideas?

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