[pgpool-general: 7819] Re: pgpool_recovery extension

Sat Oct 23 23:02:26 JST 2021

Sorry for the late reply.

I was believing postgresql-XX-pgpool2 and pgpool2 are equivalent
packages,with former including extensions and the latter not including them.
Now I understand that they are complimenting each other.

Many thanks for this clarity! I have installed postgresql-14-pgpool2 and
with that extension installation was successful!

Thanks!
-Nirav

On Sat, Oct 16, 2021 at 9:31 PM Umar Hayat <m.umarkiani at gmail.com> wrote:

> Well these are two different things from the packaging side.
> - pgpool2 package contains core pgpool application.
>   It has service files, configurations, binaries etc.
> - postgresql-XX-pgpool2 package contains extension for PG Server, XX means
> extension is packaged for each different supported version.
>   It contain extension binaries and control file etc ( It does have to do
> anything with pgpool2 core, you can have extension without pgpool2 on
> remote machine)
>
> So,
> - installing/removing the extension package should not disturb your
> configuration files in /etc/pgpool2.
> - Uninstalling using 'apt remove pgpool2' should not remove your
> configuration files ( If you use 'apt purge' it WILL remove )
>
> On Sat, Oct 16, 2021 at 10:30 PM Nirav Bhatt <niravbhatt.cpp at gmail.com>
> wrote:
>
>> 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/20211023/b86da506/attachment.htm>