|
Hi, Il 09/02/11 17:53, CS DBA ha scritto: One of the main considerations per Hot Standby vs SLONY is replication scope. With Hot Standby you get everything that occurs in the cluster, across all databases.Yep, I agree with you Kevin regarding the replication scope. I assumed that Jai was looking for a full replica of the server. database. So, IMHO I'd go with Hot Standby if I wanted to replicate the full cluster and SLONY if I wanted to "slice & dice" tables and target slaves (i.e. replicate all tables for a single db to slave 1, only 50 tables to slave 2, etc...)If you are looking for table level replication, I suggest also too look at Londiste and Skytools. Ciao, Gabriele -- Gabriele Bartolini - 2ndQuadrant Italia PostgreSQL Training, Services and Support gabriele.bartolini@xxxxxxxxxxxxxx | www.2ndQuadrant.it |
