Re: COPY - permission denied - Mailing list pgsql-general

From Douglas McNaught
Subject Re: COPY - permission denied
Date
Msg-id m24q8b3m1r.fsf@Douglas-McNaughts-Powerbook.local
Whole thread Raw
In response to COPY - permission denied  (John Seberg <johnseberg@yahoo.com>)
List pgsql-general
John Seberg <johnseberg@yahoo.com> writes:

> I have bounced the db, made sure the processes and
> files are owned by postgres. What else is there?
>
> COPY consult FROM
> '/var/lib/pgsql/migrate/consult.txt';

This is probably a dumb question, but is 'migrate' owned and readable
by 'postgres' as well?

If that's not the problem, please post more info, including the error
message you get in 'pqsl' and any relevant server log entries.

-Doug

pgsql-general by date:

Previous
From: Dawid Kuroczko
Date:
Subject: Re: COPY - permission denied
Next
From: Michael Fuhr
Date:
Subject: Re: COPY - permission denied