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

[Tatsuo Ishii]

>> 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.

I thought it is pretty obvious that you do not need to install the
extensions on the server on which only Pgpool-II runs, because
extensions can only be executed by PostgreSQL.

> In those cases, users may then decide to not install extensions on
> PostgreSQL servers

I'm confused. Why do you think so?

Best reagards,
--
Tatsuo Ishii
SRA OSS LLC
English: http://www.sraoss.co.jp/index_en/
Japanese:http://www.sraoss.co.jp