[pgpool-general: 7808] Re: pgpool_recovery extension

[Nirav Bhatt]

And doing so will also remove all the files I set up under /etc/pgpool2
also, I believe?
(I wish there was a way to preserve them)

-Nirav

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

> Ah, I didn't see this earlier.
> Thanks that you pointed it out, Umar :-)
>
> (I know this isn't pgpool related but linux related.)
>
> As I believe if I run the following, it will be installed:
>
> apt install postgresql-14-pgpool2/focal-pgdg
>
> And I also have to remove my own package that is pgpool2/focal-pgdg.
>
> This will install all the required extensions as well.
>
> Am I correct?
>
> Thanks for your time,
> -Nirav
>
>
> On Sat, Oct 16, 2021 at 7:58 PM Umar Hayat <m.umarkiani at gmail.com> wrote:
>
>> Oops last one was Debian 9 package link, here is Ubuntu 20 link:
>>
>> https://ubuntu.pkgs.org/20.04/postgresql-amd64/postgresql-14-pgpool2_4.1.4-3.pgdg20.04+2_amd64.deb.html
>>
>> On Sat, Oct 16, 2021 at 9:46 PM Umar Hayat <m.umarkiani at gmail.com> wrote:
>>
>>> 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/82ac6fcd/attachment-0001.htm>