Created
October 27, 2020 20:17
-
-
Save ivan/5dcc35ef895c93671e5ff7d9d112318c to your computer and use it in GitHub Desktop.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
# 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