Permission problem with COPY FROM

Поиск
Список
Период
Сортировка
От Stéphane FILLON
Тема Permission problem with COPY FROM
Дата
Msg-id 000e01befedd$3e2210c0$a6373ad1@portable
обсуждение исходный текст
Ответы Re: [HACKERS] Permission problem with COPY FROM  (Nuchanach Klinjun <nuchk@inet.co.th>)
Список pgsql-sql
Hi,
 
Each time I try to insert an ascii file with the COPY FROM command, I get the following message:
 
 "ERROR: COPY command, running in backend with effective uid 501 (that's Postgres), could not open file '/usr/local/.../cltclr001' for reading. Error: Permission not allowed (13)."
 
What rights do I have to put to process the COPY command inside PSQL.
 
I have try nearly everything, actual rights: uog+rw even on the directory.
 
 
What's wrong.
 
Stephane FILLON

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

Предыдущее
От: "Esteban Chiner Sanz"
Дата:
Сообщение: Primary key on NUMERIC type
Следующее
От: Jens Glaser
Дата:
Сообщение: reliable way to crash postgres :)