Mailing-List: contact cygwin-developers-help AT sourceware DOT cygnus DOT com; run by ezmlm
List-Subscribe: <mailto:cygwin-developers-subscribe AT sources DOT redhat DOT com>
List-Archive: <http://sources.redhat.com/ml/cygwin-developers/>
List-Post: <mailto:cygwin-developers AT sources DOT redhat DOT com>
List-Help: <mailto:cygwin-developers-help AT sources DOT redhat DOT com>, <http://sources.redhat.com/ml/#faqs>
Sender: cygwin-developers-owner AT sources DOT redhat DOT com
Delivered-To: mailing list cygwin-developers AT sources DOT redhat DOT com
Date: Wed, 18 Apr 2001 16:45:18 -0400
From: Jason Tishler <Jason DOT Tishler AT dothill DOT com>
To: Cygwin-Developers <cygwin-developers AT sources DOT redhat DOT com>
Cc: Pgsql-Cygwin <pgsql-cygwin AT postgresql DOT org>
Subject: UNIX domain socket change breaks PostgreSQL (was Re: [CYGWIN] initdb fails)
Message-ID: <20010418164518.B394@dothill.com>
Mail-Followup-To: Cygwin-Developers <cygwin-developers AT sources DOT redhat DOT com>,
	Pgsql-Cygwin <pgsql-cygwin AT postgresql DOT org>
Mime-Version: 1.0
Content-Type: multipart/mixed; boundary="o2LEshSdj0VoSjN3"
Content-Disposition: inline
User-Agent: Mutt/1.2.5i
Organization: Dot Hill Systems Corp.


--o2LEshSdj0VoSjN3
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline

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 DOT Tishler AT dothill DOT com
Hazlet, NJ 07730 USA                 WWW:   http://www.dothill.com

--o2LEshSdj0VoSjN3
Content-Type: message/rfc822
Content-Disposition: inline

Received: from dothill.com (artecon [206.6.181.5])
	by ny.dothill.com (8.9.3/8.9.3) with ESMTP id QAA09426
	for <jt AT ny DOT dothill DOT com>; Wed, 18 Apr 2001 16:17:10 -0400
Received: from postgresql.org (webmail.postgresql.org [216.126.85.28])
	by dothill.com (8.9.1b+Sun/8.9.1) with ESMTP id MAA20832
	for <Jason DOT Tishler AT dothill DOT com>; Wed, 18 Apr 2001 12:52:20 -0700 (PDT)
Received: from postgresql.org.org (webmail.postgresql.org [216.126.85.28])
	by postgresql.org (8.11.3/8.11.1) with SMTP id f3IK8gu72500;
	Wed, 18 Apr 2001 16:08:42 -0400 (EDT)
	(envelope-from pgsql-cygwin-owner+M11 AT postgresql DOT org)
Received: from ny.dothill.com (ny.dothill.com [155.254.1.24])
	by postgresql.org (8.11.3/8.11.1) with ESMTP id f3IJdDu64419
	for <pgsql-cygwin AT postgresql DOT org>; Wed, 18 Apr 2001 15:39:13 -0400 (EDT)
	(envelope-from Jason DOT Tishler AT dothill DOT com)
Received: from kosh.boxhill.com (kosh.boxhill.com [216.116.135.139])
	by ny.dothill.com (8.9.3/8.9.3) with SMTP id PAA08907;
	Wed, 18 Apr 2001 15:46:15 -0400
Received: by kosh.boxhill.com (sSMTP sendmail emulation); Wed, 18 Apr 2001 15:38:39 -0400
Date: Wed, 18 Apr 2001 15:38:38 -0400
From: Jason Tishler <Jason DOT Tishler AT dothill DOT com>
To: schopen AT dimdi DOT de
Cc: pgsql-cygwin AT postgresql DOT org
Subject: Re: [CYGWIN] initdb fails
Message-ID: <20010418153838 DOT A394 AT dothill DOT com>
Mail-Followup-To: schopen AT dimdi DOT de, pgsql-cygwin AT postgresql DOT org
References: <3ADDD957 DOT 29160 DOT 54EFE99 AT localhost> <20010418133004 DOT F536 AT dothill DOT com>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
User-Agent: Mutt/1.2.5i
In-Reply-To: <20010418133004 DOT F536 AT dothill DOT com>; from Jason DOT Tishler AT dothill DOT com on Wed, Apr 18, 2001 at 01:30:04PM -0400
Organization: Dot Hill Systems Corp.
Precedence: bulk
Sender: pgsql-cygwin-owner AT postgresql DOT org

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 AT dimdi DOT 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 DOT Tishler AT dothill DOT 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


--o2LEshSdj0VoSjN3--