[Pgpool-general] Detecting reason for different data state

[Nico -telmich- Schottelius]

Hello!

We have sometimes the situation, that the data between two nodes is
inconsistent, though both are running.

pgpool detects that and issues the error

   pgpool detected difference of the number of update tuples

in the sql reply.

1) It would be nice, if one could match in pgpool if that situation happens
(inconsistent_command or similar) and see which node is detached, so we
can manually add it again.


2) I am really wondering how that happened, as the db backends are
running on port 6543, which is not reachable by the clients -> only
pgpool.

3) I am still missing the logfile feature, will it be available in 2.1b3?
Running pgpool -d 2>&1 | tee LOG is not a very good thingy.

Logging to syslog would be nice, too.


Perhaps I can get my hands on pgpool and hack it myself, if I can take
that time off.

Nico


-- 
Think about Free and Open Source Software (FOSS).
http://nico.schottelius.org/documentations/foss/the-term-foss/

PGP: BFE4 C736 ABE5 406F 8F42  F7CF B8BE F92A 9885 188C
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 189 bytes
Desc: Digital signature
Url : http://pgfoundry.org/pipermail/pgpool-general/attachments/20080513/26cf3761/attachment.bin