You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
I tried to run pg_upgrade to migrate from Postgres 14 to Postgres 16. Before upgrading Postgres I migrated to the latest Timescale version on the existing Postgres 14 server. It fails with the message could not load library "$libdir/timescaledb-2.15.3": ERROR: attempt to redefine parameter "timescaledb.enable_deprecation_warnings"
postgres@dev-debian-2:/tmp$ /usr/lib/postgresql/16/bin/pg_upgrade -d /etc/postgresql/14/main -D /etc/postgresql/16/main -b /usr/lib/postgresql/14/bin -B /usr/lib/postgresql/16/bin
Finding the real data directory for the source cluster ok
Finding the real data directory for the target cluster ok
Performing Consistency Checks
-----------------------------
Checking cluster versions ok
Checking database user is the install user ok
Checking database connection settings ok
Checking for prepared transactions ok
Checking forsystem-defined composite typesin user tables ok
Checking forreg* data typesin user tables ok
Checking for contrib/isn with bigint-passing mismatch ok
Checking forincompatible "aclitem" data typein user tables ok
Creating dump of global objects ok
Creating dump of database schemas
ok
Checking for presence of required libraries fatal
Your installation references loadable libraries that are missing from the
new installation. You can add these libraries to the new installation,
or remove the functions using them from the old installation. A list of
problem libraries is in the file:
/var/lib/postgresql/16/main/pg_upgrade_output.d/20240704T080136.575/loadable_libraries.txt
Failure, exiting
could not load library "$libdir/timescaledb-2.15.3": ERROR: attempt to redefine parameter "timescaledb.enable_deprecation_warnings"
Do you have multiple databases with different versions of the timescale-extension? Then you can try to update the extension to the same version before pg_upgrade. I was facing the same issue while having databases with 2.13 and others with 2.15, after updating all to 2.15.3 pg_upgrade works for me.
What type of bug is this?
Unexpected error
What subsystems and features are affected?
Other
What happened?
I tried to run pg_upgrade to migrate from Postgres 14 to Postgres 16. Before upgrading Postgres I migrated to the latest Timescale version on the existing Postgres 14 server. It fails with the message
could not load library "$libdir/timescaledb-2.15.3": ERROR: attempt to redefine parameter "timescaledb.enable_deprecation_warnings"
Installed Postgres and Timescale packages:
TimescaleDB version affected
2.15.3
PostgreSQL version used
14.12, 16.3
What operating system did you use?
Debian 11
What installation method did you use?
Deb/Apt
What platform did you run on?
On prem/Self-hosted
Relevant log output and stack trace
How can we reproduce the bug?
The text was updated successfully, but these errors were encountered: