[Pgpool-general] pgpool + warm standby presentation

[Tatsuo Ishii]

> 2010/9/27 Emanuel Calvo Franco <postgres.arg at gmail.com>:
>> 2010/9/27 Tatsuo Ishii <ishii at sraoss.co.jp>:
>>> You should use "raw mode", which means both replication_mode and master_slave_mode are turned off. Tatsuo Ishii SRA OSS, Inc. Japan
>>
>> I'm using raw mode:

Ok, I'll look into this more.
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese: http://www.sraoss.co.jp

>> failover_command = 'touch /opt/WAL_ARCHIVE/pgsql.trigger'
>> listen_addresses = '*'
>> port = 9999
>> pcp_port = 9898
>> socket_dir = '/var/run/pgpool'
>> pcp_socket_dir = '/var/run/pgpool'
>> backend_socket_dir = '/var/run/pgpool'
>> pcp_timeout = 10
>> num_init_children = 50
>> max_pool = 4
>> child_life_time = 300
>> connection_life_time = 0
>> child_max_connections = 0
>> client_idle_limit = 0
>> authentication_timeout = 60
>> logdir = '/var/run/postgresql'
>>
>> #RAW
>> replication_mode = false
>> master_slave_mode = false
>>
>>
>> load_balance_mode = false
>> replication_stop_on_mismatch = false
>> replicate_select = false
>> reset_query_list = 'ABORT; RESET ALL; SET SESSION AUTHORIZATION DEFAULT'
>> print_timestamp = true
>>
>> connection_cache = true
>>
>> health_check_timeout = 20
>> health_check_period = 30
>> health_check_user = 'pgpool'
>> failback_command = ''
>> insert_lock = false
>> ignore_leading_white_space = true
>> log_statement = false
>> log_connections = false
>> log_hostname = false
>> parallel_mode = false
>> enable_query_cache = false
>>
>> pgpool2_hostname = 'bbdd2'
>> system_db_hostname = 'bbdd1'
>> system_db_port = 5432
>> system_db_dbname = 'pgpool'
>> system_db_schema = 'pgpool_catalog'
>> system_db_user = 'postgres'
>> system_db_password = 'postavalon'
>>
>> backend_hostname0 = 'bbdd1'
>> backend_weight0 = 1
>> backend_port0 = 5432
>> backend_hostname1 = 'bbdd2'
>> #backend_weight1 = 1
>> backend_port1 = 5432
>>
>> debug_level = 100
>>
> 
> More detailed error:
> 
> pgsql/bin/psql -p9999 -hbbdd2 -Upostgres
> psql: server closed the connection unexpectedly
>         This probably means the server terminated abnormally
>         before or while processing the request.
> 
> In the pgpool server:
> 2010-09-27 18:23:30 DEBUG: pid 23124: health_check: 0 th DB node status: 2
> 2010-09-27 18:23:30 DEBUG: pid 23124: health_check: 1 th DB node status: 2
> 2010-09-27 18:23:37 DEBUG: pid 23174: I am 23174 accept fd 6
> 2010-09-27 18:23:37 DEBUG: pid 23174: Protocol Major: 1234 Minor: 5679
> database:  user:
> 2010-09-27 18:23:37 DEBUG: pid 23174: SSLRequest from client
> 2010-09-27 18:23:37 DEBUG: pid 23174: Protocol Major: 3 Minor: 0
> database: postgres user: postgres
> 2010-09-27 18:23:37 DEBUG: pid 23174: new_connection: connecting 0 backend
> 2010-09-27 18:23:37 DEBUG: pid 23174: new_connection: connecting 1 backend
> 2010-09-27 18:23:37 ERROR: pid 23174: pool_read_kind: kind does not
> match between master(52) slot[1] (45)
> 
> pgpool2/bin/pcp_proc_info 2 bbdd2 9898 postgres xxxxx 23124
> BackendError
> 
> ps f -Cpgpool
> 23124 ?        Ss     0:00 pgpool2/bin/pgpool -n -d
> 
> 
> pgpool2/bin/pgpool --version
> pgpool-II version 3.0 (umiyameboshi)
> 
> 
> 
> 
> 
> -- 
> ,A  ,A  ,A  ,A  ,A  ,A  ,A  Emanuel Calvo Franco
> ,A  ,A  ,A  ,A  ,A  ,A  ,A  ,A  Independient DBA
> ,A  ,A  ,A  ,A  www.emanuelcalvofranco.com.ar