Re: Cywin PGSQL Install - a quick question

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