Re: Permission Denied When i am Trying to take Backup

From: Stefan Huber <looseleaf(at)gmx(dot)net>
To: Peter Eisentraut <peter_e(at)gmx(dot)net>
Cc: <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Permission Denied When i am Trying to take Backup
Date: 2001-10-12 11:56:14
Message-ID: 5.1.0.14.0.20011012135053.024f2c10@pop.gmx.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message postgresql 2001-10-12 12:33:44 Re: Permission Denied When i am Trying to take Backup
Previous Message Robert.Farrugia 2001-10-12 08:59:30 Invalid date in database