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 ItaliaPostgreSQL Training, Services and Supportgabriele.bartolini@2ndQuadrant.it | www.2ndQuadrant.it