[pgpool-general: 8712] Re: what is pgpool-II "extensions" RPM package used for?

[zam bak]

On Mon, Apr 3, 2023 at 12:52 AM Bo Peng <pengbo at sraoss.co.jp> wrote:
>
> Hello,
>
> On Fri, 31 Mar 2023 15:30:13 -0400
> zam bak <zam6ak at gmail.com> wrote:
>
> > Hi
> >
> > In the PgPool-II docs, it says that when installing from RPMs then one
> > must install "externsions" package on each PostgreSQL server.
> >
> > https://www.pgpool.net/docs/44/en/html/install-rpm.html#INSTALLING-RPM
> >
> > What is this package for?
> > Is it required if using only connection pooling and load balancing?
>
> pgpool-II-pg*-extensions packages are used for online recovery.
> If you are using only connection pooling and load balancing,
> you don't need this package.

Thanks for explaining.
What exactly includes "online recovery"? Is it in the docs or..?
Is this any functionality where primary and replicas are set as
backend_flag0 = 'ALWAYS_PRIMARY'
backend_flag1 = 'DISALLOW_TO_FAILOVER'

I think it would be very beneficial to update docs and state in which
cases extensions are required.
This is useful in situations where PgPool is installed on a different
server than PostgreSQL.
In those cases, users may then decide to not install extensions on
PostgreSQL servers

>
> > We have separate servers for PostgreSQL and for PgPool and would
> > rather not install packages on PostgreSQL server if not needed. But
> > the documentation does not say what is extensions package is for....
> >
> >
> > Thanks
> > Z...
> > _______________________________________________
> > pgpool-general mailing list
> > pgpool-general at pgpool.net
> > http://www.pgpool.net/mailman/listinfo/pgpool-general
>
>
> --
> Bo Peng <pengbo at sraoss.co.jp>
> SRA OSS LLC
> https://www.sraoss.co.jp/