Re: [GENERAL] Level of replication support?

2004-10-13 Thread Ted Shab
Here is a good overview. http://jeremy.zawodny.com/blog/archives/000846.html Note that http://pgreplicator.sourceforge.net/ is a multi-master solution using TCL. Despite the dire home page, it is "actively" supported. However, our experience with it was that it was not industrial strenght. W

Re: [GENERAL] LISTEN/NOTIFY for lightweight replication

2004-10-13 Thread Ted Shab
Thanks. I was thinking iirc was the transport protocol :-) Looks like dblink is the best bet here. --Ted --- Richard Huxton <[EMAIL PROTECTED]> wrote: > Ted Shab wrote: > > Richard, > > > > Thanks for the response. > > > > I'll look into both th

Re: [GENERAL] LISTEN/NOTIFY for lightweight replication

2004-10-13 Thread Ted Shab
Richard, Thanks for the response. I'll look into both the dblink and iirc. Do you know of any extended examples of either? --Ted --- Richard Huxton <[EMAIL PROTECTED]> wrote: > Ted Shab wrote: > > Hi, > > > > I'm trying to come up with a relativel

[GENERAL] LISTEN/NOTIFY for lightweight replication

2004-10-12 Thread Ted Shab
Hi, I'm trying to come up with a relatively simple multi-master replication solution. This is for multiple databases that need to be discreet, and change relatively infrequently (10-30 updates an hour), and almost never update each others data (less than once a day). The TCL-based replication