From: | John Seberg <johnseberg(at)yahoo(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | COPY - permission denied |
Date: | 2005-09-23 14:03:44 |
Message-ID: | 20050923140344.28662.qmail@web50211.mail.yahoo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
I have used the COPY command dozens of times! I think
I *get* it. But, I'm getting "permission denied"
errors.
This is a fresh install of Fedora Core 4 (x86). I have
Postgresql running under the user postgres. I am
logged into to psql as postgres. The files are owned
by postgres and are -rw-------. They are being found -
it isn't a "file not found" error.
My usual routine is to create a directory at the same
depth/same parent as the cluster directory called
"migrate" and put all my text file of data to load,
there. I chown them to be owned by postgres:postgres,
and chmod 600 them, if necessary. (In this case I
chmod'ed them 777 just grasping at straws).
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';
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
From | Date | Subject | |
---|---|---|---|
Next Message | Dawid Kuroczko | 2005-09-23 14:15:06 | Re: COPY - permission denied |
Previous Message | Tom Lane | 2005-09-23 13:53:07 | Re: Questions about Rollback - after insert, update, delete ... operations? |