Failure when trying to perform pg_upgrade
- Dominant language
- C
- Stars
- 4.8k
- Forks
- 523
- Avg merge
- 1d 2h
- Merged PRs (30d)
- 9
Description
**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
Best regards,
Egor Chindyaskin
Postgres Professional: http://postgrespro.com/
Contributor guide
Assessment
This issue has not been assessed yet.