Re: COPY failure on directory I own

From: Rich Shepard <rshepard(at)appl-ecosys(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: COPY failure on directory I own
Date: 2011-08-30 17:34:59
Message-ID: alpine.LNX.2.00.1108301032560.13948@salmo.appl-ecosys.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message John R Pierce 2011-08-30 17:36:36 Re: out of memory - no sort
Previous Message Rich Shepard 2011-08-30 17:32:30 Re: COPY failure on directory I own