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

[Jean-Max Reymond]

Le 18/10/2022 à 14:55, Tatsuo Ishii a écrit :
>> 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

Thanks for your quick answer
fresh installation on a new server ubuntu 22LTS:

4	 apt install curl ca-certificates gnupg
5	 curl https://www.postgresql.org/media/keys/ACCC4CF8.asc | gpg 
--dearmor | sudo tee /etc/apt/trusted.gpg.d/apt.postgresql.org.gpg 
 >/dev/null
6	 echo "deb http://apt.postgresql.org/pub/repos/apt jammy-pgdg main" > 
/etc/apt/sources.list.d/pgdg.list
7	 apt update
8	 apt install postgresql libpgpool2 pgpool2
9	 systemctl enable postgresql pgpool2
10	 apt install locate
11       updatedb
12	 dpkg -l | grep pgpool2
13	 locate pgpool_recovery.control

and nothing :-(

# dpkg -l | grep pgpool2
ii  libpgpool2                  4.3.3-1.pgdg22.04+1 
amd64        pgpool control protocol library
ii  pgpool2                     4.3.3-1.pgdg22.04+1 
amd64        connection pool server and replication proxy for PostgreSQL
# dpkg -l | grep postgresql
ii  pgdg-keyring                2018.2 
all          keyring for apt.postgresql.org
ii  postgresql                  15+244.pgdg22.04+1 
all          object-relational SQL database (supported version)
ii  postgresql-15               15.0-1.pgdg22.04+1 
amd64        The World's Most Advanced Open Source Relational Database
ii  postgresql-client-15        15.0-1.pgdg22.04+1 
amd64        front-end programs for PostgreSQL 15
ii  postgresql-client-common    244.pgdg22.04+1 
all          manager for multiple PostgreSQL client versions
ii  postgresql-common           244.pgdg22.04+1 
all          PostgreSQL database-cluster manager