Re: Postgres Replication Options

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