Re: Permission Denied When i am Trying to take Backup

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
>