Re: PostgreSQL 7.2 Initdb

> -----Original Message-----
> From: Jason Tishler [mailto:jason@tishler.net]
> Sent: 25 September 2001 14:21
> To: Dave Page
> Cc: 'pgsql-cygwin@postgresql.org'
> Subject: Re: [CYGWIN] PostgreSQL 7.2 Initdb
>
>
> Dave,
>
> On Tue, Sep 25, 2001 at 09:12:33AM +0100, Dave Page wrote:
> > > -----Original Message-----
> > > From: Jason Tishler [mailto:jason@tishler.net]
> > > 2. Are you using ntsec?
> >
> > Not to my knowledge. I can't find the keyword in the cygwin
> > environment string in Win2K, and I see no mention of it in the
> > cygcheck -s output.
>
> I have good news and bad news.  I cannot reproduce your
> problem with the 2001/9/24 snapshot.  My WAG is that you need
> to add ntsec to your CYGWIN environment variable.

Yup, that did it (after a brief struggle with the security that ended with
me waving a white flag and logging in as the local Administrator!).

Actually, I still can't connect with psql but that's another problem
(probably not Cygwin) - the postmaster is running at least.

> Unfortunately, I cannot explain why your setup works for
> 7.1.3 but not 7.2.

My guess is that someone added the mode check on $PGDATA to initdb as a
simple check to help secure databases - of course on 99.99999% on *nix
systems that will work just fine!

I get the feeling that this question may well become as common as the
current 'why does my initdb hang?'...

Thanks, Dave.