apache / apache/age

Failure when trying to perform pg_upgrade

Open
#1,422 10 comments 3 reactions 0 assignees View on GitHub
enhancement override-stale question
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

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.