> Thanks to all. Now I understand better how pgpool works. > Now I've been able to made some successful test. Replication Mode is > working perfectly. > The problem now is a little bit diferrent... I've just made a backup > from the postgres production database, and freshly imported in two new > databases in docsys and docsys2. > The problem is when I try any kind of connection to pgpool (in 9999 > port) I have the "kind mismatch error". > > ex: > docsys:/home/rubenalves# /usr/lib/postgresql/8.3/bin/pgbench -i -h > docsys -p 9999 imm_dbv12 -U postgres > ERROR: kind mismatch among backends. Possible last query was: "SET > search_path = public" kind details are: 0[C] 1[N] > HINT: check data consistency among db nodes > server closed the connection unexpectedly > This probably means the server terminated abnormally > before or while processing the request. > docsys:/home/rubenalves# > > I really can't understand because the both databases are IDENTICAL, how > pgpool may find some differences? > > Someone got an idea about this error?
You need to show us the log output with pgpool-II debug option "-d". Besides this, to make two databases "identical" by using pg_dump/pg_restore is not enough for pgpool-II. pgpool-II requires two database nodes "phyically identical". For this purpose you should use tar/rsync or whatever tools to make a identical copy of database. In your case probably you restore first database node by using pg_restore then copy to second one by using tar or rsync. -- Tatsuo Ishii SRA OSS, Inc. Japan _______________________________________________ Pgpool-general mailing list [email protected] http://pgfoundry.org/mailman/listinfo/pgpool-general
