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