Postgres Pro
Downloads
Home   >   mailing lists

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

From Andrea Bonomelli
Subject [ADMIN] pg_dump and pg_restore to dropbox
Date
Msg-id CAN9Nn1rcebDADVNtDRhpuU1JvFYvEboOfRRg5jx2BH7AP4YbMg@mail.gmail.com
Whole thread Raw
Responses Re: [ADMIN] pg_dump and pg_restore to dropbox  ("David G. Johnston" <david.g.johnston@gmail.com>)
List pgsql-admin
Tree view
Hi all

I've been trying to dump and restore a database to a folder located on dropbox on a mac sierra.

Commands works fine over an internal hdd but not via an external one.

DUMP OK
sudo PGUSER="postgres" PGPASSWORD="xxx" /Library/PostgreSQL/9.5/pgAdmin3.app/Contents/SharedSupport/pg_dump --format=c okay_db_3 > '/Volumes/1TB/databasebackutest2.backup' 

DUMP 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?




--


Andrea Bonomelli

OKAY STUDIO


+44 207 127 0764


okaystudio.co.uk / twitter / facebook


This transmission is confidential and may be privileged.  It is for use by the addressee(s) only. If you are not the addressee or if this email is sent to you in error, please let us know by return to info@okaystudio.co.uk and delete the message from your system.  No contract may be concluded on behalf of Okay Studio email. Okay Studio reserves the right to monitor e-mail communication through its network.

pgsql-admin by date:

Previous
From: Tiffany Thang
Date:
Subject: [ADMIN] pgAdmin 4 Desktop Runtime has stopped working
Next
From: Andrea Bonomelli
Date:
Subject: Re: [ADMIN] pgAdmin 4 Desktop Runtime has stopped working