On 24 May 2014, at 8:21, David Noel <david.i.noel@xxxxxxxxx> 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.
