Re: [GENERAL] Very high latency, low bandwidth replication

2014-07-05 Thread Bob Jolliffe
Thanks Francisco for these inputs. I hadn't considered log shipping as I knew I didn't want to track changes to all tables (and databases). Setting up a local partial mirror is an interesting thought which hadn't crossed my mind .. I'll giver that some consideration. Though currently I am

Re: [GENERAL] Very high latency, low bandwidth replication

2014-07-05 Thread Bob Jolliffe
Thanks Stuart. I'll do some measurements on plaintext dump to git. On 2 July 2014 09:46, Stuart Bishop stu...@stuartbishop.net wrote: On 30 June 2014 15:05, Bob Jolliffe bobjolli...@gmail.com wrote: What are people's thoughts about a more optimal solution? I would like to use a more

Re: [GENERAL] Very high latency, low bandwidth replication

2014-07-05 Thread Francisco Olarte
Hi Bob: On Sat, Jul 5, 2014 at 3:34 PM, Bob Jolliffe bobjolli...@gmail.com wrote: Though currently I am thinking to address the problem of generating deltas at the application level rather than to use postgresql features which are largely optimized for a slightly different set of circumstances

Re: [GENERAL] Very high latency, low bandwidth replication

2014-07-02 Thread Stuart Bishop
On 30 June 2014 15:05, Bob Jolliffe bobjolli...@gmail.com wrote: What are people's thoughts about a more optimal solution? I would like to use a more incremental approach to replication. This does not have to be a live replication .. asynchronously triggering once every 24 hours is

[GENERAL] Very high latency, low bandwidth replication

2014-06-30 Thread Bob Jolliffe
Hi I have been grappling with a problem for some time I would appreciate some advice on. We have a public health application which is web based with a postgresql backing store which is designed for use by the public sector ministry of health in a significant number of African, Asian and other

Re: [GENERAL] Very high latency, low bandwidth replication

2014-06-30 Thread Francisco Olarte
Hi Bob. On Mon, Jun 30, 2014 at 10:05 AM, Bob Jolliffe bobjolli...@gmail.com wrote: What are people's thoughts about a more optimal solution? I would like to use a more incremental approach to replication. This does not have to be a live replication .. asynchronously triggering once every 24