I was running a databases/postgresql13-server server in a jail with databases/timescaledb installed and enabled for some databases. Through a pkg update process, the databases/timescaledb was updated to version 2.13.1 (I don't recall which version was installed) which installed also as a dependency the databases/postgresql15-server.
I am trying to upgrade the postgresql server from version 13 to version 15,
I fetched the databases/postgresql13-server and databases/timescaledb pkgs and put them under /root/postgresql/13/
Now I am trying to upgrade by issuing the command:
but I get the error:
From the suggested error log file:
The /root/postgresql/13/usr/local/lib/postgresql/timescaledb.so is there but I assume this version (2.13.1) is incompatible with the postgresql13-server.
Is this the right way to upgrade the postgresql server? Should I fetch an older version of timescaledb, compatible with the postgresql13-server (how do I fetch older versions of packages)?
Any help, would be appreciated.
I am trying to upgrade the postgresql server from version 13 to version 15,
I fetched the databases/postgresql13-server and databases/timescaledb pkgs and put them under /root/postgresql/13/
Now I am trying to upgrade by issuing the command:
su -l postgres -c "pg_upgrade -b /root/postgresql/13/usr/local/bin/ -d /var/db/postgres/data13/ -B /usr/local/bin/ -D /var/db/postgres/data15/ -U postgres "
but I get the error:
Code:
Performing Consistency Checks
-----------------------------
Checking cluster versions ok
*failure*
Consult the last few lines of "/var/db/postgres/data15/pg_upgrade_output.d/20240202T130233.819/log/pg_upgrade_server.log" for
the probable cause of the failure.
connection to server on socket "/var/db/postgres/.s.PGSQL.50432" failed: No such file or directory
Is the server running locally and accepting connections on that socket?
could not connect to source postmaster started with the command:
"/root/postgresql/13/usr/local/bin/pg_ctl" -w -l "/var/db/postgres/data15/pg_upgrade_output.d/20240202T130233.819/log/pg_upgrade_server.log" -D "/var/db/postgres/data13" -o "-p 50432 -b -c listen_addresses='' -c unix_socket_permissions=0700 -c unix_socket_directories='/var/db/postgres'" start
Failure, exiting
Code:
-----------------------------------------------------------------
pg_upgrade run on Fri Feb 2 13:02:33 2024
-----------------------------------------------------------------
command: "/root/postgresql/13/usr/local/bin/pg_ctl" -w -l "/var/db/postgres/data15/pg_upgrade_output.d/20240202T130233.819/log/pg_upgrade_server.log" -D "/var/db/postgres/data13" -o "-p 50432 -b -c listen_addresses='' -c unix_socket_permissions=0700 -c unix_socket_directories='/var/db/postgres'" start >> "/var/db/postgres/data15/pg_upgrade_output.d/20240202T130233.819/log/pg_upgrade_server.log" 2>&1
waiting for server to start....2024-02-02 11:02:33.955 GMT [30710] FATAL: could not load library "/root/postgresql/13/usr/local/lib/postgresql/timescaledb.so": /root/postgresql/13/usr/local/lib/postgresql/timescaledb.so: Undefined symbol "shmem_request_hook"
2024-02-02 11:02:33.955 GMT [30710] LOG: database system is shut down
stopped waiting
pg_ctl: could not start server
Examine the log output.
The /root/postgresql/13/usr/local/lib/postgresql/timescaledb.so is there but I assume this version (2.13.1) is incompatible with the postgresql13-server.
Is this the right way to upgrade the postgresql server? Should I fetch an older version of timescaledb, compatible with the postgresql13-server (how do I fetch older versions of packages)?
Any help, would be appreciated.