[pgpool-general: 7803] Re: pgpool_recovery extension

[Tatsuo Ishii]

> Hello!
> 
> I installed pgpool2 on Ubuntu from this repo:
> 
> 4.1.4-3.pgdg20.04+2
> http://apt.postgresql.org/pub/repos/apt focal-pgdg/main
> 
> When I run this:
> psql template1 -c "CREATE EXTENSION pgpool_recovery"
> 
> I got error:
> could not open extension control file
> "/usr/share/postgresql/14/extension/pgpool_recovery.control": No such file
> or directory
> 
> I checked the directory and obviously it does not have the required sql and
> control files.
> 
> I see that it could be installed using make install, but I am afraid that
> it will spoil my existing set up by overwriting other things carefully set
> up (e.g. conf files, sh files, postgresql)
> 
> Without disturbing what is already set up for pgpool2, what is the way to
> install this extension (i.e. running a few sql commands or moving some
> files manually to directory /usr/share/postgresql/14/extension/?)

I am not familiar with pgpool2 Ubuntu packages but I guess you need
postgresql-14-pgpool2 package.
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese:http://www.sraoss.co.jp