Skip site navigation (1) Skip section navigation (2)

Re: Postgres Cygwin Install-as-Service on XP Pro/Home Mini

From: Jason Tishler <jason(at)tishler(dot)net>
To: Kevin Wong <kevin-wong(at)usa(dot)net>
Cc: pgsql-cygwin <pgsql-cygwin(at)postgresql(dot)org>
Subject: Re: Postgres Cygwin Install-as-Service on XP Pro/Home Mini
Date: 2002-11-13 18:38:59
Message-ID: 20021113183859.GA1584@tishler.net (view raw or flat)
Thread:
Lists: pgsql-cygwin
Kevin,

On Wed, Nov 13, 2002 at 10:41:06AM -0700, Kevin Wong wrote:
>     Why is a "postgres" user different than a "Cygwin installer user"
>     in this context?
> 
> The best theory I can come up with is file/directory ownership.  That
> is, an XP user simply created and named as "postgres" user won't have
> ownership of the postgres files/directories.  Therefore, it will have
> countless problems when trying to execute.  Nor does SYSTEM work, even
> though it should theoretically have root-like access to the
> filesystem.
> 
> I've even attemped recursive "chown"'s of the various directories to
> the postgres user.  Perhaps I simply missed a few files/directories,
> and therefore postgres couldn't read or write to something it needed
> to.  I don't know.
> 
> [snip]
>
>     I would really like to determine whether or not a "postgres" user
>     can be used.  If not, then we will go with your "Cygwin installer
>     user" suggestion.
> 
> Gotcha.  Again, I'll give it another shot.  Of course, if the
> "postgres" user IS the "Cygwin installer user" then there'd definitely
> be no problem.  Though, I find it highly unlikely that this would be
> the case in most instances.

My suggestion is to login as "postgres" and then run initdb.  By
"login", I mean at the Windows login dialog or use ssh to simulate su.
Hopefully, running initdb as "postgres" will solve your permissions
problem.

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

In response to

pgsql-cygwin by date

Next:From: Sexton, JoeDate: 2002-11-13 18:42:35
Subject: Cannot Create Template 1
Previous:From: Kevin WongDate: 2002-11-13 17:41:06
Subject: Re: Postgres Cygwin Install-as-Service on XP Pro/Home Mini

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group