Re: [GENERAL] WAL and master multi-slave replication

2009-07-01 Thread Scot Kreienkamp
Marlowe; pgsql-general@postgresql.org Subject: Re: [GENERAL] WAL and master multi-slave replication Eduardo Morras escribió: > At 19:25 24/06/2009, you wrote: >> On Wed, Jun 24, 2009 at 11:22 AM, Eduardo Morras wrote: >> > Yes, there will be 3 masters recolleting data (doing up

Re: [GENERAL] WAL and master multi-slave replication

2009-06-24 Thread Scott Marlowe
On Wed, Jun 24, 2009 at 11:51 AM, Alvaro Herrera wrote: > Eduardo Morras escribió: >> At 19:25 24/06/2009, you wrote: >>> On Wed, Jun 24, 2009 at 11:22 AM, Eduardo Morras wrote: >>> > Yes, there will be 3 masters recolleting data (doing updates, inserts and >>> > deletes) for now and 5 slaves where

Re: [GENERAL] WAL and master multi-slave replication

2009-06-24 Thread Alvaro Herrera
Eduardo Morras escribió: > At 19:25 24/06/2009, you wrote: >> On Wed, Jun 24, 2009 at 11:22 AM, Eduardo Morras wrote: >> > Yes, there will be 3 masters recolleting data (doing updates, inserts and >> > deletes) for now and 5 slaves where we will do the searches. The >> slaves must >> > have all th

Re: [GENERAL] WAL and master multi-slave replication

2009-06-24 Thread Eduardo Morras
At 19:25 24/06/2009, you wrote: On Wed, Jun 24, 2009 at 11:22 AM, Eduardo Morras wrote: > Yes, there will be 3 masters recolleting data (doing updates, inserts and > deletes) for now and 5 slaves where we will do the searches. The slaves must > have all the data recollected by the 3 masters and

Re: [GENERAL] WAL and master multi-slave replication

2009-06-24 Thread Scott Marlowe
On Wed, Jun 24, 2009 at 11:22 AM, Eduardo Morras wrote: > Yes, there will be 3 masters recolleting data (doing updates, inserts and > deletes) for now and 5 slaves where we will do the searches. The slaves must > have all the data recollected by the 3 masters and the system must be easily > upgrada

Re: [GENERAL] WAL and master multi-slave replication

2009-06-24 Thread Eduardo Morras
At 19:05 24/06/2009, Alvaro Herrera wrote: Eduardo Morras wrote: Hi, > I'm currently building a Pg multiserver and have a question about the > possibility of working with WAL in a multislave environment. > > I have few master servers (write only) and multiple slave servers (read > only). I want

Re: [GENERAL] WAL and master multi-slave replication

2009-06-24 Thread Alvaro Herrera
Eduardo Morras wrote: Hi, > I'm currently building a Pg multiserver and have a question about the > possibility of working with WAL in a multislave environment. > > I have few master servers (write only) and multiple slave servers (read > only). I want to write the WAL files from masters in a c

[GENERAL] WAL and master multi-slave replication

2009-06-24 Thread Eduardo Morras
Hello: I'm currently building a Pg multiserver and have a question about the possibility of working with WAL in a multislave environment. I have few master servers (write only) and multiple slave servers (read only). I want to write the WAL files from masters in a central postgres and th