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

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.

Thanks,

Rich