[pgpool-general: 7803] Re: pgpool_recovery extension
Tatsuo Ishii
ishii at sraoss.co.jp
Sat Oct 16 10:18:43 JST 2021
> 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
More information about the pgpool-general
mailing list