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

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 unde

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

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

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 i

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 denied"errors.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

[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---