it must be the OID issue, I tried also to initially synchronize with
pg_dumpall --oids, but that
didn't help.
what finally solved it (for the mean time), is to pg_dumpall to a file,
clearing both databases (initdb), then importing to both backends
with the same dump file.
after that procedure, pgadmin works.
(for the mean time)
Tatsuo Ishii wrote:
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
[email protected]
http://pgfoundry.org/mailman/listinfo/pgpool-general
--
Asaf Ohaion
Lingnu Open Source Consulting Ltd
09-7655871 (204), 0502-565023
http://www.lingnu.com
_______________________________________________
Pgpool-general mailing list
[email protected]
http://pgfoundry.org/mailman/listinfo/pgpool-general
