There are two problems with the SQL created by pgAdmin: - multi statement (two or more SQLs per 1 line)
- OID depending query (WHERE oid = 16389) When you issue the query "manualy" (I regard this you run query through psql), at least multi statement problem goes away, since psql breaks the multi statement into two individual queries. -- Tatsuo Ishii SRA OSS, Inc. Japan > this may or may not be related with my previous posting about > replication stopped working. > > i'm using pgpool-II latest version (2.2.5), the configuration > > for basic tests, replication seems to work fine, but trying to connect > using pg_admin i get: > > > ERROR: pid 13594: read_kind_from_backend: 1 th kind C does not match > with master or majority connection kind D > > ERROR: 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 oid = 16389 > > > this happens even immediately after dumping from primary to secondary > node. > > > but when I run this qury manually, it works fine. > > > my configuration : > > > diff pgpool.conf.sample pgpool.conf: > > > < listen_addresses = 'localhost' > --- > > listen_addresses = '*' > 10c10 > < port = 9999 > --- > > port = 5432 > 63c63 > < replication_mode = false > --- > > replication_mode = true > 169,176c169,177 > < #backend_hostname0 = 'host1' > < #backend_port0 = 5432 > < #backend_weight0 = 1 > < #backend_data_directory0 = '/data' > < #backend_hostname1 = 'host2' > < #backend_port1 = 5433 > < #backend_weight1 = 1 > < #backend_data_directory1 = '/data1' > > -- > > backend_hostname0 = 'localhost' > > backend_port0 = 9999 > > backend_weight0 = 1 > > backend_data_directory0 = '/var/lib/pgsql/data' > > > > backend_hostname1 = '173.1.117.106' > > backend_port1 = 5432 > > backend_weight1 = 1 > > backend_data_directory1 = '/var/lib/pgsql/data' > 183c184 > < enable_pool_hba = false > --- > > enable_pool_hba = true > > -- > Asaf Ohaion > Lingnu Open Source Consulting Ltd > 09-7655871 (204), 0502-565023 > http://www.lingnu.com > > > _______________________________________________ > Pgpool-general mailing list > Pgpool-general@pgfoundry.org > http://pgfoundry.org/mailman/listinfo/pgpool-general _______________________________________________ Pgpool-general mailing list Pgpool-general@pgfoundry.org http://pgfoundry.org/mailman/listinfo/pgpool-general