BUG #2904: COPY FROM -> permisson denied

Поиск
Список
Период
Сортировка
От Izsak Rudolf
Тема BUG #2904: COPY FROM -> permisson denied
Дата
Msg-id 200701172339.l0HNdKRo083675@wwwmaster.postgresql.org
обсуждение исходный текст
Ответы Re: BUG #2904: COPY FROM -> permisson denied  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-bugs
The following bug has been logged online:

Bug reference:      2904
Logged by:          Izsak Rudolf
Email address:      rudolf_izsak@yahoo.de
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:
[root@yifter ~]# 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

В списке pgsql-bugs по дате отправления:

Предыдущее
От: "Maarten van der Heijden"
Дата:
Сообщение: Troubles in Initializing Postgres Database 8.2
Следующее
От: "Adriaan van Os"
Дата:
Сообщение: BUG #2906: slow windows network performance