Hi Gurus,
Greetings. I am using Postgresql in Red hat linux 71. When i was trying
to take the backup it is giving the error "Permission Denied"
Did any one faced the Same problem.
I will tell u what are the things which i did
1. Login as root
2. su -l postgres
3. pg_dump
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.
Th
On Fri, 12 Oct 2001, postgresql wrote:
> Could someone create a post that shows who(user) should own
> what. I have always let postgres own the pgsql directory and I see
> that it is recomended that root own it.
Whenver I have installed postgres (as the postgres user), it has always
installed ev
PROTECTED]>
Date: Thu, 11 Oct 2001 22:03:28 +0200 (CEST)
Subject: Re: [ADMIN] Permission Denied When i am Trying to take
Backup
> Stefan Huber writes:
>
> > If you followed the installatino guide step by step, the postgres
> > files/directories are owned by root, not by postg
On Friday, October 12, 2001, at 10:33 PM, postgresql wrote:
>
> Could someone create a post that shows who(user) should own
> what. I have always let postgres own the pgsql directory and I see
> that it is recomended that root own it.
>
The PostgreSQL processes should be run as an unprivilidged
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
ECTED]>
Cc: "Laurette Cisneros" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Wednesday, October 10, 2001 7:00 AM
Subject: [ADMIN] Permission Denied When i am Trying to take Backup
> Hi Gurus,
>
> Greetings. I am using Postgresql in Red hat linux 71. When i was
Hi!
>Greetings. I am using Postgresql in Red hat linux 71. When i was trying
>to take the backup it is giving the error "Permission Denied"
> 1. Login as root
> 2. su -l postgres
> 3. pg_dump databasename >filename
Who gives you the "Permission denied"? The shell? The postmaster
Perhaps postgres doesn't have rights to create in the current
directory?
To test this, try to use the same procedure & at step 3, do: touch
instead of starting dump. If it fails, you have the answer.
What does the "-l" option on su do? (I'm unfamiliar with it & apparently
don't have such an op
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 ru
10 matches
Mail list logo