Re: pg_dump fails on 7.4 Postgres - Mailing list pgsql-general

From Douglas McNaught
Subject Re: pg_dump fails on 7.4 Postgres
Date
Msg-id m2br7jaybt.fsf@Douglas-McNaughts-Powerbook.local
Whole thread Raw
In response to pg_dump fails on 7.4 Postgres  ("Jimmie H. Apsey" <japsey@futuredental.com>)
List pgsql-general
"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

pgsql-general by date:

Previous
From: "Jim C. Nasby"
Date:
Subject: Re: [PERFORM] "Hash index" vs. "b-tree index" (PostgreSQL
Next
From: Tom Lane
Date:
Subject: Re: [PERFORM] "Hash index" vs. "b-tree index" (PostgreSQL