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 wrote: > On 30 June 2014 15:05, Bob Jolliffe wrote: > > > What are people's thoughts about a more optimal solution? I would like > to > > use a more incr

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

2014-07-05 Thread Bob Jolliffe
to it. Fortunately this days are mostly behind us :-) On 30 June 2014 13:05, Francisco Olarte wrote: > Hi Bob. > > On Mon, Jun 30, 2014 at 10:05 AM, Bob Jolliffe > wrote: > > What are people's thoughts about a more optimal solution? I would like > to > > use a

[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 cou

[GENERAL] pg_hba.conf broken after cluster upgrade

2013-10-16 Thread Bob Jolliffe
Hello I just upgraded my postgresql server from 8.4 to 9.2 on ubuntu linux 12.04. I installed the new version then used pg_upgrade to upgrade and replicate the cluster from the old server to the new. Everything appears to have worked well except that I am left with a problem with my pg_hba.conf