Re: COPY failure on directory I own

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