Обсуждение: Starting Postgres : user from same group

Поиск
Список
Период
Сортировка

Starting Postgres : user from same group

От
Abhishek Sharma G
Дата:
 
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
 
 

Re: Starting Postgres : user from same group

От
Albe Laurenz
Дата:
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