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.


---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org

Reply via email to