This is probably better suited for something not on pgsql-advocacy. I
will respond offlist.
Joshua D. Drake
Enrico Weigelt wrote:
> * Joshua D. Drake <jd(at)commandprompt(dot)com> wrote:
>>There is only one production and shipping replication that does not
>>require triggers that I know of and that is ours (Command Prompt).
>>It is also not a userland app but actually part of the PostgreSQL engine.
> Ah. Has pgsql to be patched for that or can it be simply dropped-in
> like external (C) functions/procedures ?
> What about lazy replication (i.e. when some node is running but not
> online for a while), masterless replication (all nodes are equal)
> or journaling ?
> My application/framework-level solves this, but
> a) requires some special table layout (first attrs have to be inode+mtime),
> b) not suited for high update-rates (relly too slow for that)
> but it is already working quite stable for several years :)
>>Each solution has pro's and cons. Slony-I for example appears to be
>>better when doing mass updates or deletes than Replicator.
> yeah, on subsequent mass-updates on just one host per table at certain time,
> my stuff is also good, since it works w/ batching. but when multiple hosts
> do heavy updates on the same table, it may run into conflicts.
>>On the argument of significant features for 7.5:
> Stupid question: whats PITR ?
> Background-Write = write-behind ?
> BTW: how stable is the current pgsql against powerfails or kill -9 ?
Command Prompt, Inc., home of Mammoth PostgreSQL - S/ODBC and S/JDBC
Postgresql support, programming shared hosting and dedicated hosting.
+1-503-667-4564 - jd(at)commandprompt(dot)com - http://www.commandprompt.com
Mammoth PostgreSQL Replicator. Integrated Replication for PostgreSQL
Description: text/x-vcard (640 bytes)
In response to
pgsql-hackers by date
|Next:||From: Tom Lane||Date: 2004-06-03 22:03:53|
|Subject: Re: [HACKERS] Configuration patch |
|Previous:||From: Bruce Momjian||Date: 2004-06-03 21:45:34|
|Subject: Re: [HACKERS] Configuration patch|
pgsql-advocacy by date
|Next:||From: Josh Berkus||Date: 2004-06-03 23:09:51|
|Subject: Re: [SQL] SQL Spec Compliance Questions|
|Previous:||From: Enrico Weigelt||Date: 2004-06-03 21:35:50|
|Subject: Re: [HACKERS] Not 7.5, but 8.0 ?|