[pgpool-general: 5087] Re: Pgpool: create database is not replicated

[Tatsuo Ishii]

> Hi,
> 
> In my environment I have 3 nodes (vdiccs01, vdiccs02 and vdiccs03). I have
> installed pgpool in all nodes for testing purposes but I'm planning to use
> just the pgpool daemon runing on vdicss01.
> 
> I'm following step by step the tutorial that is available on the web:
> 
> http://www.pgpool.net/docs/latest/tutorial-en.html#replication
> 
> In the step:
> 
> createdb -p 9999 -hvdiccs01 bench_replication
> 
> I have expected that the database creation to be executed in all nodes
> because I have set to true the replication_mode = true nevertheless, the
> bench_replication is only created in node vdicss01.
> 
> I'm very new and I supose I'm not understanding perfectly the correct way
> of working of pgpool.
> 
> Any help will be welcome to understand what's happening.
> 
> Thanks a lot.

psql -p 9999 -hvdiccs01 postgres

will show what are the status of vdiccs01, vdiccs02 and vdiccs03
recognized by Pgpool-II. I guess Pgpool-II does not think vdiccs02 and
vdiccs03 are online. Also you'd better tell what version of Pgpool-II
you are using along with pgool.conf and Pgpool-II log.

Best regards,
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese:http://www.sraoss.co.jp