Re: pg_dump fails on 7.4 Postgres

"Jimmie H. Apsey" <japsey@futuredental.com> writes:

> This may be my second posting but I think I've done it correctly this time.
> At this point, I am unable to do a pg_dump using our new Rec Hat
> Enterprise Linux AS 4 version of Postgres which is version 7.4.
> Here's what I get when I try to do a pg_dump of our database:
>
---------------------------------------------------------------------------------------------------------------------------
> [~]$
> [ ~]$ /usr/bin/pg_dump dcf_20050404 >& /~/dcf_20050404_`date +%y%m%d`.dmp
> audit(1115732852.025:0): avc:  denied  { write } for  pid=11023
> exe=/usr/bin/pg_dump path=/~/dcf_20050404_050510.dmp
> dev=sda3 ino=5522308 scontext=user_u:system_r:postgresql_t
> tcontext=user_u:object_r:file_t tclass=file

Looks like your security settings aren't allowing pg_dump to write
files.  You should probably talk to Red Hat about how to fix them.

-Doug