COPY - permission denied
От | John Seberg |
---|---|
Тема | COPY - permission denied |
Дата | |
Msg-id | 20050923140344.28662.qmail@web50211.mail.yahoo.com обсуждение исходный текст |
Ответы |
Re: COPY - permission denied
Re: COPY - permission denied Re: COPY - permission denied Re: COPY - permission denied |
Список | 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
В списке pgsql-general по дате отправления: