UNIX domain socket change breaks PostgreSQL (was Re: [CYGWIN] initdb fails)

[Jason Tishler <Jason dot Tishler at dothill dot com>]

Chris,

The following recent change:

    http://www.cygwin.com/ml/cygwin-cvs/2001-q2/msg00032.html

breaks UNIX domain socket access between PostgreSQL clients and servers.

See the attached for details.

I'm not very knowledgeable with sockets so I don't know if this is a
Cygwin or PostgreSQL problem.  Any suggestions would be greatly
appreciated.

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

---

• To: schopen at dimdi dot de
• Subject: Re: [CYGWIN] initdb fails
• From: Jason Tishler <Jason dot Tishler at dothill dot com>
• Date: Wed, 18 Apr 2001 15:38:38 -0400
• Cc: pgsql-cygwin at postgresql dot org
• Organization: Dot Hill Systems Corp.
• References: <3ADDD957.29160.54EFE99@localhost> <20010418133004.F536@dothill.com>

Michael,

On Wed, Apr 18, 2001 at 01:30:04PM -0400, Jason Tishler wrote:
> On Wed, Apr 18, 2001 at 06:13:43PM +0200, schopen@dimdi.de wrote:
> > bash-2.04$ bin/initdb
> > This database system will be initialized with username "schopen".
> > This user will own all the data files and must also own the server 
> > process.
> > 
> > Creating directory /usr/share/postgresql/data
> > [snip]
> > Initializing pg_shadow.
> > 
> > initdb failed.
> > Removing /usr/share/postgresql/data.
> > Removing temp file /tmp/initdb.194.
> > 
> > Any help? Thanks a lot.
> 
> I just tried the above with the following configuration:
> 
>     NT 4.0 SP6a
>     PostgreSQL 7.1-2
>     cygipc 1.09-2
>     Cygwin 1.1.8-2 (with cygwin1.dll replaced by cygwin1-20010416.dll.bz2)
> 
> and the initdb worked as expected.

The plot thickens or I spoke too soon.

Although initdb works, I am getting the following errors when I connect
to postmaster:

    # server side
    $ postmaster
    DEBUG:  database system was shut down at 2001-04-18 15:12:29 
    DEBUG:  CheckPoint record at (0, 1563376)
    DEBUG:  Redo record at (0, 1563376); Undo record at (0, 0); Shutdown TRUE
    DEBUG:  NextTransactionId: 619; NextOid: 18720
    DEBUG:  database system is in production state
    pq_flush: send() failed: The connection was aborted
    pq_recvbuf: recv() failed: errno ESHUTDOWN triggered

    # client side
    $ psql -l
    psql: pqReadData() -- backend closed the channel unexpectedly.
            This probably means the backend terminated abnormally
            before or while processing the request.

The Cygwin snapshot from 4/13/2001 works but the one from 4/14/2001
doesn't.  I'm trying to determine why.  I will report back when I get
more information.

If anyone wants to help, please jump in.

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

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://www.postgresql.org/search.mpl

---