[Pgpool-general] pgpool handling slaves and disconnect and reconnect

2010-03-16 Thread William King
Does pgpool 2 queue the sql statements when a slave gets disconnected? so that when it reconnects it will catch up? Or does this handle it differently? -William King ___ Pgpool-general mailing list Pgpool-general@pgfoundry.org

[Pgpool-general] multiple pgpool-ii instances

2010-03-16 Thread rocrash
Hi, some time ago we set up some pgpool-ii cluster with loadbalancing and replication. At some point at the time of evaluation we had the idea of what would happen if we're using several pgpool instances using the same database. Did someone tried this before? Would it end up in errors or would

Re: [Pgpool-general] pgpool handling slaves and disconnect and reconnect

2010-03-16 Thread Tatsuo Ishii
Does pgpool 2 queue the sql statements when a slave gets disconnected? so that when it reconnects it will catch up? No. Or does this handle it differently? You should considier online recovery in this case. See docs for more details. -- Tatsuo Ishii SRA OSS, Inc. Japan English: