Re: help in starting up / shutting down postgres as another user - Mailing list pgsql-general

From Jan Weerts
Subject Re: help in starting up / shutting down postgres as another user
Date
Msg-id B349BABAF9A92F4D9FBFCADF8D5FEDD5059FCA@ivsrv03.i-views.de
Whole thread Raw
In response to help in starting up / shutting down postgres as another user  ("Dorward Villaruz" <dorwardv@ntsp.nec.co.jp>)
Responses Re: help in starting up / shutting down postgres as another
List pgsql-general

> we have an application that needs to restart postgres if it
>crashes.

This is not a solution, postgres should provide, as it is OS-related.
As Tom already stated, crashes are rare (we never had one in the last years) and if it crashed it obviously cannot control anything else :-)

If crashes are not the main problem, I'd recommend sudo (exists for many unix derivates) or equivalents. It can selectively grant the "other" user the right to execute a postgres startup script/executable as the postgres user, without the need to share passwords or grant more rights than necessary.

HTH
  Jan

pgsql-general by date:

Previous
From: Don Isgitt
Date:
Subject: Re: Lack of use of indexes
Next
From: "scott.marlowe"
Date:
Subject: Re: Lack of use of indexes