Is it a big deal to change the user the DB runs under?

Поиск
Список
Период
Сортировка
От Tony Caduto
Тема Is it a big deal to change the user the DB runs under?
Дата
Msg-id 4484763C.3050504@amsoftwaredesign.com
обсуждение исходный текст
Ответы Re: Is it a big deal to change the user the DB runs  (Bill Moran <wmoran@collaborativefusion.com>)
Re: Is it a big deal to change the user the DB runs under?  ("Alex Turner" <armtuk@gmail.com>)
Список pgsql-general
Just wondering if anyone has done this:
Change the user the DB runs under from postgres to apache on a
established server?
I would think I would just change ownership on all the data dir files
and modify the startup script in /etc/init.d/postgresql.

Reason is I need a plperlu procedure to generate a dir listing for a
Kylix CGI web app and the directories in question are limited to the
user and group apache,
hence my plperlu proc can't list the contents.  I also can't set the
other permissions because I don't want any other users peaking around.

Or is there a way to have the plperlu procs to run as a different user?
I have been looking though the plperl docs but have not seen anything
like that.

Thanks,

--
Tony


В списке pgsql-general по дате отправления:

Предыдущее
От: Greg Stark
Дата:
Сообщение: Re: COLLATE
Следующее
От: Bill Moran
Дата:
Сообщение: Re: Is it a big deal to change the user the DB runs