[GENERAL] storing postgres data on dropbox

2017-06-17 Thread Martin Mueller
e properly synched before firing up Postgres. In theory it should work but I am fond of saying that the difference between theory and practice is usually greater in practice than in theory. With thanks in advance for any advice Martin Mueller Professor emeritus of English and Classics Northwestern University

Re: [GENERAL] storing postgres data on dropbox

2017-06-18 Thread Martin Mueller
ce, 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. On 6/18/17, 2:43 AM, "pgsql-general-ow...@postgresql.org on behalf of Andreas Kretschmer" wrote: > > >Am 18.06.2017 u

Re: [GENERAL] storing postgres data on dropbox

2017-06-18 Thread Martin Mueller
6/18/17, 11:13 AM, "Adrian Klaver" 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 m

Re: [GENERAL] storing postgres data on dropbox

2017-06-18 Thread Martin Mueller
hopeless that way. Is Postgres more like INNO than ISAM when it comes to table storage? On 6/18/17, 12:58 PM, "pgsql-general-ow...@postgresql.org on behalf of Karsten Hilbert" wrote: >On Sun, Jun 18, 2017 at 05:30:44PM +, Martin Mueller wrote: > >> Thank for this very hel

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 'base'.

Re: [GENERAL] storing postgres data on dropbox

2017-06-18 Thread Martin Mueller
thanks for your help, which is exceptionally clear and detailed. MM On 6/18/17, 3:03 PM, "Adrian Klaver" wrote: >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