[pgpool-general: 7805] Re: pgpool_recovery extension

[Umar Hayat]

Hi Nirav,
I can see extension package is available for Ubuntu 20.04 LTS,
It might not be available via pgdb but it's surely available from debian
repo
https://debian.pkgs.org/9/postgresql-amd64/postgresql-14-pgpool2_4.1.4-3.pgdg90+2_amd64.deb.html

See package info bellow.
*"*



























*umarhayat at ubuntu:~$ apt-cache show postgresql-14-pgpool2Package:
postgresql-14-pgpool2Source: pgpool2Version:
4.1.4-3.pgdg20.04+2Architecture: amd64Maintainer: Debian PostgreSQL
Maintainers <team+postgresql at tracker.debian.org
<team%2Bpostgresql at tracker.debian.org>>Installed-Size: 267Depends:
libpgpool0 (>= 4.1.4-3.pgdg20.04+2), postgresql-14, libc6 (>= 2.4)Homepage:
https://www.pgpool.net/mediawiki/index.php/Main_Page
<https://www.pgpool.net/mediawiki/index.php/Main_Page>Priority:
optionalSection: databaseFilename:
pool/main/p/pgpool2/postgresql-14-pgpool2_4.1.4-3.pgdg20.04+2_amd64.debSize:
158860SHA256:
369d7fbf744d3184fdb7e2f832be0964aada59ed3c89059c64e845c6e71c7afaSHA1:
f83d5052e4627b7ec853f4350e323b648c459e4eMD5sum:
2aff2f4fabbfa37a357d296a6fa97aadDescription: connection pool server and
replication proxy for PostgreSQL - modules pgpool-II is a middleware that
works between PostgreSQL servers and a PostgreSQL database client.  This
package contains support modules for the PostgreSQL 14 server: .  *
pgpool_adm  * pgpool_recovery (PostgreSQL 9.1 and above)  * pgpool_regclass
(PostgreSQL 9.1 and above)Description-md5:
8cea9bee452b67ea7fe6ecb20f6277c1umarhayat at ubuntu:~$ "*

HTH
Umar Hayat

On Sat, Oct 16, 2021 at 8:57 PM Nirav Bhatt <niravbhatt.cpp at gmail.com>
wrote:

> 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
>>
> _______________________________________________
> pgpool-general mailing list
> pgpool-general at pgpool.net
> http://www.pgpool.net/mailman/listinfo/pgpool-general
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.pgpool.net/pipermail/pgpool-general/attachments/20211016/5993b267/attachment.htm>