Copy Error - Mailing list pgsql-hackers

From san_kalyan@yahoo.com (Chakravarthy K Sannedhi)
Subject Copy Error
Date
Msg-id 6354d5e2.0106181859.2d433e1@posting.google.com
Whole thread Raw
List pgsql-hackers
Hi,

When I am trying to import a file(named 'myfile') that is present in
my home directory into the the postgresql database using the
*pgaccess* gui tool, it is giving the following error.

ERROR: COPY command, running in backend with effective uid 26, could
not open file 'myfile' for reading. Errno=Permission denied

Can any one please tell me what I am missing here. Is it necessary for
the 'postgres' user to own the file named 'myfile' under my home
directory.

TIA
Chakravarthy K Sannedhi


pgsql-hackers by date:

Previous
From: Pedro Abelleira Seco
Date:
Subject: Project: Java administration center
Next
From: Peter Eisentraut
Date:
Subject: Re: Encrypting pg_shadow passwords