Re: COPY - permission denied

From: Douglas McNaught <doug(at)mcnaught(dot)org>
To: John Seberg <johnseberg(at)yahoo(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: COPY - permission denied
Date: 2005-09-23 14:18:08
Message-ID: m24q8b3m1r.fsf@Douglas-McNaughts-Powerbook.local
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

John Seberg <johnseberg(at)yahoo(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Michael Fuhr 2005-09-23 14:21:10 Re: COPY - permission denied
Previous Message Dawid Kuroczko 2005-09-23 14:15:06 Re: COPY - permission denied