| From: | Kris Jurka <books(at)ejurka(dot)com> |
|---|---|
| To: | Slavisa Garic <Slavisa(dot)Garic(at)infotech(dot)monash(dot)edu(dot)au> |
| Cc: | <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: COPY from question |
| Date: | 2004-02-03 04:01:35 |
| Message-ID: | Pine.LNX.4.33.0402022300080.8105-100000@leary.csoft.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers pgsql-performance |
On Tue, 3 Feb 2004, Slavisa Garic wrote:
> My understanding is that COPY workes FROM 'filename' or STDIN where the
> last characters are '.\\n'. I tried using the copy from 'filename' and as
> I said NetBSD is not complaining where I get the following error on Linux
> machine even if permissions on the data file are 777:
>
> _pg.error: ERROR: COPY command, running in backend with effective uid
> 26, could not open file '/home/slavisa/.nimrod/experiments/demo/ejdata'
> for reading. Errno = Permission denied (13).
>
This is probably a permissions problem at a higher level, check the
permissions on the directories in the path.
Kris Jurka
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2004-02-03 04:07:05 | Re: COPY from question |
| Previous Message | Tom Lane | 2004-02-03 03:45:22 | Re: 7.5 change documentation |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2004-02-03 04:07:05 | Re: COPY from question |
| Previous Message | Josh Berkus | 2004-02-03 03:41:57 | Re: MySQL+InnoDB vs. PostgreSQL test? |