On Fri, 5 Oct 2001, Oleg Lebedev wrote:
> I decided to tighten up security on the server and start postmaster as
> postgres user on startup.
> I have a script my_script that is run on startup, which has root
> permissions. From this script I want to start postgres script, which is
> owned by postgres (postgerSQL superuser) and has 's' bit set so that it
> executes with postgres priviledges. When I try to run my_script, I get
> an error:
> postmaster: real and effective userids must match
> what am I doing wrong?
You should start postmaster with something like:
su - postgres -c 'postmaster' &
in your startup scripts. Setting the sticky bit will not accomplish what
you are trying to do.
-- Brett
http://www.chapelperilous.net/
------------------------------------------------------------------------
To thine own self be true. (If not that, at least make some money.)