Re: Permission Denied When i am Trying to take Backup - Mailing list pgsql-admin

From Stefan Huber
Subject Re: Permission Denied When i am Trying to take Backup
Date
Msg-id 5.1.0.14.0.20011012135053.024f2c10@pop.gmx.net
Whole thread Raw
In response to Re: Permission Denied When i am Trying to take Backup  (Peter Eisentraut <peter_e@gmx.net>)
Responses Re: Permission Denied When i am Trying to take Backup  ("Brett W. McCoy" <bmccoy@chapelperilous.net>)
Re: Permission Denied When i am Trying to take Backup  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-admin
Hi!

> > I always do a chown -R postgres:daemon /usr/local/pgsql (or
> > postgres:postgres) after installation.
>
>Which is a bad idea.
>
>The installation instructions were developed with some thought behind
>them.

Well, this might be true, if you are on a system, where more than one
humans are operating. Or are there some other reasons behind this philosophy?
I mean, a buffer overflow (I don't claim to know of any in Postgres) can
cause more problems when running as root than as user.

Can anyone explain these thoughts behind the instructions? Or pinpoint me
to the explanations in the docs.

Stefan

--
Murphy's Airport Axiom:
Your flight never leaves from gate #1.


pgsql-admin by date:

Previous
From: "postgresql"
Date:
Subject: Re: Permission Denied When i am Trying to take Backup
Next
From: Robert.Farrugia@go.com.mt
Date:
Subject: Invalid date in database