[pgpool-general: 5366] Abnormal status

Mephysto mephystoonhell at gmail.com
Wed Mar 15 06:47:53 JST 2017


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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20170314/f307adf6/attachment-0001.html>


More information about the pgpool-general mailing list