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" <[EMAIL PROTECTED]> To: "Stephan Szabo" <[EMAIL PROTECTED]>; "Nick Fankhauser" <[EMAIL PROTECTED]> 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 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 [EMAIL PROTECTED]) _________________________________________________________ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly