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

From Chris Ruprecht
Subject Re: Permission Denied When i am Trying to take Backup
Date
Msg-id 002001c15185$2c41e220$5dd26383@corp.compucom.com
Whole thread Raw
In response to Re: buffer overflow (I'm getting it too!)  (Stephan Szabo <sszabo@megazone23.bigpanda.com>)
List pgsql-admin
you should make sure, that you have 'rwx' access to the directory you're
trying to send the output to. Make sure, all your postgres files under the
postgres home (~postgres) as well as all directories are actually owned by
postgres. If they are not, this small script can change that:

cd ~postgres
find . -depth -exec chown postgres:postgres {} ";"

Best regards,
Chris


----- Original Message -----
From: "Moovarkku Mudhalvan" <mudhalvan@vasunas.com>
To: "Stephan Szabo" <sszabo@megazone23.bigpanda.com>; "Nick Fankhauser"
<nickf@ontko.com>
Cc: "Laurette Cisneros" <laurette@nextbus.com>; <pgsql-admin@postgresql.org>
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
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 databasename >filename
>
>   Where other things are working fine. Only when i was trying to take the
> backup i am getting the problem. Please let me know some guidence
>
> Thanks
> Mudhalvan M.M
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
>     (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)


_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com


pgsql-admin by date:

Previous
From: "Moovarkku Mudhalvan"
Date:
Subject: Permission Denied When i am Trying to take Backup
Next
From: "postgresql"
Date:
Subject: Re: Database access error after upgrade 7.1.2 -> 7.1.3