[pgpool-general: 5367] Re: Abnormal status

Tatsuo Ishii ishii at sraoss.co.jp
Wed Mar 15 08:25:33 JST 2017


It is possible that Pgpool-II server is looking into the old status
file ("pgpool_status"). After stopping Pgpool-II server, remove the
file and restart Pgpool-II. The location of pgpool_status varies to
the installation. I'm not familiar with Pgpool-II debian package, but
you could find the location by looking at "logdir" directive in the
pgpool.conf. If logdir is not found in pgpool.conf, try to locate it
by using "pgpool show logdir".

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

> Hi there,
> I installed pgpool-II 3.6.1 by debian package from postgres repository. I
> copied configuration from old installation from source on other debian
> server.
> A the moment I don't understand the status of my pool:
> 
>  node_id |        hostname         | port  | status | lb_weight |  role   |
> select_cnt | load_balance_node | replication_delay
> ---------+-------------------------+-------+--------+-----------+---------+------------+-------------------+-------------------
>  0       | citrix2.redevogames.com | 15004 | up     | 0.250000  | primary |
> 15         | true              | 0
>  1       | 10.0.0.3                | 5997  | unused | 0.750000  | standby |
> 0          | false             | 0
> 
> 
> 
> This is my configurationç
> 
> backend_hostname0 = 'citrix2.redevogames.com'
> backend_port0 = 15004
> backend_weight0 = 0.25
> backend_data_directory0 = '/opt/postgres/dataclusters/redevodb_test'
> backend_flag0 = 'ALLOW_TO_FAILOVER'
> 
> backend_hostname1 = '10.0.0.3'
> backend_port1 = 5997
> backend_weight1 = 0.75
> backend_data_directory1 = '/opt/postgres/dataclusters/redevodb'
> backend_flag1 = 'ALLOW_TO_FAILOVER'
> 
> #------------------------------------------------------------------------------
> # CONNECTION POOLING
> #------------------------------------------------------------------------------
> 
> connection_cache = on
>                                    # Activate connection pools
>                                    # (change requires restart)
> 
>                                    # Semicolon separated list of queries
>                                    # to be issued at the end of a session
>                                    # The default is for 8.3 and later
> reset_query_list = 'ABORT; DISCARD ALL'
>                                    # The following one is for 8.2 and before
> #reset_query_list = 'ABORT; RESET ALL; SET SESSION AUTHORIZATION DEFAULT'
> 
> 
> #------------------------------------------------------------------------------
> # REPLICATION MODE
> #------------------------------------------------------------------------------
> 
> replication_mode = off
>                                    # Activate replication mode
>                                    # (change requires restart)
> replicate_select = off
>                                    # Replicate SELECT statements
>                                    # when in replication mode
>                                    # replicate_select is higher priority
> than
>                                    # load_balance_mode.
> 
> insert_lock = on
>                                    # Automatically locks a dummy row or a
> table
>                                    # with INSERT statements to keep SERIAL
> data
>                                    # consistency
>                                    # Without SERIAL, no lock will be issued
> lobj_lock_table = ''
>                                    # When rewriting lo_creat command in
>                                    # replication mode, specify table name to
>                                    # lock
> 
> # - Degenerate handling -
> 
> replication_stop_on_mismatch = off
>                                    # On disagreement with the packet kind
>                                    # sent from backend, degenerate the node
>                                    # which is most likely "minority"
>                                    # If off, just force to exit this session
> 
> failover_if_affected_tuples_mismatch = off
>                                    # On disagreement with the number of
> affected
>                                    # tuples in UPDATE/DELETE queries, then
>                                    # degenerate the node which is most
> likely
>                                    # "minority".
>                                    # If off, just abort the transaction to
>                                    # keep the consistency
> 
> #------------------------------------------------------------------------------
> # LOAD BALANCING MODE
> #------------------------------------------------------------------------------
> 
> load_balance_mode = on
>                                    # Activate load balancing mode
>                                    # (change requires restart)
> ignore_leading_white_space = on
>                                    # Ignore leading white spaces of each
> query
> white_function_list = 'get.*,check.*,is.*'
>                                    # Comma separated list of function names
>                                    # that don't write to database
>                                    # Regexp are accepted
> black_function_list =
> 'nextval,setval,nextval,setval,database_control.*,add.*,buy.*,change.*,create.*,delete.*,do.*,exec.*,remove.*,send.*,set.*,update.*,generate.*'
>                                    # Comma separated list of function names
>                                    # that write to database
>                                    # Regexp are accepted
> 
> database_redirect_preference_list = ''
>                                                                    # comma
> separated list of pairs of database and node id.
>                                                                    #
> example: postgres:primary,mydb[0-4]:1,mydb[5-9]:2'
>                                                                    # valid
> for streaming replicaton mode only.
> 
> app_name_redirect_preference_list = ''
>                                                                    # comma
> separated list of pairs of app name and node id.
>                                                                    #
> example: 'psql:primary,myapp[0-4]:1,myapp[5-9]:standby'
>                                                                    # valid
> for streaming replicaton mode only.
> allow_sql_comments = off
>                                                                    # if on,
> ignore SQL comments when judging if load balance or
>                                                                    # query
> cache is possible.
>                                                                    # If
> off, SQL comments effectively prevent the judgment
>                                                                    # (pre
> 3.4 behavior).
> 
> #------------------------------------------------------------------------------
> # MASTER/SLAVE MODE
> #------------------------------------------------------------------------------
> 
> master_slave_mode = on
>                                    # Activate master/slave mode
>                                    # (change requires restart)
> master_slave_sub_mode = 'stream'
>                                    # Master/slave sub mode
>                                    # Valid values are combinations slony or
>                                    # stream. Default is slony.
>                                    # (change requires restart)
> 
> # - Streaming -
> 
> sr_check_period = 10
>                                    # Streaming replication check period
>                                    # Disabled (0) by default
> sr_check_user = 'postgres'
>                                    # Streaming replication check user
>                                    # This is necessary even if you disable
>                                    # streaming replication delay check with
>                                    # sr_check_period = 0
> 
> 
> Why my standby node are note used? Are there some errors in configuration?
> 
> Can you help me plese?
> 
> Thanks in advance.
> 
> 
> Meph


More information about the pgpool-general mailing list