Hi
We plan to upgrade timescaledb from 2.10.0 to 2.11.1, the doc doesn’t mention if need to stop application within upgrade
Once we installed 2.11.1 package locally, it cleanuped 2.10.0 package, 2 questions, thanks:
- Before extension upgrade(extension is still 2.10.0 version) if application can use timescaledb well as 2.10.0 version binary is not available?
- If application is still using timescaledb, will it block extension update please?
# yum localinstall timescaledb-2-postgresql-14-2.11.1-0.el7.x86_64.rpm
Examining timescaledb-2-postgresql-14-2.11.1-0.el7.x86_64.rpm: timescaledb-2-postgresql-14-2.11.1-0.el7.x86_64
Marking timescaledb-2-postgresql-14-2.11.1-0.el7.x86_64.rpm as an update to timescaledb-2-postgresql-14-2.10.0-0.el7.x86_64
Resolving Dependencies
--> Running transaction check
---> Package timescaledb-2-postgresql-14.x86_64 0:2.10.0-0.el7 will be updated
---> Package timescaledb-2-postgresql-14.x86_64 0:2.11.1-0.el7 will be an update
--> Finished Dependency Resolution
Dependencies Resolved
===============================================================================================================================================================================================
Package Arch Version Repository Size
===============================================================================================================================================================================================
Updating:
timescaledb-2-postgresql-14 x86_64 2.11.1-0.el7 /timescaledb-2-postgresql-14-2.11.1-0.el7.x86_64 19 M
Transaction Summary
===============================================================================================================================================================================================
Upgrade 1 Package
Total size: 19 M
Is this ok [y/d/N]: y
Downloading packages:
Running transaction check
Running transaction test
Transaction test succeeded
Running transaction
Updating : timescaledb-2-postgresql-14-2.11.1-0.el7.x86_64 1/2
Using pg_config located at /usr/pgsql-14/bin/pg_config to finish installation...
TimescaleDB has been installed. You need to update your postgresql.conf file
to load the library by adding 'timescaledb' to your shared_preload_libraries.
The easiest way to do this (and more configuration) is to use timescaledb-tune:
timescaledb-tune --pg-config=/usr/pgsql-14/bin/pg_config
Cleanup : timescaledb-2-postgresql-14-2.10.0-0.el7.x86_64 2/2
Verifying : timescaledb-2-postgresql-14-2.11.1-0.el7.x86_64 1/2
Verifying : timescaledb-2-postgresql-14-2.10.0-0.el7.x86_64 2/2
Updated:
timescaledb-2-postgresql-14.x86_64 0:2.11.1-0.el7
Complete!