Skip to content

Instantly share code, notes, and snippets.

@ivan
Created October 27, 2020 20:17
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save ivan/5dcc35ef895c93671e5ff7d9d112318c to your computer and use it in GitHub Desktop.
Save ivan/5dcc35ef895c93671e5ff7d9d112318c to your computer and use it in GitHub Desktop.
# pg_upgrade -d 12 -D 13 -b /nix/store/d7dl2di3b3x9i9dlxwfd8sh0gjl2h89c-postgresql-and-plugins-12.4/bin
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 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
# cat tables_using_reg.txt
In database: infra
periods.system_versioning.func_as_of
periods.system_versioning.func_between
periods.system_versioning.func_between_symmetric
periods.system_versioning.func_from_to
periods.system_versioning_func_as_of_key.func_as_of
periods.system_versioning_func_between_key.func_between
periods.system_versioning_func_between_symmetric_key.func_between_symmetric
periods.system_versioning_func_from_to_key.func_from_to
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment