[pgpool-general: 6159] Re: Pgpool-II version advices.

[Thomas Martin]

Thanks your time and your explanation, I will go with 3.7 then!

Regards,
Thomas

2018-07-07 4:48 GMT+02:00 Tatsuo Ishii <ishii at sraoss.co.jp>:
> From: Thomas Martin <tmartincpp at gmail.com>
> Subject: [pgpool-general: 6157] Pgpool-II version advices.
> Date: Fri, 6 Jul 2018 11:37:29 +0200
> Message-ID: <CAO1iXZLCsRTBx1gQjsK6XXizNVHoDrQt+vPx8MPZeGoRTbG+rw at mail.gmail.com>
>
>> Hello,
>>
>> We are going to migrate from to Pgpool-II 3.2 to a newer release.
>>
>> Do you have any version to recommend for PostgreSQL 9.4 and 9.6 ?
>>
>> Should I go for Pgpool-II 3.7 directly or should I stay with 3.4 and 3.6 ?
>
> I do not recommend 3.4 because it will be EOLed in November 2019.
>
> If you are going to use PostgreSQL 9.6, I recommend Pgpool-II 3.6 or
> 3.7 because those Pgpool-II' SQL parser is compatible with PostgreSQL
> 9.6.  Each Pgpool-II version borrows the latest PostgreSQL parser
> module at the time when the Pgpool-II version was developed (sometimes
> the work is skipped though:-). So here is the chart of each Pgpool-II
> version and PostgreSQL parser version.
>
> Pgpool-II version       PostgreSQL parser version
> -------------------------------------------------
> Pgpool-II 3.2           PostgreSQL 9.0
> Pgpool-II 3.3           PostgreSQL 9.2
> Pgpool-II 3.4           PostgreSQL 9.4
> Pgpool-II 3.5           PostgreSQL 9.5
> Pgpool-II 3.6           PostgreSQL 9.6
> Pgpool-II 3.7           PostgreSQL 10
>
> You can go directly to 3.7 but if you are using watchdog, the
> functionality of watchdog is far enhanced in 3.7 comparing with 3.2,
> so be sure to take time to learn 3.7's watchdog.
>
> Best regards,
> --
> Tatsuo Ishii
> SRA OSS, Inc. Japan
> English: http://www.sraoss.co.jp/index_en.php
> Japanese:http://www.sraoss.co.jp