The following bug has been logged online:
Bug reference: 2904
Logged by: Izsak Rudolf
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.1.6
Operating system: Fedora Core 6
Description: COPY FROM -> permisson denied
Details:
I wanted to COPY the content of the sample data file /home/csakmost.txt to
my data table t_crdc1 using the following command:
exp03038=# COPY t_crdc1 FROM '/home/csakmost.txt' WITH DELIMITER ' ' NULL
'NULL';
But I have got the error message:
ERROR: could not open file "/home/csakmost.txt" for reading: Hozzáférés
megtagadva
The letter two words "Hozzáférés megtagadva" stay for "access denied" in
Hungarian.
The same procedure worked fine under my system RedHat 9 and PostgreSQL 7.3
before.
I have found some material to similar issues on the web, but all of them
could be solved by changing the permissions of the data file.
I have set the permissons of the file "/home/csakmost.txt" also, so that it
can be read by any users (both of the file and the directory). Also if I try
to read the file as user postgres, it works:
[EMAIL PROTECTED] ~]# su postgres
bash-3.1$ cat /home/csakmost.txt
4053 1 4 2007-1-17 NULL NULL
Also, it works if I use the command \copy instead of COPY.
I first thought that the owner of the SQL server is an other user than
postgres. But according to the permisson tables of the "/home" and of the
"/home/csakmost.txt", they can be read by all users:
drwxr-xr-x 5 root root 4096 jan 17 23.37 home
-rw-r--r-- 1 root root 29 jan 17 23.52 csakmost.txt
I think, it is a bug, but if it is a feature, I'm sory for that, and I would
be very grateful if You could help me in that case.
Sincerely Yours,
Rudolf Izsak
ELTE, Hungary
---------------------------(end of broadcast)---------------------------
TIP 7: You can help support the PostgreSQL project by donating at
http://www.postgresql.org/about/donate
