Postgres Pro
Downloads
Home   >   mailing lists

pgpool II cancel the current transaction if one node falls - Mailing list pgsql-admin

From Loles
Subject pgpool II cancel the current transaction if one node falls
Date
Msg-id CA+FWGK7-EJCx0EOCk34eOr+x3oyi2_mM5AEZk+25Z9sF7oFVKQ@mail.gmail.com
Whole thread Raw
List pgsql-admin
Tree view
Hello:

We have a problem with pgpool II.

We have setup a replication system for PostgreSQL 9 using pgpool II with two nodes. The system is work: when we insert some record in the pool (port 9999), the data is saved in node-1 and node-2. We can also stop a node and recover it properly.

The problem is: if we stop postgres in node-2 in the middle of a transaction (an insert of 1000 records on the pool), the transaction is interrupted in all nodes. We want the transaction to complete successfully on live nodes.

Any idea?

Sorry for my english ;)

pgsql-admin by date:

Previous
From: Henrique Teófilo
Date:
Subject: Errors recovering database
Next
From: Vinicius Abrahao
Date:
Subject: Re: sepgsql installation troubles in Postgresql 9.1 alpha4