Re: COPY failure on directory I own

Поиск
Список
Период
Сортировка
От Scott Mead
Тема Re: COPY failure on directory I own
Дата
Msg-id CAKq0gvJe4Ykgxyj62qOmJ3Dx=te2aSeewmiQ0bbF4MLss2avBQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: COPY failure on directory I own  (Scott Ribe <scott_ribe@elevated-dev.com>)
Ответы Re: COPY failure on directory I own  (Rich Shepard <rshepard@appl-ecosys.com>)
Список pgsql-general


On Tue, Aug 30, 2011 at 1:20 PM, Scott Ribe <scott_ribe@elevated-dev.com> wrote:
On Aug 30, 2011, at 11:14 AM, Rich Shepard wrote:

> The permissions on that directory are 755 and it's owned by me. Since I
> have no problems writing other files to that directory I must have the
> command syntax incorrect but I don't see where.

In this case, it's not about YOU and your permissions, it's about the server.  The COPY command writes data as the 'postgres' operating system user (or whichever user owns the postgres backend process).

--Scott

 

Where is the server and where are you? You are issuing a command to the server to create a file at that path on the server.

--
Scott Ribe
scott_ribe@elevated-dev.com
http://www.elevated-dev.com/
(303) 722-0567 voice





--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

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

Предыдущее
От: Scott Ribe
Дата:
Сообщение: Re: SELECT Query on DB table preventing inserts
Следующее
От: Pavel Stehule
Дата:
Сообщение: Re: out of memory - no sort