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

From Peter Eisentraut
Subject Re: Permission Denied When i am Trying to take Backup
Date
Msg-id Pine.LNX.4.30.0110112115300.841-100000@peter.localdomain
Whole thread Raw
In response to Re: Permission Denied When i am Trying to take Backup  (Stefan Huber <looseleaf@gmx.net>)
Responses Re: Permission Denied When i am Trying to take Backup
Re: Permission Denied When i am Trying to take Backup
List pgsql-admin
Stefan Huber writes:

> If you followed the installatino guide step by step, the postgres
> files/directories are owned by root, not by postgres.

Which is a good idea.

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

--
Peter Eisentraut   peter_e@gmx.net   http://funkturm.homeip.net/~peter


pgsql-admin by date:

Previous
From: Tom Lane
Date:
Subject: Re: Alter column / array
Next
From: Tom Lane
Date:
Subject: Re: Alter column / array