<div dir="auto">Thank you for your support</div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Wed, Apr 24, 2019, 00:33 Tatsuo Ishii <<a href="mailto:ishii@sraoss.co.jp">ishii@sraoss.co.jp</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">> Hello.<br>
> <br>
> Is there any compatibility matrix between Pgpool releases and Postgresql<br>
> releases?<br>
<br>
Currently no. However, Pgpool-II is theoretically compatible with any<br>
release of PostgreSQL except particular features that require specific<br>
PostgreSQL versions. For example, streaming replication mode can only<br>
be used with PostgreSQL 9.0 or later with obvious reasons.<br>
<br>
If you build Pgpool-II from source code, you could combine it with any<br>
release of PostgreSQL.<br>
<br>
> I am using Linux Centos with Pgpool rpms. If I want to know if a Pgpool<br>
> release is compatible with Postgresql 11, then I am checking file name of<br>
> rpm. I know it is not a very nice method. Examples:<br>
<br>
Pgpool-II RPM's "compatibility with PostgreSQL" does not necessarily<br>
mean particular version of Pgpool-II is only suitable for particular<br>
version of PostgreSQL. The reason why Pgpool-II RPMs are combined with<br>
each PostgreSQL version is PostgreSQL rpm uses different installation<br>
directory, and Pgpool-II needs to adapt them.<br>
<br>
> Pgpool 3.4.21<br>
> <a href="http://www.pgpool.net/yum/rpms/3.4/redhat/rhel-6-x86_64/pgpool-II-pg11-3.4.21-1pgdg.rhel6.x86_64.rpm" rel="noreferrer noreferrer" target="_blank">http://www.pgpool.net/yum/rpms/3.4/redhat/rhel-6-x86_64/pgpool-II-pg11-3.4.21-1pgdg.rhel6.x86_64.rpm</a><br>
> is compatible with Postgresql 11, because file name contains "pg11".<br>
> <br>
> Pgpool 4.0.4<br>
> <a href="http://www.pgpool.net/yum/rpms/4.0/redhat/rhel-6-x86_64/pgpool-II-pg11-4.0.4-1pgdg.rhel6.x86_64.rpm" rel="noreferrer noreferrer" target="_blank">http://www.pgpool.net/yum/rpms/4.0/redhat/rhel-6-x86_64/pgpool-II-pg11-4.0.4-1pgdg.rhel6.x86_64.rpm</a><br>
> is compatible with Postgresql 11, because file name contains "pg11".<br>
> <br>
> On <a href="http://www.pgpool.net/yum/rpms/3.3/redhat/rhel-6-x86_64/" rel="noreferrer noreferrer" target="_blank">http://www.pgpool.net/yum/rpms/3.3/redhat/rhel-6-x86_64/</a> there is no<br>
> file with name like "pg11". Then, I think that Pgpool 3.3 is not compatible<br>
> with Postgresql 11.<br>
<br>
No. Real reason is, Pgpool-II 3.3 was EOLed before PostgreSQL 11 was<br>
released.<br>
<br>
See <a href="https://pgpool.net/mediawiki/index.php/Source_code_repository" rel="noreferrer noreferrer" target="_blank">https://pgpool.net/mediawiki/index.php/Source_code_repository</a> for<br>
details of our EOL policy.<br>
--<br>
Tatsuo Ishii<br>
SRA OSS, Inc. Japan<br>
English: <a href="http://www.sraoss.co.jp/index_en.php" rel="noreferrer noreferrer" target="_blank">http://www.sraoss.co.jp/index_en.php</a><br>
Japanese:<a href="http://www.sraoss.co.jp" rel="noreferrer noreferrer" target="_blank">http://www.sraoss.co.jp</a><br>
</blockquote></div>