<!DOCTYPE html><html><head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
</head>
<body>
<p>Hi,</p>
<p>we are facing problem when we use pgpool as proxy our application
with <b><font color="#000000">autosave=always&cleanupSavepoints=true</font></b>
options in url wont start properly, it hangs immediately issuing
only <b>SAVEPOINT PGJDBC_AUTOSAVE , </b>there are no errors
around, pgpool log is attached.<br>
</p>
<p>When the application is connected directly to postgres db
(bypassing pgpool) it works.</p>
<p>My question is, can we use <b><font color="#000000">autosave </font></b>connection
parameter <a class="moz-txt-link-freetext" href="https://jdbc.postgresql.org/documentation/use/">https://jdbc.postgresql.org/documentation/use/</a> with
pgpool ? <br>
</p>
<p>I suppose savepoint makes sense only on primary db so I tried to
route such query to primary but nothing changed, it hangs as well.<br>
</p>
<p>pgpool settings:<br>
</p>
<p>backend_clustering_mode = 'streaming_replication'<br>
listen_addresses = '*'<br>
port = 9999<br>
unix_socket_directories = '/var/run/postgresql/'<br>
pcp_listen_addresses = 'localhost'<br>
pcp_port = 9898<br>
pcp_socket_dir = '/var/run/postgresql/'<br>
backend_hostname0 = '10.2.20.234'<br>
backend_port0 = 5432<br>
backend_weight0 = 1<br>
backend_data_directory0 = '/var/lib/pgsql/14/data'<br>
backend_flag0 = 'ALWAYS_PRIMARY'<br>
backend_application_name0 = 'primarydb'<br>
backend_hostname1 = '10.2.20.233'<br>
backend_port1 = 5432<br>
backend_weight1 = 1<br>
backend_data_directory1 = '/var/lib/pgsql/14/data'<br>
backend_flag1 = 'ALLOW_TO_FAILOVER'<br>
backend_application_name1 = 'standbydb'<br>
enable_pool_hba = off<br>
pool_passwd = ''<br>
authentication_timeout = 1min<br>
allow_clear_text_frontend_auth = on<br>
ssl = on<br>
ssl_key = '/var/lib/pgsql/14/data/server.key'<br>
ssl_cert = '/var/lib/pgsql/14/data/server.crt'<br>
num_init_children = 32<br>
min_spare_children = 5<br>
max_spare_children = 10<br>
child_life_time = 5min<br>
log_destination = 'stderr'<br>
log_connections = on<br>
log_disconnections = on<br>
log_hostname = on<br>
log_per_node_statement = on<br>
syslog_facility = 'LOCAL0'<br>
syslog_ident = 'pgpool'<br>
logging_collector = on<br>
log_directory = '/var/log/pgpool_logs'<br>
pid_file_name = '/run/pgpool-II/pgpool.pid'<br>
logdir = '/var/run/postgresql'<br>
load_balance_mode = on<br>
primary_routing_query_pattern_list = 'SAVEPOINT.*;select
GLOBALSYSTEMPARAMETER.paramname.*;BEGIN.*'<br>
sr_check_period = 10<br>
sr_check_user = 'repmgr'<br>
sr_check_password = '******'<br>
sr_check_database = 'postgres'<br>
delay_threshold = 10000000<br>
health_check_user = 'nobody'<br>
health_check_password = '****'<br>
hostname0 = ''</p>
<p><br>
</p>
<p>connection example: <font color="#000000">url=jdbc:postgresql://vbdb01-czdc-p.lx.finshape.com:9999/jtb_gen_test?currentSchema=udebs&autosave=always&cleanupSavepoints=true</font></p>
<p><br>
</p>
<p>I will be grateful for any advice</p>
<p>Karel.<br>
</p>
</body>
</html>