Re: [ADMIN] Postgres Replication Options

2011-02-10 Thread Gabriele Bartolini
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 loo

Re: [ADMIN] Postgres Replication Options

2011-02-09 Thread CS DBA
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. With SLONY you are limited to at most a single database per "SLONY Cluster", and you can define replication sets which only contain

Re: [ADMIN] Postgres Replication Options

2011-02-08 Thread Gabriele Bartolini
Hi, Il 09/02/11 01:34, Rangi, Jai ha scritto: Hello, I am looking for a replication solution for PG 9.x. Idea is to have one master replication server and multiple (around 20) slave servers read only. I see PG 9 has inbuilt Streaming replication. Is this the best replication solution. How a

Re: [ADMIN] Postgres Replication Options

2011-02-08 Thread Rosser Schwarz
On Tue, Feb 8, 2011 at 5:34 PM, Rangi, Jai wrote: > I am looking for a replication solution for PG 9.x. Idea is to have one > master replication server and multiple (around 20) slave servers read only. I know (anecdotally) of at least one organization that's using Bucardo [1] to synchronize many

[ADMIN] Postgres Replication Options

2011-02-08 Thread Rangi, Jai
Hello, I am looking for a replication solution for PG 9.x. Idea is to have one master replication server and multiple (around 20) slave servers read only. I see PG 9 has inbuilt Streaming replication. Is this the best replication solution. How about slony? Which option will keep the slave nodes in