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" <[email protected]> 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 >[email protected] -- Sent via pgsql-general mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
