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
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
