Re: [mail] Re: [HACKERS] Update on replication

2002-12-18 Thread Al Sutton
nd" <[EMAIL PROTECTED]> Cc: "Alvaro Herrera" <[EMAIL PROTECTED]>; "Marc G. Fournier" <[EMAIL PROTECTED]>; "Tatsuo Ishii" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>; "PostgresSQL Hackers Mailing List" <[EMAIL PROTECTED]> Sent

Re: [HACKERS] Update on replication

2002-12-17 Thread Bruce Momjian
Neil Conway wrote: > On Tue, 2002-12-17 at 22:00, Bruce Momjian wrote: > > I think gborg allows us to collect all relivant projects in one place. > > Yes, but so would a webpage with a list of URLs, or a > freshmeat/google/dmoz directory, or an SF foundry, or [ any number of > other mechanisms for

Re: [HACKERS] Update on replication

2002-12-17 Thread Greg Copeland
On Tue, 2002-12-17 at 20:55, Neil Conway wrote: > On Tue, 2002-12-17 at 21:33, Greg Copeland wrote: > > I do agree, GBorg needs MUCH higher visibility! > > I'm just curious: why do we need GBorg at all? Does it offer anything > that SourceForge, or a similar service does not offer? > > Especially

Re: [HACKERS] Update on replication

2002-12-17 Thread Neil Conway
On Tue, 2002-12-17 at 22:00, Bruce Momjian wrote: > I think gborg allows us to collect all relivant projects in one place. Yes, but so would a webpage with a list of URLs, or a freshmeat/google/dmoz directory, or an SF foundry, or [ any number of other mechanisms for collecting groups of related w

Re: [HACKERS] Update on replication

2002-12-17 Thread Bruce Momjian
Neil Conway wrote: > On Tue, 2002-12-17 at 21:33, Greg Copeland wrote: > > I do agree, GBorg needs MUCH higher visibility! > > I'm just curious: why do we need GBorg at all? Does it offer anything > that SourceForge, or a similar service does not offer? > > Especially given that (a) most other OS

Re: [HACKERS] Update on replication

2002-12-17 Thread Neil Conway
On Tue, 2002-12-17 at 21:33, Greg Copeland wrote: > I do agree, GBorg needs MUCH higher visibility! I'm just curious: why do we need GBorg at all? Does it offer anything that SourceForge, or a similar service does not offer? Especially given that (a) most other OSS projects don't have a site for

Re: [HACKERS] Update on replication

2002-12-17 Thread Christopher Kings-Lynne
> There are a couple of links to it from PostgreSQL's site, but you sorta > have to look and hunt around. I've requested higher visibility but for > whatever reason it seemed to be snubbed rather quickly. > > I do agree, GBorg needs MUCH higher visibility! Yes - I would love to move phpPgAdmin ba

Re: [HACKERS] Update on replication

2002-12-17 Thread Marc G. Fournier
On Tue, 17 Dec 2002, Greg Copeland wrote: > There are a couple of links to it from PostgreSQL's site, but you sorta > have to look and hunt around. I've requested higher visibility but for > whatever reason it seemed to be snubbed rather quickly. > > I do agree, GBorg needs MUCH higher visibility

Re: [HACKERS] Update on replication

2002-12-17 Thread Greg Copeland
On Tue, 2002-12-17 at 20:07, Alvaro Herrera wrote: > On Tue, Dec 17, 2002 at 07:43:05PM -0600, Greg Copeland wrote: > > On Tue, 2002-12-17 at 19:38, Marc G. Fournier wrote: > > > > How come these solutions are such well kept secrets? I've heard of > > > neither in relation to past discussions abo

Re: [HACKERS] Update on replication

2002-12-17 Thread Marc G. Fournier
On Wed, 18 Dec 2002, Tatsuo Ishii wrote: > > > Glad to hear that. Usogres was developed in Japan and pretty popular > > > ammong Japanese PostgreSQL community. > > > > > > BTW, there is a commercial product called QueryMaster, which takes > > > similar approach to Usogres. It copies the input quer

Re: [HACKERS] Update on replication

2002-12-17 Thread Alvaro Herrera
On Tue, Dec 17, 2002 at 07:43:05PM -0600, Greg Copeland wrote: > On Tue, 2002-12-17 at 19:38, Marc G. Fournier wrote: > > How come these solutions are such well kept secrets? I've heard of > > neither in relation to past discussions about replication, or have I just > > missed them? :( > > Good

Re: [HACKERS] Update on replication

2002-12-17 Thread Tatsuo Ishii
> > Glad to hear that. Usogres was developed in Japan and pretty popular > > ammong Japanese PostgreSQL community. > > > > BTW, there is a commercial product called QueryMaster, which takes > > similar approach to Usogres. It copies the input query and distribute > > to multiple PostgreSQL servers.

Re: [HACKERS] Update on replication

2002-12-17 Thread Bruce Momjian
Marc G. Fournier wrote: > Just checked on Usogres, and it appears to be relatively up to date, in > that it is known to work up to 7.2.1: > > http://usogres.good-day.net/working.php3 > > Searching Google for QueryMaster finds a few Japanese sites, but I can't > read Japanese :( > >

Re: [HACKERS] Update on replication

2002-12-17 Thread Marc G. Fournier
On Tue, 17 Dec 2002, Greg Copeland wrote: > On Tue, 2002-12-17 at 19:38, Marc G. Fournier wrote: > > On Wed, 18 Dec 2002, Tatsuo Ishii wrote: > > > > > > I just got my copy of SysAdmin Magazine and was surprised to see an > > > > article about Usogres -- The PostgreSQL Replication Tool. > > > > >

Re: [HACKERS] Update on replication

2002-12-17 Thread Greg Copeland
On Tue, 2002-12-17 at 19:38, Marc G. Fournier wrote: > On Wed, 18 Dec 2002, Tatsuo Ishii wrote: > > > > I just got my copy of SysAdmin Magazine and was surprised to see an > > > article about Usogres -- The PostgreSQL Replication Tool. > > > > > > I don't remember seeing it mentioned on this or th

Re: [HACKERS] Update on replication

2002-12-17 Thread Marc G. Fournier
On Wed, 18 Dec 2002, Tatsuo Ishii wrote: > > I just got my copy of SysAdmin Magazine and was surprised to see an > > article about Usogres -- The PostgreSQL Replication Tool. > > > > I don't remember seeing it mentioned on this or the General list. Though > > I just started reading the article an

Re: [HACKERS] Update on replication

2002-12-17 Thread Tatsuo Ishii
> I just got my copy of SysAdmin Magazine and was surprised to see an > article about Usogres -- The PostgreSQL Replication Tool. > > I don't remember seeing it mentioned on this or the General list. Though > I just started reading the article and don't have a firm grasp on it yet, > I do remem

Re: [HACKERS] Update on replication

2002-12-17 Thread Tatsuo Ishii
> Marc G. Fournier wrote: > > On Tue, 17 Dec 2002, Alvaro Herrera wrote: > > > > > What about asynchronous (triggered?) replication? Is something like > > > rserv or dbmirror going to be moved to main? > > > > From what I've been able to tell *so far*, Postgres-R is going to preclude > > the abi

Re: [HACKERS] Update on replication

2002-12-17 Thread Marc G. Fournier
On Tue, 17 Dec 2002, Bruce Momjian wrote: > I meant it would cause other solutions to be less desirable, meaning. as > you said, "affect the ability to investigate other solutions?" With a > working solution, others may be less likely to investigate because > Postgres-R will be our official solut

Re: [HACKERS] Update on replication

2002-12-17 Thread Bruce Momjian
When I said: > > > It certainly will cause problems with other replication solutions. I meant it would cause other solutions to be less desirable, meaning. as you said, "affect the ability to investigate other solutions?" With a working solution, others may be less likely to investigate because

Re: [HACKERS] Update on replication

2002-12-17 Thread Marc G. Fournier
On Tue, 17 Dec 2002, Tom Lane wrote: > "Marc G. Fournier" <[EMAIL PROTECTED]> writes: > > On Tue, 17 Dec 2002, Alvaro Herrera wrote: > >> What about asynchronous (triggered?) replication? Is something like > >> rserv or dbmirror going to be moved to main? > > >> From what I've been able to tell *

Re: [HACKERS] Update on replication

2002-12-17 Thread Tom Lane
"Marc G. Fournier" <[EMAIL PROTECTED]> writes: > On Tue, 17 Dec 2002, Alvaro Herrera wrote: >> What about asynchronous (triggered?) replication? Is something like >> rserv or dbmirror going to be moved to main? >> From what I've been able to tell *so far*, Postgres-R is going to preclude > the ab

Re: [HACKERS] Update on replication

2002-12-17 Thread darren
> Not the code, just Darren' pdf ("slide show" -:() > and discussion in hackers' list. > You might want to read this paper. Its not very long, and will give you much more insite on the postgres-r work. http://www.cs.mcgill.ca/~kemme/papers/vldb00.html Darren ---(en

Re: [HACKERS] Update on replication

2002-12-17 Thread Marc G. Fournier
ooops, sorry, that was what I meant (its been one of those days *grin*) On Tue, 17 Dec 2002, Mikheev, Vadim wrote: > > From what I've been able to tell *so far*, Postgres-R is > > going to preclude the ability for either to work ... > > Vadim is currently reviewing the code, > > Not the code, j

Re: [HACKERS] Update on replication

2002-12-17 Thread Marc G. Fournier
On Tue, 17 Dec 2002, Alvaro Herrera wrote: > What about asynchronous (triggered?) replication? Is something like > rserv or dbmirror going to be moved to main? >From what I've been able to tell *so far*, Postgres-R is going to preclude the ability for either to work ... Vadim is currently review

Re: [HACKERS] Update on replication

2002-12-17 Thread Bruce Momjian
Marc G. Fournier wrote: > On Tue, 17 Dec 2002, Alvaro Herrera wrote: > > > What about asynchronous (triggered?) replication? Is something like > > rserv or dbmirror going to be moved to main? > > From what I've been able to tell *so far*, Postgres-R is going to preclude > the ability for either

Re: [HACKERS] Update on replication

2002-12-17 Thread Bruce Momjian
Roderick A. Anderson wrote: > I just got my copy of SysAdmin Magazine and was surprised to see an > article about Usogres -- The PostgreSQL Replication Tool. > > I don't remember seeing it mentioned on this or the General list. Though > I just started reading the article and don't have a firm gr

Re: [HACKERS] Update on replication

2002-12-17 Thread Roderick A. Anderson
I just got my copy of SysAdmin Magazine and was surprised to see an article about Usogres -- The PostgreSQL Replication Tool. I don't remember seeing it mentioned on this or the General list. Though I just started reading the article and don't have a firm grasp on it yet, I do remember a discus

Re: [HACKERS] Update on replication

2002-12-17 Thread Bruce Momjian
Alvaro Herrera wrote: > On Tue, Dec 17, 2002 at 12:56:45PM -0500, Bruce Momjian wrote: > > Update on replication: > > > > We have several things happening with Postgres-R replication: > > > > o Someone is porting the 7.2-based Postgres-R code to 7.3 > > You mean 7.4devel? Sorry, right. >

Re: [HACKERS] Update on replication

2002-12-17 Thread Alvaro Herrera
On Tue, Dec 17, 2002 at 12:56:45PM -0500, Bruce Momjian wrote: > Update on replication: > > We have several things happening with Postgres-R replication: > > o Someone is porting the 7.2-based Postgres-R code to 7.3 You mean 7.4devel? > With these things moving forward, we will be in a m

Re: [HACKERS] Update on replication

2002-12-17 Thread Bruce Momjian
Rod Taylor wrote: -- Start of PGP signed section. > > o People are evaluating the Postgres-R approach and comparing > >it to more traditional 2-phase commit replication. > > Not that the Postgres-R approach can replace 2-phase commit methods. > > 2PC is still needed for support with

Re: [HACKERS] Update on replication

2002-12-17 Thread Rod Taylor
> o People are evaluating the Postgres-R approach and comparing > it to more traditional 2-phase commit replication. Not that the Postgres-R approach can replace 2-phase commit methods. 2PC is still needed for support with external transaction managers (XA drivers for JDBC). --

[HACKERS] Update on replication

2002-12-17 Thread Bruce Momjian
Update on replication: We have several things happening with Postgres-R replication: o Someone is porting the 7.2-based Postgres-R code to 7.3 o Darren and I are in discussion with the Spread folks, attempting to get a more BSD-friendly license from them o Pe