[Pgpool-general] Sync Problem with two pgpool nodes

[Jaume Sabater]

On Thu, Aug 13, 2009 at 12:02 AM, Agustin Almonte
Ferrada<aalmonte at antica.cl> wrote:

> Hi i'm using pgpool latest version and i'm having synchronization problems
>
>   My scenario is:
>   4 servers, two for database and two acting as pgpool clients. So
>   service is balanced over two servers which acts over the two databases
>   in a redundancy configuration.
>   The problem seems to be the two instances trying to alter same
>   registers.
>   any experience about this kind of configuration? i'd really appreciate
>   any help.

You can't have two pgpool-II instances accessing the same two nodes.
Only one can be active at a given time.

Use Heartbeat to provide HA, or a similar mechanism, and share an IP
address Whether you put pgpool-II on two separated machines or in the
same ones hosting the PostgreSQL servers, that won't make a difference
but in performance (IMHO, worse to have them in two separated
machines).

-- 
Jaume Sabater
http://linuxsilo.net/

"Ubi sapientas ibi libertas"