[Pgpool-general] need help on the pgpool architecture

[Micka]

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 <rummandba at gmail.com> 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 <mickamusset at gmail.com> 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
>> Pgpool-general at pgfoundry.org
>> http://pgfoundry.org/mailman/listinfo/pgpool-general
>>
>>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://pgfoundry.org/pipermail/pgpool-general/attachments/20110208/f75b0d06/attachment.html>