Stefan Kaltenbrunner <stefan@xxxxxxxxxxxxxxxx> wrote: > > Bill Moran wrote: > > "hubert depesz lubaczewski" <depesz@xxxxxxxxx> 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
