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

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