[Pgpool-general] setting up replication

[Tatsuo Ishii]

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?