Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

Sign up
Appearance settings

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

Closed
Milestone
@Envek

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.

Metadata

Metadata

Assignees

No one assigned

    Type

    No type

    Projects

    No projects

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions

      AltStyle によって変換されたページ (->オリジナル) /