[Pgpool-general] pgpool-II replication - issue when connecting with pgadmin3

[Asaf]

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
>> Pgpool-general at pgfoundry.org
>> http://pgfoundry.org/mailman/listinfo/pgpool-general
>>     
>
>   


-- 
Asaf Ohaion
Lingnu Open Source Consulting Ltd
09-7655871 (204), 0502-565023
http://www.lingnu.com