Re: Permission Denied When i am Trying to take Backup

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