Perhaps postgres doesn't have rights to create <filename> in the current directory?
To test this, try to use the same procedure & at step 3, do: touch <filename> 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 option on the version I'm running.) > -----Original Message----- > From: Moovarkku Mudhalvan [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, October 10, 2001 7:01 AM > To: Stephan Szabo; Nick Fankhauser > Cc: Laurette Cisneros; [EMAIL PROTECTED] > Subject: 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])
