Re: Initdb fails... Again! - Mailing list pgsql-cygwin

From Jason Tishler
Subject Re: Initdb fails... Again!
Date
Msg-id 20030127202126.GD2124@tishler.net
Whole thread Raw
In response to Re: Initdb fails... Again!  ("Markko Paas" <Markko@softronic.ee>)
Responses Re: Initdb fails... Again!  (Dan Holmsand <dan@eyebee.com>)
List pgsql-cygwin
Dan,

On Fri, Jan 24, 2003 at 07:22:48PM +0100, Dan Holmsand wrote:
> Jason Tishler wrote:
> >BTW, by "sysv start script" do you mean using the sysvinit package.
> >If so, then how did you get around the following issues:
> >
> >    http://www.cygwin.com/ml/cygwin/2002-11/msg00669.html
> >    http://www.cygwin.com/ml/cygwin/2002-11/msg00677.html
> >    http://www.cygwin.com/ml/cygwin/2002-11/msg00838.html
>
> Yeah, sysvinit and initscripts. I've been hoping something like that
> would show up in cygwin for quite some time, so I've struggled a bit
> to make it work.
>
> [snip]
>
> But then I noticed that su actually *does* work if a privileged enough
> user with uid 0 (i.e. "root") runs it.  [snip]
>
> But now it works (almost) perfectly, running apache, cron, sshd,
> xinetd, ipc-daemon and postmaster. The only problem I've seen is that
> cron restarts itself as SYSTEM, even when started as root, for some
> reason.

Thanks for the above description.  However, creating another privileged
user, root, in addition to LocalSystem is unnecessary and dangerous.
Instead, I would use my patch to su (the first URL above) so su will run
under LocalSystem on Cygwin the same way it would under root on other
Unixes.  With this patched su, you can then run init under LocalSystem
as recommended.

Jason

--
PGP/GPG Key: http://www.tishler.net/jason/pubkey.asc or key servers
Fingerprint: 7A73 1405 7F2B E669 C19D  8784 1AFD E4CC ECF4 8EF6

pgsql-cygwin by date:

Previous
From: Andrew Klimov
Date:
Subject: error when running psql -PgSql7.3.1
Next
From: John Smith
Date:
Subject: Re: postmaster does not shutdown