Re: storing postgres data on dropbox

Am 18.06.2017 um 03:03 schrieb Martin Mueller:
> This is a queestion from a Postgresql novice.
>
> I use Postgresql in a single-user environment on a Mac with OS Sierra.
> I use AquaFold DataStudio as a client, which is nice but also keeps me
> woefully ignorant about many aspects of the underlying application.
>
> As I understand it, Postgres data are stored in my homedirectory
> /users/martin/Library ApplicationSupport/Postgres/var9.5/base/. I
> have read things on the Web about backing up data to Dropbox (I have
> 80GB of data) . But that means that my data sit first in the base
> directory, then in the Dropbox directory from which they are backed up
> to the Dropbox cloud. So my 80 GB of data take up 160GB on my
> machine. Is there a way of installing the base directory directly in
> the Dropbox directory so that the data are stored only once on my machine?

You can store Backups there (dumps), but i would strongly advise
against to store the db there. PostgreSQL relys on the fsync, that's not
possible in this case. I'm sure, a total data disaster would not be a
question, only when it would happen.

Why not a PostgreSQL-database somewhere in the cloud?

Regards, Andreas

--
2ndQuadrant - The PostgreSQL Support Company.
www.2ndQuadrant.com