Обсуждение: Desperate help needed for Replication

I am trying to perform what I best understand as Multi-master asynchronous replication for postgres 7.3.3 servers.
Afterresearching, 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,

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/erserver/projdisplay.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                  |        mmarques@unl.edu.ar
Programador, Administrador, DBA |       Centro de Telemática
                       Universidad Nacional
                            del Litoral
-----------------------------------------------------------------

Isnt the erserv project limited to Read-only slave stations?

    When I looked at it, it did not seem to indicate that I could make an update on any of the postgres servers and
havethat update replicated to all others. It looked as though I could only update at 1 server. 

> 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/erserver/projdisplay.php
>
> 2) Upgrade your DB server to 7.3.4. Your actual version has a serious bug
> which can cause crashes of the system.
>
>

Yes, just saw that about the multi-master. It's in the feature request list.
Anyway, it's the best replication I've got my hands on. Else, you might have
to buy some commercial Replication aplicaction, but I don't know which would
be suitable for you're needs.

El Jue 23 Oct 2003 19:55, Chris M. Gamble escribió:
> Isnt the erserv project limited to Read-only slave stations?
>
>     When I looked at it, it did not seem to indicate that I could make an
update on any of the postgres servers and have that update replicated to all
others. It looked as though I could only update at 1 server.
>
> > 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/erserver/projdisplay.php
> >
> > 2) Upgrade your DB server to 7.3.4. Your actual version has a serious bug
> > which can cause crashes of the system.
> >
> >
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
>

--
select 'mmarques' || '@' || 'unl.edu.ar' AS email;
-----------------------------------------------------------------
Martín Marqués                  |        mmarques@unl.edu.ar
Programador, Administrador, DBA |       Centro de Telemática
                       Universidad Nacional
                            del Litoral
-----------------------------------------------------------------

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
<andrew@libertyrms.info>                              M2P 2A8
                                         +1 416 646 3304 x110

On Thu, Oct 23, 2003 at 05:55:10PM -0500, Chris M. Gamble wrote:
>     update replicated to all others. It looked as though I could
>     only update at 1 server.

That's right.  At the moment, AFAIK, nobody can offer what you want,
although I have heard suggestions otherwise.  The distance that IK
travels is limited :-/

A
--
----
Andrew Sullivan                         204-4141 Yonge Street
Afilias Canada                        Toronto, Ontario Canada
<andrew@libertyrms.info>                              M2P 2A8
                                         +1 416 646 3304 x110