Re: FAQ_MSWIN patch: clarify instructions
От | Leeuw van der, Tim |
---|---|
Тема | Re: FAQ_MSWIN patch: clarify instructions |
Дата | |
Msg-id | DD0DC14935B1D211981A00105A1B28DB0A7B4C8D@NL-ASD-EXCH-1 обсуждение исходный текст |
Ответ на | FAQ_MSWIN patch: clarify instructions (Daniel Convissor <danielc@analysisandsolutions.com>) |
Ответы |
Re: FAQ_MSWIN patch: clarify instructions
(Daniel Convissor <danielc@analysisandsolutions.com>)
Re: FAQ_MSWIN patch: clarify instructions (Jason Tishler <jason@tishler.net>) |
Список | pgsql-cygwin |
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
В списке pgsql-cygwin по дате отправления: