Re: [ADMIN] postgresql-6.3.2 question - Mailing list pgsql-admin

From Peter Mount
Subject Re: [ADMIN] postgresql-6.3.2 question
Date
Msg-id Pine.LNX.3.95.980517232438.12980A-100000@retep.org.uk
Whole thread Raw
In response to Re: [ADMIN] postgresql-6.3.2 question  ("Brett W. McCoy" <bmccoy@lan2wan.com>)
Responses Re: [ADMIN] postgresql-6.3.2 question  ("Brett W. McCoy" <bmccoy@lan2wan.com>)
List pgsql-admin
On Sun, 17 May 1998, Brett W. McCoy wrote:

> On Sun, 17 May 1998, Peter Mount wrote:
>
> > I've installed it both ways:
> >
> >  * As root, when installing under /usr/local
> >  * As postgres, when installing under /home/postgres
> >
> > The only thing I have yet to find how to setup without root, is starting
> > the postmaster when the system boots.
>
> For that, you do need to be root, since the startup scripts only have
> permissions for root access, unless you want to compromise the security of
> your system.

Exactly

> However, you DO want the postmaster to be started by user postgres
> within the startup scripts.

Postgres will not run as root - it kills itself on purpose if you try.

--
Peter T Mount peter@retep.org.uk or petermount@earthling.net
Main Homepage: http://www.retep.org.uk
************ Someday I may rebuild this signature completely ;-) ************
Work Homepage: http://www.maidstone.gov.uk Work EMail: peter@maidstone.gov.uk


pgsql-admin by date:

Previous
From: "Brett W. McCoy"
Date:
Subject: Re: [ADMIN] postgresql-6.3.2 question
Next
From: "Brett W. McCoy"
Date:
Subject: Re: [ADMIN] postgresql-6.3.2 question