From: | Bernd Helmle <mailings(at)oopsware(dot)de> |
---|---|
To: | Don Isgitt <djisgitt(at)soundenergy(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: copy command problem |
Date: | 2003-12-17 17:39:07 |
Message-ID: | 3FE094BB.6090402@oopsware.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Don Isgitt wrote:
> Hi,
>
> I am recreating a database and its applications onto a new server and
> new software; old version of pg was 7.2.4 and new version is
>
> gds2=# select version();
>
> version
>
> --------------------------------------------------------------------------------------------------------
>
> PostgreSQL 7.4 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 3.2.3
> 20030502 (Red Hat Linux 3.2.3-20)
>
> I am having trouble with the copy command as follows:
>
>
> gds2=# copy survey_match from '/home/djisgitt/perl/fixsvy.dat' with
> delimiter as '>';
> ERROR: could not open file "/home/djisgitt/perl/fixsvy.dat" for
> reading: Permission denied
>
> File sysem permissions are
>
> [djisgitt(at)dbserver perl]$ ls -l /home/djisgitt/perl/fixsvy.dat
> -rwxrwxrwx 1 djisgitt djisgitt 198441 Nov 5 12:35
> /home/djisgitt/perl/fixsvy.dat
>
Check, if your home and subdirectories has sufficient permissions: you
need at least r-x for others on the specific directories, otherwise your
backend is not able to access your dump.
chmod o+rx /home/djisgitt should do the job, i think
Bernd
From | Date | Subject | |
---|---|---|---|
Next Message | Sai Hertz And Control Systems | 2003-12-17 17:50:01 | Re: Excel, OpenOffice and Postgres |
Previous Message | Christopher Murtagh | 2003-12-17 17:31:38 | Re: restore error - language "plperlu" is not trusted |