On Thu, Aug 13, 2009 at 12:02 AM, Agustin Almonte Ferrada<[email protected]> 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" _______________________________________________ Pgpool-general mailing list [email protected] http://pgfoundry.org/mailman/listinfo/pgpool-general
