On Wed, Jun 24, 2009 at 11:51 AM, Alvaro Herrera<alvherre@xxxxxxxxxxxxxxxxx> wrote: > Eduardo Morras escribió: >> At 19:25 24/06/2009, you wrote: >>> On Wed, Jun 24, 2009 at 11:22 AM, Eduardo Morras<emorras@xxxxxxxxxx> 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 >>> > upgradable, adding new masters and new slaves. >>> >>> You know you can't push WAL files from > 1 server into a slave, right? >> >> No, i didn't know that. > > I guess you don't know either that you can't query a slave while it is > on recovery (so it's only a "warm" standby, not hot). And if you bring > it up you can't afterwards continue applying more segments later. I think the OP's needs might be better met by slony or londiste and some views over the top of a bunch of tables than using PITR. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
