Starting Postgres : user from same group
Hi,
As per the Postgres design, only the user who is owner of the Postgres's Cluster Directory ( which has permission 700 ) can own the Postgres daemon process.
But I have a requirement so that any other user belonging to the same group can also start the Postgres daemon. It might not be very difficult to change the code for this use case ( at least it seems to be ),
But could some one please suggest me whether this is advisable or I will be messing up with the design ( I am in particular worried about the shared memory ) .
Regards,
Abhishek
Abhishek Sharma G wrote:
As per the Postgres design, only the user who is owner of the Postgres's Cluster Directory ( which has
permission 700 ) can own the Postgres daemon process.
But I have a requirement so that any other user belonging to the same group can also start the
Postgres daemon. It might not be very difficult to change the code for this use case ( at least it
seems to be ),
But could some one please suggest me whether this is advisable or I will be messing up with the design
( I am in particular worried about the shared memory ) .
That's not really a question for the hackers list.
I'd say you set the SETUID bit on the postgres executable and make sure
that only the right people can execute it.
Yours,
Laurenz Albe
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers