Re: Need some help getting started

Dan,

On Sat, Oct 25, 2003 at 02:47:03PM -0700, Dan wrote:
> It doesn't say whether I should run it as "postgres"
> or my "Dan" account, but neither seems to work.
>
> 1) As "Dan", I get:
> cygrunsrv: Error starting a service: StartService:
> Win32 error 1069:
> The service did not start due to a logon failure.

Did you in grant "Dan" the "Log on as a service" right as indicated in
the README?

3. Grant the "postgres" user the "Log on as a service" user right:

# cmd /c secpol.msc # [3] [4] [5] [12]

[snip]

[12] On Windows XP Home, there is no built in way to assign user
rights -- use editrights instead:

$ editrights -u postgres -a SeServiceLogonRight

> [snip]
>
> 2) As "postgres", I get:
> cygrunsrv: Error starting a service:
> QueryServiceStatus: Win32 error 1062:
> The service has not been started.

Does the following from the README help?

4. Cygwin PostgreSQL can fail to start or not function properly if
certain files and directories have incorrect permissions. The
following usually solves these kinds of problems:

$ chmod a+rwx /tmp
$ chmod a+rx /usr/bin /usr/bin/*
$ chmod a+rw /var/log # could adversely affect other daemons

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