[pgpool-general: 5799] Why are SQL statements not logged?

[rainer at ultra-secure.de]

Hi,

I run

pgpool-II-96-3.6.3-1.rhel7.x86_64

on CentOS 7.4


I have the following configuration:

pid_file_name = '/var/run/pgpool-II-96/pgpool.pid'


listen_addresses = '*'
port = 5432
socket_dir = '/tmp'

pcp_listen_addresses = '*'
pcp_port = 9898
pcp_socket_dir = '/tmp'

backend_hostname0 = 'ip.a'
backend_hostname1 = 'ip.b'
backend_weight1 = '1'
backend_weight0 = '1'
backend_backend_flag0 = 'ALLOW_TO_FAILOVER'
backend_backend_flag1 = 'ALLOW_TO_FAILOVER'
backend_port0 = '5432'
backend_port1 = '5432'

replication_mode = off

load_balance_mode = on

master_slave_mode = on
master_slave_sub_mode = 'stream'

num_init_children = 601
sr_check_period = 10
sr_check_user = ***********
sr_check_password = ***********
sr_check_database = *************
delay_threshold = 5
log_standby_delay = if_over_threshold
log_destination = 'syslog,stderr'
log_line_prefix = '%t: pid %p: '
log_connections = on
log_hostname = off
log_statement = on
log_per_node_statement = on
syslog_facility = 'LOCAL0'
syslog_ident = 'pgpool'
log_error_verbosity = verbose
client_min_messages = log
log_min_messages = debug5



This is in rsyslog.conf:

local0.*						/var/log/pgpool.log


I do get various debug messages in the log - but I don't see any 
SQL-statements.


I have a WebObjects application that basically complains about values in 
the DB having changed between reading and writing updated values.
This did not happen before pgpool was introduced.



Regards
Rainer