Closed
Description
I'm trying to upgrade PostgreSQL with pg_pathman-enabled database using pg_upgrade
. Both new and old instances have most recent pg_pathman 1.2.1 installed and added to postgresql.conf
.
Invoking pg_upgrade
:
postgres@smp-bsktest-db-0:/var/tmp/pg_upgrade$ /usr/lib/postgresql/9.6/bin/pg_upgrade --check --link --jobs `nproc` --old-bindir /usr/lib/postgresql/9.5/bin --new-bindir /usr/lib/postgresql/9.6/bin --old-datadir /var/lib/postgresql/9.5/main --new-datadir /var/lib/postgresql/9.6/main --old-options ' -c config_file=/etc/postgresql/9.5/main/postgresql.conf -c hba_file=/etc/postgresql/9.5/main/pg_hba.conf' --new-options ' -c config_file=/etc/postgresql/9.6/main/postgresql.conf -c hba_file=/etc/postgresql/9.6/main/pg_hba.conf'
*failure*
Consult the last few lines of "pg_upgrade_server.log" for
the probable cause of the failure.
Performing Consistency Checks on Old Live Server
------------------------------------------------
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* system OID user data types fatal
Your installation contains one of the reg* data types in user tables.
These data types reference system OIDs that are not preserved by
pg_upgrade, so this cluster cannot currently be upgraded. You can
remove the problem tables and restart the upgrade. A list of the problem
columns is in the file:
tables_using_reg.txt
Failure, exiting
Contents of tables_using_reg.txt
:
Database: smp
public.pathman_config_params.init_callback
Is it (or will be) possible to upgrade PostgreSQL? How?
Thank you in advance.