Re: Permission Denied When i am Trying to take Backup

From: "Brett W(dot) McCoy" <bmccoy(at)chapelperilous(dot)net>
To: Stefan Huber <looseleaf(at)gmx(dot)net>
Cc: Peter Eisentraut <peter_e(at)gmx(dot)net>, <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Permission Denied When i am Trying to take Backup
Date: 2001-10-12 20:29:46
Message-ID: Pine.LNX.4.30.0110121628310.29380-100000@chapelperilous.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On Fri, 12 Oct 2001, Stefan Huber wrote:

> 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.

You should never run Postgres as root, regardless of whether or not root
owns the executables. The server should still always be run as a
non-priveleged user.

-- Brett
http://www.chapelperilous.net/
------------------------------------------------------------------------
La-dee-dee, la-dee-dah.

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Brian McCane 2001-10-12 22:00:23 Re: delete/vacuum not freeing disk space
Previous Message Tom Lane 2001-10-12 19:50:36 Re: psql \l problem