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:mudhalvan@vasunas.com]
> Sent: Wednesday, October 10, 2001 7:01 AM
> To: Stephan Szabo; Nick Fankhauser
> Cc: Laurette Cisneros; pgsql-admin@postgresql.org
> 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
>
