Why not a PostgreSQL-database somewhere in the cloud? Good question, but it's a question of money and performance. I used MySQL for many years and then moved a dataset to an instance on AWS. The performance was horribly slow. Then some kind soul at my institution hooked me up with "Aurora," which I take to be MySQL on steroids. That was great, and the performance was almost as good as on my desktopc. But it cost hundreds of dollars per month. I work at home with a machine that has 32 GB of memory. In order to get comparable performance from a cloud-based Postgres instance, I'd have to spend 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-ow...@postgresql.org on behalf of Andreas Kretschmer" <pgsql-general-ow...@postgresql.org on behalf of andr...@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= > -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
