Skip to content

Unable to upgrade PostgreSQL from 9.5 to 9.6 with pg_pathman 1.2.1 installed #75

Closed
@Envek

Description

@Envek

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.

Metadata

Metadata

Assignees

No one assigned

    Type

    No type

    Projects

    No projects

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions