Re: storing postgres data on dropbox

From: Martin Mueller <martinmueller(at)northwestern(dot)edu>
To: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: storing postgres data on dropbox
Date: 2017-06-18 17:30:44
Message-ID: 4526AD5D-B988-41C4-AC7E-D7FB21E3D18C@northwestern.edu
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-general

Thank for this very helpful answer, which can be implemented for less than $100. For somebody who started working a 128k Mac in the eighties, it is mindboggling that for that amount you can buy a terabyte of storage in a device that you put in a coat pocket. I'll read up on rsync

On 6/18/17, 11:13 AM, "Adrian Klaver" <adrian(dot)klaver(at)aklaver(dot)com> wrote:

>On 06/18/2017 06:16 AM, Martin Mueller wrote:
>> 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.
>
>If it where me I would pick up 1TB external hard drive then:
>
>1) On your Mac(Location 1) stop Postgres and then back up/sync your base
>directory to the external harddrive.
>
>2) Take the external hard drive to Location 2.
>
>3) Stop Postgres at Location 2 and then sync to base directory there.
>
>4) Start Postgres at location 2.
>
>5) Repeat for going other direction.
>
>It is similar to using Dropbox, with the difference being you do not
>have Dropbox trying to sync while you are using the database. That I am
>pretty sure will not end well. The above does depend on familiarity with
>programs like rsync or Unison for the syncing portion.
>
>
>
>
>--
>Adrian Klaver
>adrian(dot)klaver(at)aklaver(dot)com

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Karsten Hilbert 2017-06-18 17:58:36 Re: storing postgres data on dropbox
Previous Message Bruno Wolff III 2017-06-18 16:16:32 Re: storing postgres data on dropbox