Re: Postmaster startup

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(at)gmx(dot)net http://funkturm.homeip.net/~peter