You need to replace "osspc17" and "osspc18" part at least in pgpool.conf unless you set PostgreSQL servers's hostnanmes exactly same as in the tutorial. -- Tatsuo Ishii SRA OSS, Inc. Japan English: http://www.sraoss.co.jp/index_en.php Japanese: http://www.sraoss.co.jp
> Tatsuo Ishii <ishii@...> writes: > >> Probably pgpoolAdmin failed to start pgpool-II. >> >> > start Pgpool from there I got the error: pgpool.pid not found. >> >> Because after successfull start of pgpool-II, the file should be >> created by pgpool-II itself. >> >> Did you see any error messages in the log files (placed under >> /var/log/pgpool/ if you follow the tutorial). >> -- >> Tatsuo Ishii >> SRA OSS, Inc. Japan >> English: http://www.sraoss.co.jp/index_en.php >> Japanese: http://www.sraoss.co.jp >> > > > Hi Tatsuo, > > Thank you very much for replying. I am sending you the whole log I found under > /var/log/pgpool > > > 2011-06-23 17:11:35 DEBUG: pid 9997: key: listen_addresses > 2011-06-23 17:11:35 DEBUG: pid 9997: value: '*' kind: 4 > 2011-06-23 17:11:35 DEBUG: pid 9997: key: port > 2011-06-23 17:11:35 DEBUG: pid 9997: value: 5432 kind: 2 > 2011-06-23 17:11:35 DEBUG: pid 9997: key: pcp_port > 2011-06-23 17:11:35 DEBUG: pid 9997: value: 9898 kind: 2 > 2011-06-23 17:11:35 DEBUG: pid 9997: key: socket_dir > 2011-06-23 17:11:35 DEBUG: pid 9997: value: '/tmp' kind: 4 > 2011-06-23 17:11:35 DEBUG: pid 9997: key: pcp_socket_dir > 2011-06-23 17:11:35 DEBUG: pid 9997: value: '/tmp' kind: 4 > 2011-06-23 17:11:35 DEBUG: pid 9997: key: backend_socket_dir > 2011-06-23 17:11:35 DEBUG: pid 9997: value: '/tmp' kind: 4 > 2011-06-23 17:11:35 DEBUG: pid 9997: key: pcp_timeout > 2011-06-23 17:11:35 DEBUG: pid 9997: value: 10 kind: 2 > 2011-06-23 17:11:35 DEBUG: pid 9997: key: num_init_children > 2011-06-23 17:11:35 DEBUG: pid 9997: value: 32 kind: 2 > 2011-06-23 17:11:35 DEBUG: pid 9997: key: max_pool > 2011-06-23 17:11:35 DEBUG: pid 9997: value: 4 kind: 2 > 2011-06-23 17:11:35 DEBUG: pid 9997: key: child_life_time > 2011-06-23 17:11:35 DEBUG: pid 9997: value: 300 kind: 2 > 2011-06-23 17:11:35 DEBUG: pid 9997: key: connection_life_time > 2011-06-23 17:11:35 DEBUG: pid 9997: value: 0 kind: 2 > 2011-06-23 17:11:35 DEBUG: pid 9997: key: child_max_connections > 2011-06-23 17:11:35 DEBUG: pid 9997: value: 0 kind: 2 > 2011-06-23 17:11:35 DEBUG: pid 9997: key: client_idle_limit > 2011-06-23 17:11:35 DEBUG: pid 9997: value: 0 kind: 2 > 2011-06-23 17:11:35 DEBUG: pid 9997: key: authentication_timeout > 2011-06-23 17:11:35 DEBUG: pid 9997: value: 60 kind: 2 > 2011-06-23 17:11:35 DEBUG: pid 9997: key: logdir > 2011-06-23 17:11:35 DEBUG: pid 9997: value: '/tmp' kind: 4 > 2011-06-23 17:11:35 DEBUG: pid 9997: key: pid_file_name > 2011-06-23 17:11:35 DEBUG: pid 9997: value: '/var/run/pgpool/pgpool.pid' > kind: 4 > 2011-06-23 17:11:35 DEBUG: pid 9997: key: replication_mode > 2011-06-23 17:11:35 DEBUG: pid 9997: value: false kind: 1 > 2011-06-23 17:11:35 DEBUG: pid 9997: key: load_balance_mode > 2011-06-23 17:11:35 DEBUG: pid 9997: value: true kind: 1 > 2011-06-23 17:11:35 DEBUG: pid 9997: key: replication_stop_on_mismatch > 2011-06-23 17:11:35 DEBUG: pid 9997: value: false kind: 1 > 2011-06-23 17:11:35 DEBUG: pid 9997: replication_stop_on_mismatch: 0 > 2011-06-23 17:11:35 DEBUG: pid 9997: key: failover_if_affected_tuples_mismatch > 2011-06-23 17:11:35 DEBUG: pid 9997: value: false kind: 1 > 2011-06-23 17:11:35 DEBUG: pid 9997: failover_if_affected_tuples_mismatch: 0 > 2011-06-23 17:11:35 DEBUG: pid 9997: key: replicate_select > 2011-06-23 17:11:35 DEBUG: pid 9997: value: false kind: 1 > 2011-06-23 17:11:35 DEBUG: pid 9997: replicate_select: 0 > 2011-06-23 17:11:35 DEBUG: pid 9997: key: reset_query_list > 2011-06-23 17:11:35 DEBUG: pid 9997: value: 'ABORT; DISCARD ALL' kind: 4 > 2011-06-23 17:11:35 DEBUG: pid 9997: extract_string_tokens: token: ABORT > 2011-06-23 17:11:35 DEBUG: pid 9997: extract_string_tokens: token: DISCARD > ALL > 2011-06-23 17:11:35 DEBUG: pid 9997: key: white_function_list > 2011-06-23 17:11:35 DEBUG: pid 9997: value: '' kind: 4 > 2011-06-23 17:11:35 DEBUG: pid 9997: key: black_function_list > 2011-06-23 17:11:35 DEBUG: pid 9997: value: 'nextval,setval' kind: 4 > 2011-06-23 17:11:35 DEBUG: pid 9997: extract_string_tokens: token: nextval > 2011-06-23 17:11:35 DEBUG: pid 9997: extract_string_tokens: token: setval > 2011-06-23 17:11:35 DEBUG: pid 9997: key: print_timestamp > 2011-06-23 17:11:35 DEBUG: pid 9997: value: true kind: 1 > 2011-06-23 17:11:35 DEBUG: pid 9997: key: master_slave_mode > 2011-06-23 17:11:35 DEBUG: pid 9997: value: true kind: 1 > 2011-06-23 17:11:35 DEBUG: pid 9997: key: master_slave_sub_mode > 2011-06-23 17:11:35 DEBUG: pid 9997: value: 'stream' kind: 4 > 2011-06-23 17:11:35 DEBUG: pid 9997: key: delay_threshold > 2011-06-23 17:11:35 DEBUG: pid 9997: value: 10000000 kind: 2 > 2011-06-23 17:11:35 DEBUG: pid 9997: key: log_standby_delay > 2011-06-23 17:11:35 DEBUG: pid 9997: value: 'if_over_threshold' kind: 4 > 2011-06-23 17:11:35 DEBUG: pid 9997: key: connection_cache > 2011-06-23 17:11:35 DEBUG: pid 9997: value: true kind: 1 > 2011-06-23 17:11:35 DEBUG: pid 9997: key: health_check_timeout > 2011-06-23 17:11:35 DEBUG: pid 9997: value: 10 kind: 2 > 2011-06-23 17:11:35 DEBUG: pid 9997: key: health_check_period > 2011-06-23 17:11:35 DEBUG: pid 9997: value: 20 kind: 2 > 2011-06-23 17:11:35 DEBUG: pid 9997: key: health_check_user > 2011-06-23 17:11:35 DEBUG: pid 9997: value: 'postgres' kind: 4 > 2011-06-23 17:11:35 DEBUG: pid 9997: key: failover_command > 2011-06-23 17:11:35 DEBUG: pid 9997: value: '/usr/local/etc/failover.sh %d > "%h" > %p %D %m %M "%H" %P' kind: 4 > 2011-06-23 17:11:35 DEBUG: pid 9997: key: failback_command > 2011-06-23 17:11:35 DEBUG: pid 9997: value: '' kind: 4 > 2011-06-23 17:11:35 DEBUG: pid 9997: key: fail_over_on_backend_error > 2011-06-23 17:11:35 DEBUG: pid 9997: value: true kind: 1 > 2011-06-23 17:11:35 DEBUG: pid 9997: key: insert_lock > 2011-06-23 17:11:35 DEBUG: pid 9997: value: false kind: 1 > 2011-06-23 17:11:35 DEBUG: pid 9997: key: ignore_leading_white_space > 2011-06-23 17:11:35 DEBUG: pid 9997: value: true kind: 1 > 2011-06-23 17:11:35 DEBUG: pid 9997: key: log_statement > 2011-06-23 17:11:35 DEBUG: pid 9997: value: false kind: 1 > 2011-06-23 17:11:35 DEBUG: pid 9997: key: log_per_node_statement > 2011-06-23 17:11:35 DEBUG: pid 9997: value: false kind: 1 > 2011-06-23 17:11:35 DEBUG: pid 9997: key: log_connections > 2011-06-23 17:11:35 DEBUG: pid 9997: value: false kind: 1 > 2011-06-23 17:11:35 DEBUG: pid 9997: key: log_hostname > 2011-06-23 17:11:35 DEBUG: pid 9997: value: false kind: 1 > 2011-06-23 17:11:35 DEBUG: pid 9997: key: parallel_mode > 2011-06-23 17:11:35 DEBUG: pid 9997: value: false kind: 1 > 2011-06-23 17:11:35 DEBUG: pid 9997: key: enable_query_cache > 2011-06-23 17:11:35 DEBUG: pid 9997: value: false kind: 1 > 2011-06-23 17:11:35 DEBUG: pid 9997: key: pgpool2_hostname > 2011-06-23 17:11:35 DEBUG: pid 9997: value: '' kind: 4 > 2011-06-23 17:11:35 DEBUG: pid 9997: key: system_db_hostname > 2011-06-23 17:11:35 DEBUG: pid 9997: value: 'localhost' kind: 4 > 2011-06-23 17:11:35 DEBUG: pid 9997: key: system_db_port > 2011-06-23 17:11:35 DEBUG: pid 9997: value: 5432 kind: 2 > 2011-06-23 17:11:35 DEBUG: pid 9997: key: system_db_dbname > 2011-06-23 17:11:35 DEBUG: pid 9997: value: 'pgpool' kind: 4 > 2011-06-23 17:11:35 DEBUG: pid 9997: key: system_db_schema > 2011-06-23 17:11:35 DEBUG: pid 9997: value: 'pgpool_catalog' kind: 4 > 2011-06-23 17:11:35 DEBUG: pid 9997: key: system_db_user > 2011-06-23 17:11:35 DEBUG: pid 9997: value: 'pgpool' kind: 4 > 2011-06-23 17:11:35 DEBUG: pid 9997: key: system_db_password > 2011-06-23 17:11:35 DEBUG: pid 9997: value: '' kind: 4 > 2011-06-23 17:11:35 DEBUG: pid 9997: key: backend_hostname0 > 2011-06-23 17:11:35 DEBUG: pid 9997: value: 'osspc17' kind: 4 > 2011-06-23 17:11:35 DEBUG: pid 9997: key: backend_port0 > 2011-06-23 17:11:35 DEBUG: pid 9997: value: 5432 kind: 2 > 2011-06-23 17:11:35 DEBUG: pid 9997: pool_config: port slot number 0 > 2011-06-23 17:11:35 DEBUG: pid 9997: key: backend_weight0 > 2011-06-23 17:11:35 DEBUG: pid 9997: value: 1 kind: 2 > 2011-06-23 17:11:35 DEBUG: pid 9997: pool_config: weight slot number 0 weight: > 1.000000 > 2011-06-23 17:11:35 DEBUG: pid 9997: key: backend_data_directory0 > 2011-06-23 17:11:35 DEBUG: pid 9997: value: '/home/postgres/data' kind: 4 > 2011-06-23 17:11:35 DEBUG: pid 9997: key: backend_hostname1 > 2011-06-23 17:11:35 DEBUG: pid 9997: value: 'osspc18' kind: 4 > 2011-06-23 17:11:35 DEBUG: pid 9997: key: backend_port1 > 2011-06-23 17:11:35 DEBUG: pid 9997: value: 5432 kind: 2 > 2011-06-23 17:11:35 DEBUG: pid 9997: pool_config: port slot number 1 > 2011-06-23 17:11:35 DEBUG: pid 9997: key: backend_weight1 > 2011-06-23 17:11:35 DEBUG: pid 9997: value: 1 kind: 2 > 2011-06-23 17:11:35 DEBUG: pid 9997: pool_config: weight slot number 1 weight: > 1.000000 > 2011-06-23 17:11:35 DEBUG: pid 9997: key: backend_data_directory1 > 2011-06-23 17:11:35 DEBUG: pid 9997: value: '/home/postgres/data' kind: 4 > 2011-06-23 17:11:35 DEBUG: pid 9997: key: enable_pool_hba > 2011-06-23 17:11:35 DEBUG: pid 9997: value: false kind: 1 > 2011-06-23 17:11:35 DEBUG: pid 9997: key: recovery_user > 2011-06-23 17:11:35 DEBUG: pid 9997: value: 'postgres' kind: 4 > 2011-06-23 17:11:35 DEBUG: pid 9997: key: recovery_password > 2011-06-23 17:11:35 DEBUG: pid 9997: value: '' kind: 4 > 2011-06-23 17:11:35 DEBUG: pid 9997: key: recovery_1st_stage_command > 2011-06-23 17:11:35 DEBUG: pid 9997: value: 'basebackup.sh' kind: 4 > 2011-06-23 17:11:35 DEBUG: pid 9997: key: recovery_2nd_stage_command > 2011-06-23 17:11:35 DEBUG: pid 9997: value: '' kind: 4 > 2011-06-23 17:11:35 DEBUG: pid 9997: key: recovery_timeout > 2011-06-23 17:11:35 DEBUG: pid 9997: value: 90 kind: 2 > 2011-06-23 17:11:35 DEBUG: pid 9997: key: client_idle_limit_in_recovery > 2011-06-23 17:11:35 DEBUG: pid 9997: value: 0 kind: 2 > 2011-06-23 17:11:35 DEBUG: pid 9997: key: lobj_lock_table > 2011-06-23 17:11:35 DEBUG: pid 9997: value: '' kind: 4 > 2011-06-23 17:11:35 DEBUG: pid 9997: key: ssl > 2011-06-23 17:11:35 DEBUG: pid 9997: value: false kind: 1 > 2011-06-23 17:11:35 DEBUG: pid 9997: key: debug_level > 2011-06-23 17:11:35 DEBUG: pid 9997: value: 0 kind: 2 > 2011-06-23 17:11:35 ERROR: pid 9997: bind(0.0.0.0:postgres) failed. reason: > Address already in use > 2011-06-23 17:11:35 ERROR: pid 9997: unlink() failed: No such file or > directory > 2011-06-23 17:11:35 DEBUG: pid 9997: shmem_exit(1) > > > > I can see that at some point, it uses a path named "/home/postgres/data" > which > does not correspond to my local path. That is changed as far as the other > nodes > goes, in the Conf file. So I have no idea where that path is coming from. > > Also, the .PID file continues to be unaccessible for pgpool. I have to create > it > myself, and yet Pgpool is unable to read it sometimes. I can't even stop it > from > the console sometimes: > > 2011-06-28 11:31:34 ERROR: pid 30323: could not read pid file as > /var/run/pgpool/pgpool.pid. reason: Success > 2011-06-28 11:31:34 ERROR: pid 30323: could not read pid file > [root@ip-10-72-79-0 pgpool]# pgpool stop > 2011-06-28 11:31:44 ERROR: pid 30326: could not read pid file as > /var/run/pgpool/pgpool.pid. reason: Success > 2011-06-28 11:31:44 ERROR: pid 30326: could not read pid file > > > I appreciate your help on this matter. Thanks a lot! > > _______________________________________________ > Pgpool-general mailing list > [email protected] > http://pgfoundry.org/mailman/listinfo/pgpool-general _______________________________________________ Pgpool-general mailing list [email protected] http://pgfoundry.org/mailman/listinfo/pgpool-general
