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

From: Tony Caduto <tony_caduto(at)amsoftwaredesign(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Is it a big deal to change the user the DB runs under?
Date: 2006-06-05 18:21:48
Message-ID: 4484763C.3050504@amsoftwaredesign.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Bill Moran 2006-06-05 18:26:04 Re: Is it a big deal to change the user the DB runs
Previous Message Roman Neuhauser 2006-06-05 17:14:58 Re: What is the point of create or replace view command