Re: [GENERAL] storing postgres data on dropbox - Mailing list pgsql-general

Why not a PostgreSQL-database somewhere in the cloud? Good question, but it's a question of money and performance. I
usedMySQL for many years and then moved a dataset to an instance on AWS. The performance was horribly slow. Then some
kindsoul at my institution hooked me up with "Aurora," which I take to be MySQL on steroids. That was great, and the
performancewas almost as good as on my desktopc. But it cost hundreds of dollars per month. I work at home with a
machinethat has 32 GB of memory. In order to get comparable performance from a cloud-based Postgres instance, I'd have
tospend a lot of money that I don't have. Dropbox costs $120 a year for a terabyte of storage, which is very
affordable.
 




On 6/18/17, 2:43 AM, "pgsql-general-owner@postgresql.org on behalf of Andreas Kretschmer"
<pgsql-general-owner@postgresql.orgon behalf of andreas@a-kretschmer.de> wrote:
 

>
>
>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
>
>
>
>-- 
>Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
>To make changes to your subscription:

>https://urldefense.proofpoint.com/v2/url?u=http-3A__www.postgresql.org_mailpref_pgsql-2Dgeneral&d=DwICaQ&c=yHlS04HhBraes5BQ9ueu5zKhE7rtNXt_d012z2PA6ws&r=rG8zxOdssqSzDRz4x1GLlmLOW60xyVXydxwnJZpkxbk&m=KXaWmcxNhlCSHssyqrqU1S_mVlceHc7yM3UpQ2fBVXQ&s=9eN95fgPNJGdCFSD_ozbDci12h1SjX_qAovIBV01Pcc&e=