<div dir="ltr"><br><div class="gmail_extra"><br><div class="gmail_quote">On Mon, May 29, 2017 at 1:42 PM, Tatsuo Ishii <span dir="ltr"><<a href="mailto:ishii@sraoss.co.jp" target="_blank">ishii@sraoss.co.jp</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><span class="">>> I think these calls are only made by pgpool-worker child process, So one<br>
>> way could be to get the server version of each attached backend at the<br>
>> child startup (SELECT current_setting('server_<wbr>version_num')) and store the<br>
>> version for each backend node in respective backend data structure.<br>
>> And latter before sending the query we can construct the appropriate query<br>
>> by looking at the version information for that backend.<br>
><br>
> server_version_num appeared in PostgreSQL 8.2. Since those functions<br>
> are only used in streaming replication, which first appeared in 9.6,<br>
> we can safely your method. Nice idea!<br>
<br>
</span>Done. I have only modified pool_worker.c because those function calls<br>
are only used in the streaming replication delay checking. Also this<br>
is less invasive.<br></blockquote><div><br></div><div>Yes, I also believe thats the right approach. Thanks for the fix.</div><div><br></div><div>Kind Regards</div><div>Muhammad Usama</div><div> </div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div class="HOEnZb"><div class="h5"><br>
Best regards,<br>
--<br>
Tatsuo Ishii<br>
SRA OSS, Inc. Japan<br>
English: <a href="http://www.sraoss.co.jp/index_en.php" rel="noreferrer" target="_blank">http://www.sraoss.co.jp/index_<wbr>en.php</a><br>
Japanese:<a href="http://www.sraoss.co.jp" rel="noreferrer" target="_blank">http://www.sraoss.co.<wbr>jp</a><br>
</div></div></blockquote></div><br></div></div>