[GENERAL] COPY - permission denied

2005-09-23 Thread John Seberg
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---.

Re: [GENERAL] COPY - permission denied

2005-09-23 Thread Dawid Kuroczko
On 9/23/05, John Seberg [EMAIL PROTECTED] wrote: I have used the COPY command dozens of times! I thinkI *get* it. But, I'm getting permission deniederrors.This is a fresh install of Fedora Core 4 (x86). I havePostgresql running under the user postgres. I am logged into to psql as postgres. The

Re: [GENERAL] COPY - permission denied

2005-09-23 Thread Michael Fuhr
On Fri, Sep 23, 2005 at 07:03:44AM -0700, John Seberg wrote: 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

Re: [GENERAL] COPY - permission denied

2005-09-23 Thread Douglas McNaught
John Seberg [EMAIL PROTECTED] 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

Re: [GENERAL] COPY - permission denied

2005-09-23 Thread Tom Lane
John Seberg [EMAIL PROTECTED] writes: 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

Re: [GENERAL] COPY - permission denied

2005-09-23 Thread John Seberg
--- Tom Lane [EMAIL PROTECTED] wrote: John Seberg [EMAIL PROTECTED] writes: 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

Re: [GENERAL] COPY - permission denied

2005-09-23 Thread Dawid Kuroczko
On 9/23/05, John Seberg [EMAIL PROTECTED] wrote: --- Tom Lane [EMAIL PROTECTED] wrote: John Seberg [EMAIL PROTECTED] writes: 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