From: | Andrew Gould <andrewgould(at)yahoo(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: server permissions for sql copy |
Date: | 2000-12-02 13:53:27 |
Message-ID: | 20001202135327.12862.qmail@web120.yahoomail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Yup, that was the problem. COPY works fine now.
Thanks for yet another lesson.
Andrew Gould
--- Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> Andrew Gould <andrewgould(at)yahoo(dot)com> writes:
> > I'm running PostgreSQL 7.0.2 on Caldera eDesktop
> 2.4.
> > when I try to use the SQL COPY command in psql, I
> get
> > an error message informing me that the backend
> could
> > not open the file for reading. I think the error
> > number was 13 - Permission denied. I changed the
> > permissions of the directory and file to
> > world-readable; but I still get the same error
> > message.
>
> What about the directories above the one containing
> the file?
>
> Also, don't forget that the critical permission for
> a directory
> is execute (= "allow lookup of entries"), not read
> (= "make a
> directory listing"). You probably want permissions
> rwxr-xr-x
> or rwxrwxr-x on directories that need to be publicly
> readable.
>
> regards, tom lane
__________________________________________________
Do You Yahoo!?
Yahoo! Shopping - Thousands of Stores. Millions of Products.
http://shopping.yahoo.com/
From | Date | Subject | |
---|---|---|---|
Next Message | Peter Eisentraut | 2000-12-02 16:32:46 | Re: postmaster of 7.0.3 listening but pslq cannot connect |
Previous Message | Martin Jacobs | 2000-12-02 10:51:09 | postmaster of 7.0.3 listening but pslq cannot connect |