saygoodbyye opened a new issue, #1422:
URL: https://github.com/apache/age/issues/1422
**Describe the bug**
Fail of pg_upgrade
**How are you accessing AGE (Command line, driver, etc.)?**
Accessing AGE through command line.
**What data setup do we need to do?**
Apache AGE (master branch) with PostgreSQL (REL_15_STABLE).
**What is the necessary configuration info needed?**
```
./configure CFLAGS=" -Og" --enable-tap-tests --enable-debug --enable-cassert
--prefix=/tmp/pgsql
```
**What is the command that caused the error?**
```bash
PGDATA=/tmp/pgsql/data
killall postgres
rm -rf $PGDATA
initdb -U postgres -k -D "$PGDATA"
pg_ctl -D "$PGDATA" -l `pwd`/pgsql.log start
createdb -U postgres test
psql -U postgres -dtest -c "CREATE EXTENSION age"
pg_ctl -D "$PGDATA" -l `pwd`/pgsql.log stop
pg_upgrade -U postgres -d /tmp/pgsql/data -D /tmp/pgsql/data -b
/tmp/pgsql/bin/ -B /tmp/pgsql/bin
```
**Result**
```
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 system-defined composite types in user tables 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
drop the problem columns and restart the upgrade.
A list of the problem columns is in the file:
/tmp/pgsql/data/pg_upgrade_output.d/20231127T141248.693/tables_using_reg.txt
Failure, exiting
```
**Expected behavior**
Successfull pg_upgrade
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
