Re: [ADMIN] postgresql-6.3.2 question

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(at)retep(dot)org(dot)uk or petermount(at)earthling(dot)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(at)maidstone(dot)gov(dot)uk