Wed Aug 27 19:19:19 PDT 2008
- Previous message: [Slony1-general] Can I perform CLUSTER on a slony DB?
- Next message: [Slony1-general] Can I perform CLUSTER on a slony DB?
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
On Mon, 2008-08-25 at 10:09 -0400, Brad Nicholson wrote: > On Mon, 2008-08-25 at 12:25 +0800, Ow Mun Heng wrote: > > Just wondering if it's possible to do a cluster on a slony replicated DB > > in either master/slave?? > > You can, with a couple of caveats. > > 1: Cluster will take an access exclusive lock the table in question and > replication will fall behind for the duration of the cluster if anything > tries to write to the table be being clustered. That's understandable. > > 2: Prior to 8.3, cluster is not MVCC safe, so it is very possible to > break things by clustering. Break as in break the replication or break PG? Hmm.. But, all in all, I can still do the cluster individually right? And not through slonik
- Previous message: [Slony1-general] Can I perform CLUSTER on a slony DB?
- Next message: [Slony1-general] Can I perform CLUSTER on a slony DB?
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
More information about the Slony1-general mailing list