Postgres Pro
Downloads
Home   >   mailing lists

Re: [ADMIN] pg_dump and pg_restore to dropbox - Mailing list pgsql-admin

From David G. Johnston
Subject Re: [ADMIN] pg_dump and pg_restore to dropbox
Date
Msg-id CAKFQuwYsXt4LE7HWJ5BD23CH6L6qQXaRxZafRBZBchLnsN1Vvg@mail.gmail.com
Whole thread Raw
In response to [ADMIN] pg_dump and pg_restore to dropbox  (Andrea Bonomelli <andrea@okaystudio.co.uk>)
List pgsql-admin
Tree view
On Thu, Aug 17, 2017 at 8:48 AM, Andrea Bonomelli <andrea@okaystudio.co.uk> 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.

pgsql-admin by date:

Previous
From: anand086
Date:
Subject: Re: [ADMIN] Analyze Table
Next
From: Abhijit Gharami
Date:
Subject: [ADMIN] PostgreSQL 9.4.13 is facing issue in shutting down