[Pgpool-general] pgpool + warm standby presentation

[Emanuel Calvo Franco]

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:
>
>
> 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)





-- 
              Emanuel Calvo Franco
                Independient DBA
        www.emanuelcalvofranco.com.ar