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.klaver@xxxxxxxxxxx> 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.klaver@xxxxxxxxxxx -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
