Re: plperlu Question - Mailing list pgsql-general

From Douglas McNaught
Subject Re: plperlu Question
Date
Msg-id m2lkzlmpg3.fsf@Douglas-McNaughts-Powerbook.local
Whole thread Raw
In response to plperlu Question  (jbduffy@tiscali.co.uk)
List pgsql-general
jbduffy@tiscali.co.uk writes:

> However, when I run the function within psql, still as the postgres superuser,
> I get a 'permission denied' response to the perl 'open(DATA, "my_csv_file")
> within my 'import()' function.
>
> The csv file is world readable as I have moved it to /tmp and given the world
> 'rwx' permissions.

Is this Redhat?  They apparently configure SELinux to disallow
Postgres access to files outside of /var/lib/pgsql/data.

-Doug

pgsql-general by date:

Previous
From: Jeremy Sellors
Date:
Subject: Createlang plpgsql
Next
From: "Otto Blomqvist"
Date:
Subject: Postgres Disconnection problems