[pgpool-general: 8459] Re: extension pgpool_recovery.control not found

[Tatsuo Ishii]

> Hello,
> I have installed the pgpool2 package for ubuntu from official
> repository
> 
> echo "deb http://apt.postgresql.org/pub/repos/apt jammy-pgdg main" >
> /etc/apt/sources.list.d/pgdg.list
> apt update
> apt install postgresql pgpool2
> 
> When I want to create the extension, I have the message as follws:
> $ psql template1 -c "CREATE EXTENSION pgpool_recovery"
> ERROR:  extension "pgpool_recovery" is not available
> DETAIL: Could not open extension control file
> "/usr/share/postgresql/15/extension/pgpool_recovery.control": No such
> file or directory.
> HINT: The extension must first be installed on the system where
> PostgreSQL is running.
> 
> And It does not exist on my server.
> # locate pgpool_recovery.control
> #
> 
> Where can I found this extension ?
> Thanks for your tips,

Lacking libpgpool2 postgresql-15-pgpool2?
You can follow the instruction here.
https://pgpool.net/mediawiki/index.php/Apt_Repository

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