On Sat, Jul 10, 2004 at 10:48:59AM +0200, zuhans@iname.com wrote:
> when postgresql should be running in production-systems running the
> database as root would be suicide (maybe running on most
> windows-envirionments too...). so this should be prevented.
>
> but: if i do "just" programming and i want to run postgresql besides my
> ide to create/test my wonderful programming ideas there should be just
> the ability to run postgresql with any user - even with root. otherwise
> i must login to my computer as special postgresql-user to run postgresql
> but maybe don't have all rights to work with my ide and other
> programming-tools.
Err? Ok, I'm not too familiar with windows but surely it's possible to
run a server as another user. For me (on Linux mind you) all such
servers are started on bootup and several of them have their own user
accounts.
Unless you are considering running postgresql from your development
environment. Surely you run the server as it's own user. The user
programs and command interface can run as any user.
Just run it as a service (i think that's the right term), you're the
admin, right?
Hope this helps,
--
Martijn van Oosterhout <kleptog@svana.org> http://svana.org/kleptog/
> Patent. n. Genius is 5% inspiration and 95% perspiration. A patent is a
> tool for doing 5% of the work and then sitting around waiting for someone
> else to do the other 95% so you can sue them.
