By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
437,903 Members | 1,067 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 437,903 IT Pros & Developers. It's quick & easy.

Desperate help needed for Replication

P: n/a
I am trying to perform what I best understand as Multi-master asynchronous replication for postgres 7.3.3 servers. After researching, I tried the pgReplication project (and made the simple modification as listed in their mailing lists), but was not able to build the environment needed for Redhat 7.3.

My question is: is anyone doing this type of replication, and if you are not using pgReplicate, then what are you using?

Thank you,

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org

Nov 12 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
El Jue 23 Oct 2003 19:41, Chris M. Gamble escribió:
I am trying to perform what I best understand as Multi-master asynchronous replication for postgres 7.3.3 servers. After researching, I tried the
pgReplication project (and made the simple modification as listed in their
mailing lists), but was not able to build the environment needed for Redhat
7.3.
My question is: is anyone doing this type of replication, and if you are not

using pgReplicate, then what are you using?

1) I think the best shot should be eRServ

http://gborg.postgresql.org/project/...rojdisplay.php

2) Upgrade your DB server to 7.3.4. Your actual version has a serious bug
which can cause crashes of the system.

--
select 'mmarques' || '@' || 'unl.edu.ar' AS email;
-----------------------------------------------------------------
Martín Marqués | mm******@unl.edu.ar
Programador, Administrador, DBA | Centro de Telemática
Universidad Nacional
del Litoral
-----------------------------------------------------------------
---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org

Nov 12 '05 #2

P: n/a
On Thu, Oct 23, 2003 at 07:53:08PM -0300, Martin Marques wrote:
El Jue 23 Oct 2003 19:41, Chris M. Gamble escribi?:
I am trying to perform what I best understand as Multi-master asynchronous replication for postgres 7.3.3 servers. After researching, I tried the

1) I think the best shot should be eRServ


It most certainly would not. Erserver is good for exactly one thing
(and some people think it isn't good at this): single-master,
possibly-multi-slave asynchronous replication. Given its current
design, it will _never_ be able to do multi-master replication unless
it is "data merge" sort of stuff (e.g. table1 and table 2 on db1;
table 3 and table 4 on db2; and table1, table 2, table3, and table4
on db3).

A

--
----
Andrew Sullivan 204-4141 Yonge Street
Afilias Canada Toronto, Ontario Canada
<an****@libertyrms.info> M2P 2A8
+1 416 646 3304 x110
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match

Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.