| 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
| 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 |