Re: Permission Denied When i am Trying to take Backup

Hi!

>    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"
>     1. Login as root
>     2. su -l postgres
>     3. pg_dump databasename >filename


Who gives you the "Permission denied"? The shell? The postmaster? What is
the exact error message?

I guess, you dno't have permission to create a file as user postgres in the
directory you are working in.

If you followed the installatino guide step by step, the postgres
files/directories are owned by root, not by postgres. I always do a chown
-R postgres:daemon /usr/local/pgsql (or postgres:postgres) after installation.

Stefan

--
Cameron's Law:
An honest politician is one who, when he is bought, will stay bought.