Re: [GENERAL] storing postgres data on dropbox - Mailing list pgsql-general

From Martin Mueller
Subject Re: [GENERAL] storing postgres data on dropbox
Date
Msg-id A9EA9324-837D-4D8E-B4F6-35FDCB3C0441@northwestern.edu
Whole thread Raw
In response to Re: [GENERAL] storing postgres data on dropbox  (Karsten Hilbert <Karsten.Hilbert@gmx.net>)
Responses Re: [GENERAL] storing postgres data on dropbox
Re: [GENERAL] storing postgres data on dropbox
Re: [GENERAL] storing postgres data on dropbox
List pgsql-general
How close is close enough? In my case, the machines run OS Sierra, and the installation uses the same directory paths
Keepingthe Postgres version in sync should be simple. Is that close enough?
 

In MySQL you can copy and paste individual tables if the data are kept in ISAM, but INNO is hopeless that way. Is
Postgresmore like INNO than ISAM when it comes to table storage?
 




On 6/18/17, 12:58 PM, "pgsql-general-owner@postgresql.org on behalf of Karsten Hilbert"
<pgsql-general-owner@postgresql.orgon behalf of Karsten.Hilbert@gmx.net> wrote:
 

>On Sun, Jun 18, 2017 at 05:30:44PM +0000, Martin Mueller wrote:
>
>> 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
>
>I seem to remember that for this to work the two machines
>must be *very* close in architecture, and the PostgreSQL
>versions best be exactly the same.
>
>Karsten
>-- 
>GPG key ID E4071346 @ eu.pool.sks-keyservers.net
>E167 67FD A291 2BEA 73BD  4537 78B9 A9F9 E407 1346
>
>
>-- 
>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=DwIBAg&c=yHlS04HhBraes5BQ9ueu5zKhE7rtNXt_d012z2PA6ws&r=rG8zxOdssqSzDRz4x1GLlmLOW60xyVXydxwnJZpkxbk&m=dRn-urP2CTrTrg6xFXNVHRpTwbZJSAI0SDEIGtDW5tM&s=NMV4EDSxwFIOUoomuK06tWbUWUTkD5pd_Q5thb2xZ6I&e=


pgsql-general by date:

Previous
From: Steve Atkins
Date:
Subject: Re: [GENERAL] storing postgres data on dropbox
Next
From: Karsten Hilbert
Date:
Subject: Re: [GENERAL] storing postgres data on dropbox