On Thu, Jan 20, 2011 at 1:49 AM, Gregory Machin <gdm@linuxpro.co.za> wrote:
> In short how can I get "Hot standby" / master-master replication that
> will be transparent to the changes made by Silver Stripe, that will
> work with Postgresql 8.4.4.
>
The only replication system I know of that does not need to be aware
of the schema structure (and therefore must be aware of changes made
to it) is the hot standby built into postgres. However, that does not
get you master/master which you seem to want.
I do not think your set of requirements can all be fulfilled. You
will have to adjust one or more of them. I'll venture to say that the
best target is to adjust the ORM's "update" process to be aware of
your replication strategy, and work with it rather than assume it has
full control over the DB.