Skip site navigation (1) Skip section navigation (2)

Re: COPY failure on directory I own

From: Scott Mead <scottm(at)openscg(dot)com>
To: Scott Ribe <scott_ribe(at)elevated-dev(dot)com>
Cc: Rich Shepard <rshepard(at)appl-ecosys(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: COPY failure on directory I own
Date: 2011-08-30 17:24:07
Message-ID: CAKq0gvJe4Ykgxyj62qOmJ3Dx=te2aSeewmiQ0bbF4MLss2avBQ@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-general
On Tue, Aug 30, 2011 at 1:20 PM, Scott Ribe <scott_ribe(at)elevated-dev(dot)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(at)elevated-dev(dot)com
> http://www.elevated-dev.com/
> (303) 722-0567 voice
>
>
>
>
>
> --
> Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>

In response to

Responses

pgsql-general by date

Next:From: Pavel StehuleDate: 2011-08-30 17:25:26
Subject: Re: out of memory - no sort
Previous:From: Scott RibeDate: 2011-08-30 17:21:11
Subject: Re: SELECT Query on DB table preventing inserts

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group