Nick,
Please post instead of sending private email.
On Sat, Nov 23, 2002 at 04:39:37PM -0000, Nick Cresswell wrote:
> Thanks for all the informative stuff you've provided re: Cygwin and
> PGSQL. Very good stuff.
You are welcome.
> Having installed it, I do have one question. I'm trying to set up
> Postmaster as an NT service and I can't see how I can log into my
> Cygwin session as anything other than the current NT user (that
> happens to be administrator).
Is your /etc/passwd and /etc/group set up correctly?
> I went through your set up instructions logged in as Administrator and
> the problem I have is that the NT Postmaster service won't start due
> to a permissioning error, I think. Probably due to Administrator being
> the owner of the usr/share/postgresql/data folder.
See below...
> Anyway, I created the postgres user ok. Does the mkpasswd command
> synchronise NT and Cywin user profiles?
Not quite -- it synchronizes the NT SAM with Cygwin's /etc/passwd.
> Now I just need to log into Cygwin as postgres. I tried the login
> command and I've looked at SSH but I think I'm a bit off course.
You can always logon as postgres via the normal NT logon mechanism and
run bash. I just find that too time consuming and "su" (i.e., switch
user) via ssh since I always have ssh setup anyway.
BTW, Cygwin login only works under very special circumstance, so I
recommend ignoring this command. Search the Cygwin archives for more
details, if interested.
Please read the README:
http://www.tishler.net/jason/software/postgresql/postgresql-7.2.3.README
Specifically, remember to run initdb under the postgres account.
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