Can you show me the PostgreSQL log? > 2[N]
indicates that there should be some NOTICE message from the third PostgreSQL. 0[C] 1[C] means that the first and second PostgreSQL said "we completed the query without any problem". So I need to know why the third PostgreSQL complains. -- Tatsuo Ishii SRA OSS, Inc. Japan > I am trying to setup replication and it seems to be trying to work, but > errors out when I try to connect from pgadmin. > > The error is: > 2009-04-07 18:06:59 ERROR: pid 6867: read_kind_from_backend: 2 th kind N > does not match with master or majority connection kind C > 2009-04-07 18:06:59 ERROR: pid 6867: kind mismatch among backends. > Possible last query was: "SET DateStyle=ISO;SELECT oid, > pg_encoding_to_char(encoding) AS encoding, datlastsysoid > FROM pg_database WHERE datname='postgres'" kind details are: 0[C] 1[C] > 2[N] > > It doesn't make much sense as manually running that returns: > SELECT oid, pg_encoding_to_char(encoding) AS encoding, datlastsysoid > FROM pg_database WHERE datname='postgres'; > oid | encoding | datlastsysoid > -------+----------+--------------- > 11511 | UTF8 | 11510 > (1 row) > > On all three nodes. > > The only difference between the nodes is two are Xeon 5000's and one was > purchased later and is a Quad core opteron. With the query returning the > same thing on all three nodes, I don't see how that could cause the > problem. > > The backend postgresql servers are running 8.3.7. > > Any ideas? _______________________________________________ Pgpool-general mailing list [email protected] http://pgfoundry.org/mailman/listinfo/pgpool-general
