Re: [DOCS] [pgsql-advocacy] Avoiding upgrade backlash

[Theo Kramer]

On Sat, Nov 17, 2007 at 04:05:50PM -0500, Bruce Momjian wrote:
> What I have done is to move the item up to the top of our
> incompatibilities list in the release notes.  That is near zero cost for
> everyone.

It bit me when testing my code against PG 8.3. Your docs helped me see my
mistake immediately.

Thanks and Regards
Theo

---(end of broadcast)---
TIP 7: You can help support the PostgreSQL project by donating at

http://www.postgresql.org/about/donate

Re: [DOCS] High Availability, Load Balancing, and Replication Feature Matrix

[Markus Schiltknecht]

Hello Bruce,

Bruce Momjian wrote:

Uh, I think of PgCluster as multi-master, but in a way it is a hybrid
because there is a central server that gets all the queries.


Yes, PgCluster as well as Sequoia use statement based replication. 
Sequoia is also clearly a middleware (no changes to Postgres needed).


Both suffer from the limitations you describe in "statement based 
replication middleware". AFAICT Sequoia does quite well in circumventing 
those. (Heck, it even tries to masquerade differences between database 
systems, so you can keep a Postgres database in sync with a MySQL one.)


Depending on the RAIDb level you are using, Sequoia can be considered 
multi-master (RAIDb-1) or single-master (RAIDb-0). Also note that 
sequoia can run multiple controllers, thus it does not rely on one 
central server.


So, at least Sequoia is clearly a hybrid, in between your definitions of 
"statement based replication middleware" and "synchronous multi-master 
replication". Depending on how "middleware" you consider PgCluster, it's 
also a hybrid. Certainly it does statement based replication.


Regards

Markus


---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?

  http://www.postgresql.org/docs/faq