Re: real multi-master replication?

Stefan Kaltenbrunner <stefan(at)kaltenbrunner(dot)cc> wrote:
>
> Bill Moran wrote:
> > "hubert depesz lubaczewski" <depesz(at)gmail(dot)com> wrote:
> >> hi,
> >> i read about some replication system for postgresql, but - as far as i
> >> know there is none real multi-master replication system for
> >> postgresql.
> >> all i have seen are based on "query replication" with various "hacks"
> >> for specific constructions (like now()).
> >> my question is - is there any (even fully commercial) multi-master
> >> replication system for postgresql that will work with all possible
> >> constructs, triggers, random data and so on?
> >> i mean - i dont want to bother with choosing to 'note' somehow that
> >> 'this particular query' has to be replicated somehow.
> >> i'm thinking about working solution that will allow multi-master connections.
> >>
> >> anything? anywhere?
> >
> > Have you looked at pgpool?
>
> afaik pgpool is statement based and not really multimaster either ...

Well, it's multi-master to the degree that all servers are read/write,
and therefore any server can take over.

How would you define multi-master?

--
Bill Moran
http://www.potentialtech.com