Re: [GENERAL] storing postgres data on dropbox

2017-06-18 Thread Adrian Klaver
On 06/18/2017 01:13 PM, Martin Mueller wrote: I think I get it. 'base' is not the data directory but a child of var-9.5, which (with its entire path) is the "data directory". I honestly don't recall how I installed Posgres, but I'm pretty sure that I picked the default method from the

Re: [GENERAL] storing postgres data on dropbox

2017-06-18 Thread Martin Mueller
I think I get it. 'base' is not the data directory but a child of var-9.5, which (with its entire path) is the "data directory". I honestly don't recall how I installed Posgres, but I'm pretty sure that I picked the default method from the Postgres. Many thanks for your help, which is

Re: [GENERAL] storing postgres data on dropbox

2017-06-18 Thread Adrian Klaver
On 06/18/2017 01:00 PM, Martin Mueller wrote: Did you mean that "/users/martin/Library ApplicationSupport/Postgres/var9.5/base/" is above or below the data directory? As I understand it Postgres is the highest Postgres specific directory. It contains just one child directory, var-9.5, which

Re: [GENERAL] storing postgres data on dropbox

2017-06-18 Thread Martin Mueller
Did you mean that "/users/martin/Library ApplicationSupport/Postgres/var9.5/base/" is above or below the data directory? As I understand it Postgres is the highest Postgres specific directory. It contains just one child directory, var-9.5, which has a lot of subdirectories, including

Re: [GENERAL] storing postgres data on dropbox

2017-06-18 Thread Adrian Klaver
On 06/18/2017 11:29 AM, Martin Mueller wrote: How close is close enough? In my case, the machines run OS Sierra, and the installation uses the same directory paths Keeping the Postgres version in sync should be simple. Is that close enough? In MySQL you can copy and paste individual tables if

Re: [GENERAL] storing postgres data on dropbox

2017-06-18 Thread Karsten Hilbert
On Sun, Jun 18, 2017 at 06:29:50PM +, Martin Mueller wrote: > How close is close enough? In my case, the machines run OS > Sierra, and the installation uses the same directory paths > Keeping the Postgres version in sync should be simple. Is > that close enough? I am not an expert on that.

Re: [GENERAL] storing postgres data on dropbox

2017-06-18 Thread Karsten Hilbert
On Sun, Jun 18, 2017 at 06:29:50PM +, Martin Mueller wrote: > In MySQL you can copy and paste individual tables if the > data are kept in ISAM, but INNO is hopeless that way. Is > Postgres more like INNO than ISAM when it comes to table > storage? *more* like INNO but not at all *like* INNO

Re: [GENERAL] storing postgres data on dropbox

2017-06-18 Thread Martin Mueller
How close is close enough? In my case, the machines run OS Sierra, and the installation uses the same directory paths Keeping the 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

Re: [GENERAL] storing postgres data on dropbox

2017-06-18 Thread Steve Atkins
> On Jun 18, 2017, at 10:58 AM, Karsten Hilbert wrote: > > On Sun, Jun 18, 2017 at 05:30:44PM +, 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

Re: [GENERAL] storing postgres data on dropbox

2017-06-18 Thread Karsten Hilbert
On Sun, Jun 18, 2017 at 05:30:44PM +, 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

Re: [GENERAL] storing postgres data on dropbox

2017-06-18 Thread Martin Mueller
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

Re: [GENERAL] storing postgres data on dropbox

2017-06-18 Thread Bruno Wolff III
On Sun, Jun 18, 2017 at 13:16:16 +, 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

Re: [GENERAL] storing postgres data on dropbox

2017-06-18 Thread Adrian Klaver
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

Re: [GENERAL] storing postgres data on dropbox

2017-06-18 Thread Martin Mueller
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,"

Re: [GENERAL] storing postgres data on dropbox

2017-06-18 Thread Andreas Kretschmer
Am 18.06.2017 um 03:03 schrieb Martin Mueller: This is a queestion from a Postgresql novice. I use Postgresql in a single-user environment on a Mac with OS Sierra. I use AquaFold DataStudio as a client, which is nice but also keeps me woefully ignorant about many aspects of the underlying

[GENERAL] storing postgres data on dropbox

2017-06-17 Thread Martin Mueller
This is a queestion from a Postgresql novice. I use Postgresql in a single-user environment on a Mac with OS Sierra. I use AquaFold DataStudio as a client, which is nice but also keeps me woefully ignorant about many aspects of the underlying application. As I understand it, Postgres data are