Oleg Lebedev writes:
> 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
You should start the postmaster like this:
su -c 'postmaster -D ...' postgres
Setuid is not allowed because it introduces a security hole (on some
platforms anyway), coming from user-defined C functions.
--
Peter Eisentraut peter_e@gmx.net http://funkturm.homeip.net/~peter