pg_dump and pg_restore to dropbox

From: Andrea Bonomelli <andrea(at)okaystudio(dot)co(dot)uk>
To: pgsql-admin(at)postgresql(dot)org
Subject: pg_dump and pg_restore to dropbox
Date: 2017-08-17 15:48:02
Message-ID: CAN9Nn1rcebDADVNtDRhpuU1JvFYvEboOfRRg5jx2BH7AP4YbMg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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 <http://twitter.com/okaystudioldn> / facebook
<http://facebook.com/okaystudio>

<http://okaystudio.co.uk/>

*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(at)okaystudio(dot)co(dot)uk
<info(at)okaystudio(dot)co(dot)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.*

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Andrea Bonomelli 2017-08-17 15:51:58 Re: pgAdmin 4 Desktop Runtime has stopped working
Previous Message Tiffany Thang 2017-08-17 15:45:25 pgAdmin 4 Desktop Runtime has stopped working