Hiya,
Sorry for my ignorance and perhaps stupid question - my setup own is far
from ideal either.
But why do you want to *run* pg from normal user accounts? Why not have pg
running under it's own account, as a service?
Anyone who can start/stop services can start/stop the database then, and you
don't have to tweak permissions to give access to database-private files to
all users.
And if you're the only user and don't want to create a service, just do
initdb as from your normal user account and start it manually from the
console... That's what I do.
I just wish that su would work on windoze, then it would be much easier to
start pg manually under the same account always...
regards,
--Tim
-----Original Message-----
From: pgsql-cygwin-owner@postgresql.org
[mailto:pgsql-cygwin-owner@postgresql.org]On Behalf Of Daniel Convissor
Sent: donderdag 27 november 2003 9:41
To: pgsql-cygwin@postgresql.org
Subject: Re: [CYGWIN] FAQ_MSWIN patch: clarify instructions
Hi Folks:
On Thu, Nov 27, 2003 at 01:13:34AM -0500, Daniel Convissor wrote:
> +7. If you want other users to be able to run PostgreSQL, it is
> + necessary to ease the permissions on some files. Adjust the
> + permissions and paths to suit your requirements.
> +
> + chmod 755 /usr/bin/pg_* /usr/bin/postgr*
> + chmod 666 /usr/local/pgsql/data/global/pg_pwd
> + chmod 666 /usr/local/pgsql/data/global/pg_fsm.cache
Strike those last two lines. I just did a fresh initdb and there's a lot
more to it than just them.
I did something last time that made it readable by my user account*, but
didn't think to document it. I'll need to experiment and get back to
y'all on this... Or, perhaps someone here already knows the routine and
can post it.
* In Windows I have separate administrator and user accounts. So, I
installed Cygwin and did initdb under the admin account, but want to be
able to access things under my user account. By the way, I'm just using
pg to do some testing, so I'm not really worried about security on pg at
this point.
Thanks,
--Dan
--
FREE scripts that make web and database programming easier
http://www.analysisandsolutions.com/software/
T H E A N A L Y S I S A N D S O L U T I O N S C O M P A N Y
4015 7th Ave #4AJ, Brooklyn NY v: 718-854-0335 f: 718-854-0409
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html
