Skip to content

Unable to upgrade PostgreSQL due to missing TimescaleDB libraries #105

Description

@empereira

hello,

I'm encountering an issue during pg_upgrade from PostgreSQL 13 with timescaledb to 14 using Docker. The upgrade process fails with the message that it cannot find the timescaledb and timescaledb-2.7.0 libraries. I’ve attempted the following steps:

  • Initialized db_data_pg14 with timescale/timescaledb:latest-pg14, but it reports that the postgres database is not empty.
New cluster database "postgres" is not empty: found relation "_timescaledb_catalog.hypertable"
Failure, exiting
  • Tried using the postgres:14-alpine image, but the missing library error persists
postgres@205c7e52aa21:~$ /usr/lib/postgresql/14/bin/pg_upgrade -b /usr/lib/postgresql/13/bin/ -B /usr/lib/postgresql/14/bin/ -d /var/lib/postgresql/data/ -D /var/lib/postgresql/14/data/
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 for system-defined composite types in user tables  ok
Checking for reg* data types in user tables                 ok
Checking for contrib/isn with bigint-passing mismatch       ok
Checking for user-defined encoding conversions              ok
Checking for user-defined postfix operators                 ok
Checking for incompatible polymorphic functions             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:
    loadable_libraries.txt

Failure, exiting
postgres@205c7e52aa21:~$ cat loadable_libraries.txt 
could not load library "$libdir/timescaledb": ERROR:  could not access file "$libdir/timescaledb": No such file or directory
In database: postgres
In database: template1
In database: zabbix
could not load library "$libdir/timescaledb-2.7.0": ERROR:  could not access file "$libdir/timescaledb-2.7.0": No such file or directory
In database: postgres
In database: template1
In database: zabbix

how do I proceed?

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions