Re: initdb fails

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