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: dev-unsubscr...@age.apache.org.apache.org

For queries about this service, please contact Infrastructure at:
us...@infra.apache.org

Reply via email to