[pgpool-general: 7804] Re: pgpool_recovery extension

[Nirav Bhatt]

postgresql-14-pgpool2 isn't available for Ubuntu.
For CentOS, I could not find an ARM package.

My pgpool service starts and stops quite fine with the package I have
installed.
I don't want to mess that up.
Isn't there a way to install just the extension as it is the only thing
missing right now?

I can see some files under source tree under the path:
src/sql/pgpool-recovery/.

-Nirav

On Sat, Oct 16, 2021 at 4:18 AM Tatsuo Ishii <ishii at sraoss.co.jp> wrote:

> > 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
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.pgpool.net/pipermail/pgpool-general/attachments/20211016/446db8fc/attachment.htm>