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

From Craig Ringer
Subject Re: COPY failure on directory I own
Date
Msg-id 4E5D83F3.7030006@ringerc.id.au
Whole thread Raw
In response to Re: COPY failure on directory I own  (Rich Shepard <rshepard@appl-ecosys.com>)
Responses Re: COPY failure on directory I own
List pgsql-general
On 31/08/2011 1:34 AM, Rich Shepard wrote:
> On Tue, 30 Aug 2011, Scott Mead wrote:
>
>> 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,
>
> Ah so. User 'postgres' is in the same group ('users') as I am, so I need
> to change the perms on the data directory to 775 to give postgres write
> access.

Yeah, or use the client/server copy protocol via psql's \copy command.

--
Craig Ringer


pgsql-general by date:

Previous
From: Craig Ringer
Date:
Subject: Re: duplicate key violates unique on a nextval() field
Next
From: Rich Shepard
Date:
Subject: Re: COPY failure on directory I own