Re: COPY failure on directory I own - Mailing list pgsql-general

From Scott Mead
Subject Re: COPY failure on directory I own
Date
Msg-id CAKq0gvJe4Ykgxyj62qOmJ3Dx=te2aSeewmiQ0bbF4MLss2avBQ@mail.gmail.com
Whole thread Raw
In response to Re: COPY failure on directory I own  (Scott Ribe <scott_ribe@elevated-dev.com>)
Responses Re: COPY failure on directory I own
List 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 by date:

Previous
From: Scott Ribe
Date:
Subject: Re: SELECT Query on DB table preventing inserts
Next
From: Pavel Stehule
Date:
Subject: Re: out of memory - no sort