I would like to know if it is preferable to use postgreSQL 9 or Postgresql 8.3.8 ?
Postgresql 8.3.8 is described in the tutorial. Thanks, On Tue, Feb 8, 2011 at 1:19 PM, AI Rumman <[email protected]> wrote: > I think this may help you; > > http://airumman.blogspot.com/2011/02/postgresql-failover-with-pgpool-ii.html > > On Tue, Feb 8, 2011 at 5:27 PM, Micka <[email protected]> wrote: > >> Hi, >> >> I would like to configure a backup server for my application. >> >> I thought about that : >> >> Master Server : A Slave Server : B >> - PostgreSQL 9 A - PostgreSQL 9 B >> - PgPool A - Pgpool B >> - TomCat Application A - TomCat Application B >> >> >> Normal case: >> The application A use pgpool A to insert/update/delete data. >> database B can be used for loadbalancing. >> >> Other case: >> The server Master goes down; >> How can I detect it ? Is it possible to use PgPool B with this >> configuration : ( Server B is the master and server A is the slave ). >> I thought about that : >> >> 1. The Application B detect that the Application A is not responding. >> 2. The application B take the control, and use the Pgpool B for >> insert/delete/update data. >> 3. When the Server A goes back online, it detect that now its >> configuration is slave mode. >> 4. The Pgpool B detect that database A is online and sync the database >> B with the database A. >> >> >> Is it possible ? >> >> >> _______________________________________________ >> Pgpool-general mailing list >> [email protected] >> http://pgfoundry.org/mailman/listinfo/pgpool-general >> >> >
_______________________________________________ Pgpool-general mailing list [email protected] http://pgfoundry.org/mailman/listinfo/pgpool-general
