On 4/30/15 1:23 PM, Greg Sabino Mullane wrote:
Bucardo and pg_pool are both based on the idea of replaying SQL
statements instead of replicating actual data. They have their uses, but
I personally distrust that idea, especially for DR.
Actually, Bucardo is very data-based, not statement at
This is great. Thank you both for thinking about my situation deeper.
The secondary node in Ireland is purely for DR purposes only. It will be a
read only copy that can be referred to only in the event that its absolutely
needed.
I will investigate the asynchronous methods more deeply. I
Alex,
Note that you should be weary of suggestions to make your replication
synchronous. Synchronous replication is rarely used for this kind of use
case (Cisco Jabber) where the most complete durability of the standby is
not of the utmost concern (as it would be in a banking application). Not
Alex,
Note that you should be weary of suggestions to make your replication
synchronous. Synchronous replication is rarely used for this kind of use
case (Cisco Jabber) where the most complete durability of the standby is
not of the utmost concern (as it would be in a banking application). Not
-BEGIN PGP SIGNED MESSAGE-
Hash: RIPEMD160
Bucardo and pg_pool are both based on the idea of replaying SQL
statements instead of replicating actual data. They have their uses, but
I personally distrust that idea, especially for DR.
Actually, Bucardo is very data-based, not
The streaming replication built into PostgreSQL would work fine for your
use case, assuming that you are OK with having only one primary supporting
writes and any slaves being read only as it currently (9.0-9.4) only
supports a single master. This will put minimal load on your primary server
and
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
On 04/29/2015 10:53 AM, Alex Gregory wrote:
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
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
Thank for for the valuable feedback everyone. Much appreciated.
As I look at the Jabber install doc they say to use 9.1.1(which I am hoping
means 9.1.X (15) at least). I am afraid they may not be supported otherwise.
The changes to replication logs relating to Replication Slots look
What do you think of this article that I found detailing out how to install
Postgres on CentOS, so that the proper fencing and STONITH is in place, using
Pacemaker and Corosync?:
https://github.com/smbambling/PGSQL_HA_CLUSTER/wiki/Building-A-Highly-Available-Multi-Node-PostgreSQL-Cluster
On 4/29/15 1:13 PM, Alex Gregory wrote:
I was thinking that I could use Slony but then I read that it does not like WAN
replication. I have also read about streaming replication native to Postgres
but was not sure how that would work over the WAN. Bucardo seems better for
Data Warehousing
12 matches
Mail list logo