Melkij,
После
pg_resetwal DATADIR
Продолжаем глумиться над полутрупом...
применяем
/usr/lib/postgresql/13/bin/pg_upgrade \
--old-datadir /db/postgresql/10/main \
--new-datadir /db/postgresql/13/data \
--old-bindir /usr/lib/postgresql/10/bin \
--new-bindir /usr/lib/postgresql/13/bin \
--old-options '-c config_file=/etc/postgresql/10/main/postgresql.conf' \
--new-options '-c config_file=/etc/postgresql/13/main/postgresql.conf' --link --check
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
14.
15.
16.
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 reg* data types in user tables ok
Checking for contrib/isn with bigint-passing mismatch ok
Checking for tables WITH OIDS ok
Checking for invalid "sql_identifier" user columns 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
Теперь упираемся в расширения 10-го кластера
could not load library "$libdir/pg_cron": ERROR: could not access file "$libdir/pg_cron": No such file or directory
could not load library "$libdir/tds_fdw": ERROR: could not access file "$libdir/tds_fdw": No such file or directory
Причем
pg_cron в числе досnупных
select * from pg_available_extensions;
а tds_fdw - нет
оба находятся в каталоге /usr/lib/postgresql/10/lib
Если так, какмы обычно умеем,то:
DROP EXTENSION tds_fdw cascade;
ERROR: extension "tds_fdw" does not exist
Как быть, может кто-то уже упражнялся с этим?
