[pgpool-hackers: 4407] Upgrade pgpool extensions

[Igor Yurchenko]

Hi guys

I am implementing a code (python if it matters) for upgrading rather
outdated pgpool 3.6 up to a bit less outdated pgpool 4.2. But we are
planning to quickly update up to the latest version. I was stuck with how
to remove old extensions/functions clearly and install new one.

1. I have no questions about extensions installation. It's described well
in documentation.
But for removing, I'm not sure. A straightforward solution is parsing all
names of functions/extensions from install scripts of pgpool 3.6 and
removing them one by one.
For pgpool_adm it's a single row. But pgpool_recovery.sql defines several
functions. And hard coding them in the code makes it really smell.But maybe
I missed something.

2. In the documentation examples the extensions are installed in template1
database. It affects only databases that will be created after it. If a
database already exists, I should install it (preliminary remove a previous
version) to the certain database too. Right?

I would appreciate any ideas or advice. Thanks!


BR
Igor Yurchenko
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.pgpool.net/pipermail/pgpool-hackers/attachments/20231030/0af6a8f0/attachment.htm>