From: | Alban Hertroys <haramrae(at)gmail(dot)com> |
---|---|
To: | David(dot)I(dot)Noel(at)gmail(dot)com |
Cc: | PGSQL Mailing List <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: COPY TO returns "ERROR: could not open file for writing: No such file or directory" |
Date: | 2014-05-24 08:27:58 |
Message-ID: | 656145E5-3C5A-4D9C-A940-51117D0B2EDB@gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On 24 May 2014, at 8:21, David Noel <david(dot)i(dot)noel(at)gmail(dot)com> wrote:
> COPY (SELECT * FROM page WHERE "PublishDate" between '2014-03-01' and
> '2014-04-01') TO
> '/home/ygg/sql/backup/pagedump.2014-03-01.to.2014-04-01.copy';
>
> gives me:
>
> ERROR: could not open file
> "/home/ygg/sql/backup/pagedump.2014-03-01.to.2014-04-01.copy" for
> writing: No such file or directory
> FreeBSD. PostgreSQL 9.3.
>
> Has anyone run into this before?
Two possibilities I can think of:
1. You’re not writing that file on the database server.
2. It’s a permission issue. Can you cd to that directory as user pgsql and create a file there?
# su - pgsql
# cd /home/ygg/sql/backup
# touch test
It’s possible that you lack execute permission on the symlink from /home to /usr/home, for example.
Alban Hertroys
--
If you can't see the forest for the trees,
cut the trees and you'll find there is no forest.
From | Date | Subject | |
---|---|---|---|
Next Message | Jack Douglas | 2014-05-24 11:54:28 | Data Checksum feature and streaming replication |
Previous Message | David Noel | 2014-05-24 06:21:43 | COPY TO returns "ERROR: could not open file for writing: No such file or directory" |