When installing as service, do you install it with postgres account? Or do you let it run with SYSTEM account?
--Tim
-----Original Message-----
From: pgsql-cygwin-owner@postgresql.org
[mailto:pgsql-cygwin-owner@postgresql.org]On Behalf Of David P. Lurie
Sent: zondag 13 juni 2004 23:37
To: pgsql-cygwin@postgresql.org
Subject: Re: [CYGWIN] Updated Cygwin Package: postgresql-7.4.2-1
Jason -
> 3. 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
>
> In particular, note the third chmod above.
>
I tried all three, without any success.
There was another problem with postgresql configuration that I hadn't
mentioned. initdb failed when run as the user "postgres", but completed
successfully under my usual login.
These permission changes now allow initdb to run from the "postgres"
account. postmaster still successfully installs as a service, but fails to
run, whether installed to run under my usual login or "postgres" (after
initdb has been run under the appropriate account).
David
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to majordomo@postgresql.org)