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

From: Medi Montaseri <medi(dot)montaseri(at)intransa(dot)com>
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
Date: 2002-11-19 17:48:30
Message-ID: 3DDA796E.4080802@intransa.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

You can use su(1) from a script and setuid(2) from a C program to become
who ever
but not 'root' to launch postgres.

PG needs a database administrator. Most people use postgres. But you can
use anything
you want.

Dorward Villaruz wrote:

>is it possible to start postgres from another user, we only know the
>postgres account password and our shell account to use.
>we have an application that needs to restart postgres if it crashes. ü
>
>
>---------------------------(end of broadcast)---------------------------
>TIP 3: if posting/reading through Usenet, please send an appropriate
>subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
>message can get through to the mailing list cleanly
>
>

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Brandon Craig Rhodes 2002-11-19 18:09:06 improving a badly optimized query
Previous Message Damjan Pipan 2002-11-19 17:41:43 Re: plpgsql - accessing field in RECORD variable by text variables