Re: help in starting up / shutting down postgres as another user

From: "Jan Weerts" <j(dot)weerts(at)i-views(dot)de>
To: "'Dorward Villaruz'" <dorwardv(at)ntsp(dot)nec(dot)co(dot)jp>
Cc: "'Postgres General'" <pgsql-general(at)postgresql(dot)org>
Subject: Re: help in starting up / shutting down postgres as another user
Date: 2002-11-22 16:25:35
Message-ID: B349BABAF9A92F4D9FBFCADF8D5FEDD5059FCA@ivsrv03.i-views.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message scott.marlowe 2002-11-22 16:31:33 Re: Lack of use of indexes
Previous Message Don Isgitt 2002-11-22 16:11:38 Lack of use of indexes