[GENERAL] PostgreSQL HA config recommendations

2015-04-29 Thread Alex Gregory
Hello- I have been doing lots of reading and I really want to make sure that I get this HA architecture I am working on correct. I figured the best way would be to reach out to the community for advice. I am installing Cisco Jabber and want to use Postgres for the back end. The Postgres serv

[GENERAL] PostgreSQL HA config recommendations

2015-04-29 Thread Alex Gregory
Hello- I have been doing lots of reading and I really want to make sure that I get this HA architecture I am working on correct. I figured the best way would be to reach out to the community for advice. I am installing Cisco Jabber and want to use Postgres for the back end. The Postgres serv

Re: [GENERAL] PostgreSQL HA config recommendations

2015-04-29 Thread Alex Gregory
L and will very likely be part of the > standard streaming replication in PostgreSQL 9.5 and above. > > Will J. Dunn > willjdunn.com <http://willjdunn.com/> > On Wed, Apr 29, 2015 at 2:57 PM, Joshua D. Drake <mailto:j...@commandprompt.com>> wrote: > > On

Re: [GENERAL] PostgreSQL HA config recommendations

2015-04-29 Thread Alex Gregory
<https://github.com/smbambling/PGSQL_HA_CLUSTER/wiki/Building-A-Highly-Available-Multi-Node-PostgreSQL-Cluster> Thanks, Alex > On Apr 29, 2015, at 2:50 PM, Alex Gregory wrote: > > Thank for for the valuable feedback everyone. Much appreciated. > > As I look at the Jabber in

Re: [GENERAL] PostgreSQL HA config recommendations

2015-05-01 Thread Alex Gregory
node than the DB master. In such case it is >>realistically beneficial to batch multiple write operations in a >> single STATEMENT instead. >>If the replication synchronous slave is on yet another node, the >>best case (single statement) scenario would be 2 x round trip