<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=UTF-8">
</head>
<body>
<p>Hello !</p>
<p>I'm trying to use pgpool (4.4.3) to pool connections to
postgresql, to enforce a lower max_connections.</p>
<p>I'm getting errors on prepared statements from osm2pgsql, <code>Query
is in the form `</code><code><code>EXECUTE
mark_rels_by_way(404720865)</code>`<br>
</code></p>
<p><code>Errors logged by pgpool : <br>
</code></p>
<p><span class="dscDiscoverGrid__inner"><span
class="dscDiscoverGrid__cellValue">FATAL: unable to bind</span></span></p>
<p><span class="dscDiscoverGrid__inner"><span
class="dscDiscoverGrid__cellValue">DETAIL: cannot get parse
message "mark_rels_by_way"</span></span></p>
<p><span class="dscDiscoverGrid__inner"><span
class="dscDiscoverGrid__cellValue"><br>
</span></span></p>
<p><span class="dscDiscoverGrid__inner"><span
class="dscDiscoverGrid__cellValue">This looks a lot like an
old unsolved issue from </span></span><span
class="dscDiscoverGrid__inner"><span
class="dscDiscoverGrid__cellValue"><span
class="dscDiscoverGrid__inner"><span
class="dscDiscoverGrid__cellValue">osm2pgsql</span></span>
<a class="moz-txt-link-freetext" href="https://github.com/openstreetmap/osm2pgsql/issues/878">https://github.com/openstreetmap/osm2pgsql/issues/878</a><br>
</span></span></p>
<p><span class="dscDiscoverGrid__inner"><span
class="dscDiscoverGrid__cellValue"><br>
</span></span></p>
<p><span class="dscDiscoverGrid__inner"><span
class="dscDiscoverGrid__cellValue">My current configuration
include a single backend and <br>
</span></span></p>
<p><span id="LC27" class="line" lang="plaintext">backend_clustering_mode
= 'raw'</span><span class="dscDiscoverGrid__inner"><span
class="dscDiscoverGrid__cellValue"></span></span></p>
<p><span id="LC50" class="line" lang="plaintext">process_management_mode
= dynamic</span></p>
<p><span id="LC58" class="line" lang="plaintext">process_management_strategy
= lazy</span></p>
<p><span id="LC78" class="line" lang="plaintext">num_init_children =
150</span></p>
<p><span id="LC81" class="line" lang="plaintext">min_spare_children
= 5</span></p>
<p><span id="LC85" class="line" lang="plaintext">max_spare_children
= 20</span></p>
<p><span id="LC128" class="line" lang="plaintext">connection_cache =
on</span><span id="LC85" class="line" lang="plaintext"></span><span
id="LC81" class="line" lang="plaintext"></span><span id="LC78"
class="line" lang="plaintext"></span><span id="LC58"
class="line" lang="plaintext"></span><span id="LC50"
class="line" lang="plaintext"></span><br>
</p>
<p><br>
</p>
<p>Are prepared statements possible over pgpool ? (looks like they
should be since documentation mention PREPARE/EXECUTE/DEALLOCATE
commands)<br>
</p>
<p>Is there a specific configuration that breaks them ? or a
specific configuration to allow them ? <br>
</p>
<p><br>
</p>
<p>Thanks for any tips <br>
</p>
<code></code>
</body>
</html>