Re: pg_dump and pg_restore to dropbox

["David G. Johnston" <david.g.johnston@xxxxxxxxx>]

On Thu, Aug 17, 2017 at 8:48 AM, Andrea Bonomelli <andrea@xxxxxxxxxxxxxxxx> wrote:

​D​

UMP BAD
sudo PGUSER="postgres" PGPASSWORD="xxx" /Library/PostgreSQL/9.5/pgAdmin3.app/Contents/SharedSupport/pg_dump --format=c okay_db_3 > '/Volumes/Promise\ Pegasus/Dropbox\ \(Okay\ place\)/OkayPost/_RESOLVEBACKUP/db3 /test2.backup' 

-bash: /Volumes/Promise\ Pegasus/Dropbox\ \(Okay\ place\)/OkayPost/_RESOLVEBACKUP/db3 /test2.backup: No such file or directory

what am I doing wrong

​?

​I would suspect the problem is with escaping the spaces and parens in your file name while simultaneously quoting the entire path.

David J.