[postgres] | [postgres] | PostgreSQL Database directory appears to contain a database; Skipping initialization [postgres] | [postgres] | ************************************ [postgres] | PostgreSQL data directory: /var/lib/postgresql/data [postgres] | ************************************ [postgres] | ******************************************************************************************* [postgres] | Performing PG upgrade on version 13 database files. Upgrading to version 16 [postgres] | ******************************************************************************************* [postgres] | ---------------------------------------------------------------------- [postgres] | Checking for left over artifacts from a failed previous autoupgrade... [postgres] | ---------------------------------------------------------------------- [postgres] | ------------------------------------------------------------------------------- [postgres] | No artifacts found from a failed previous autoupgrade. Continuing the process. [postgres] | ------------------------------------------------------------------------------- [postgres] | --------------------------------------- [postgres] | Creating OLD temporary directory /var/lib/postgresql/data/old [postgres] | --------------------------------------- [postgres] | -------------------------------------------- [postgres] | Creating OLD temporary directory is complete [postgres] | -------------------------------------------- [postgres] | ------------------------------------------------------- [postgres] | Moving existing data files into OLD temporary directory [postgres] | ------------------------------------------------------- [postgres] | '/var/lib/postgresql/data/PG_VERSION' -> '/var/lib/postgresql/data/old/PG_VERSION' [postgres] | '/var/lib/postgresql/data/base' -> '/var/lib/postgresql/data/old/base' [postgres] | '/var/lib/postgresql/data/global' -> '/var/lib/postgresql/data/old/global' [postgres] | '/var/lib/postgresql/data/old' -> '/var/lib/postgresql/data/old/old' [postgres] | '/var/lib/postgresql/data/pg_commit_ts' -> '/var/lib/postgresql/data/old/pg_commit_ts' [postgres] | '/var/lib/postgresql/data/pg_dynshmem' -> '/var/lib/postgresql/data/old/pg_dynshmem' [postgres] | '/var/lib/postgresql/data/pg_hba.conf' -> '/var/lib/postgresql/data/old/pg_hba.conf' [postgres] | '/var/lib/postgresql/data/pg_ident.conf' -> '/var/lib/postgresql/data/old/pg_ident.conf' [postgres] | '/var/lib/postgresql/data/pg_logical' -> '/var/lib/postgresql/data/old/pg_logical' [postgres] | '/var/lib/postgresql/data/pg_multixact' -> '/var/lib/postgresql/data/old/pg_multixact' [postgres] | '/var/lib/postgresql/data/pg_notify' -> '/var/lib/postgresql/data/old/pg_notify' [postgres] | '/var/lib/postgresql/data/pg_replslot' -> '/var/lib/postgresql/data/old/pg_replslot' [postgres] | '/var/lib/postgresql/data/pg_serial' -> '/var/lib/postgresql/data/old/pg_serial' [postgres] | '/var/lib/postgresql/data/pg_snapshots' -> '/var/lib/postgresql/data/old/pg_snapshots' [postgres] | '/var/lib/postgresql/data/pg_stat' -> '/var/lib/postgresql/data/old/pg_stat' [postgres] | '/var/lib/postgresql/data/pg_stat_tmp' -> '/var/lib/postgresql/data/old/pg_stat_tmp' [postgres] | '/var/lib/postgresql/data/pg_subtrans' -> '/var/lib/postgresql/data/old/pg_subtrans' [postgres] | '/var/lib/postgresql/data/pg_tblspc' -> '/var/lib/postgresql/data/old/pg_tblspc' [postgres] | '/var/lib/postgresql/data/pg_twophase' -> '/var/lib/postgresql/data/old/pg_twophase' [postgres] | '/var/lib/postgresql/data/pg_wal' -> '/var/lib/postgresql/data/old/pg_wal' [postgres] | '/var/lib/postgresql/data/pg_xact' -> '/var/lib/postgresql/data/old/pg_xact' [postgres] | '/var/lib/postgresql/data/postgresql.auto.conf' -> '/var/lib/postgresql/data/old/postgresql.auto.conf' [postgres] | '/var/lib/postgresql/data/postgresql.conf' -> '/var/lib/postgresql/data/old/postgresql.conf' [postgres] | '/var/lib/postgresql/data/postmaster.opts' -> '/var/lib/postgresql/data/old/postmaster.opts' [postgres] | ------------------------------------------------------------------- [postgres] | Moving existing data files into OLD temporary directory is complete [postgres] | ------------------------------------------------------------------- [postgres] | --------------------------------------- [postgres] | Creating NEW temporary directory /var/lib/postgresql/data/new [postgres] | --------------------------------------- [postgres] | -------------------------------------------- [postgres] | Creating NEW temporary directory is complete [postgres] | -------------------------------------------- [postgres] | ----------------------------------------------------- [postgres] | Changing permissions of temporary directories to 0700 [postgres] | ----------------------------------------------------- mv: can't rename '/var/lib/postgresql/data/old': Invalid argument [postgres] | --------------------------------------------------------- [postgres] | Changing permissions of temporary directories is complete [postgres] | --------------------------------------------------------- [postgres] | ------------------------------------------------- [postgres] | Remove postmaster.pid file from PG data directory [postgres] | ------------------------------------------------- [postgres] | ------------------------------------ [postgres] | Determining our own initdb arguments [postgres] | ------------------------------------ [postgres] | --------------------------------------------------------------- [postgres] | The initdb arguments we determined are: --locale=en_US.utf8 --lc-collate=en_US.utf8 --lc-ctype=en_US.utf8 --encoding=UTF8 [postgres] | --------------------------------------------------------------- [postgres] | -------------------------------------------------------------------------------------------------------------------- [postgres] | Old database using collation settings: '--locale=en_US.utf8 --lc-collate=en_US.utf8 --lc-ctype=en_US.utf8 --encoding=UTF8'. Initialising new database with those settings too [postgres] | -------------------------------------------------------------------------------------------------------------------- [postgres] | Initialising PostgreSQL 16 data directory [postgres] | The files belonging to this database system will be owned by user "postgres". [postgres] | This user must also own the server process. [postgres] | [postgres] | The database cluster will be initialized with locale "en_US.utf8". [postgres] | The default text search configuration will be set to "english". [postgres] | [postgres] | Data page checksums are disabled. [postgres] | [postgres] | fixing permissions on existing directory /var/lib/postgresql/data/new ... ok [postgres] | creating subdirectories ... ok [postgres] | selecting dynamic shared memory implementation ... posix [postgres] | selecting default max_connections ... 100 [postgres] | selecting default shared_buffers ... 128MB [postgres] | selecting default time zone ... Europe/Berlin [postgres] | creating configuration files ... ok [postgres] | running bootstrap script ... ok [postgres] | performing post-bootstrap initialization ... ok [postgres] | syncing data to disk ... ok [postgres] | [postgres] | [postgres] | Success. You can now start the database server using: [postgres] | [postgres] | /usr/local/bin/pg_ctl -D /var/lib/postgresql/data/new/ -l logfile start [postgres] | initdb: warning: enabling "trust" authentication for local connections initdb: hint: You can change this by editing pg_hba.conf or using the option -A, or --auth-local and --auth-host, the next time you run initdb. [postgres] | ------------------------------------ [postgres] | New database initialisation complete [postgres] | ------------------------------------ [postgres] | --------------------------------------- [postgres] | Running pg_upgrade command, from /var/lib/postgresql/data [postgres] | --------------------------------------- [postgres] | Performing Consistency Checks [postgres] | ----------------------------- [postgres] | Checking cluster versions ok [postgres] | Checking database user is the install user ok [postgres] | Checking database connection settings ok [postgres] | Checking for prepared transactions ok [postgres] | Checking for system-defined composite types in user tables ok [postgres] | Checking for reg* data types in user tables ok [postgres] | Checking for contrib/isn with bigint-passing mismatch ok [postgres] | Checking for incompatible "aclitem" data type in user tables ok [postgres] | Checking for user-defined encoding conversions ok [postgres] | Checking for user-defined postfix operators ok [postgres] | Checking for incompatible polymorphic functions ok [postgres] | Creating dump of global objects ok [postgres] | Creating dump of database schemas ok [postgres] | Checking for presence of required libraries ok [postgres] | Checking database user is the install user ok [postgres] | Checking for prepared transactions ok [postgres] | Checking for new cluster tablespace directories ok [postgres] | [postgres] | If pg_upgrade fails after this point, you must re-initdb the [postgres] | new cluster before continuing. [postgres] | [postgres] | Performing Upgrade [postgres] | ------------------ [postgres] | Setting locale and encoding for new cluster ok [postgres] | Analyzing all rows in the new cluster ok [postgres] | Freezing all rows in the new cluster ok [postgres] | Deleting files from new pg_xact ok [postgres] | Copying old pg_xact to new server ok [postgres] | Setting oldest XID for new cluster ok [postgres] | Setting next transaction ID and epoch for new cluster ok [postgres] | Deleting files from new pg_multixact/offsets ok [postgres] | Copying old pg_multixact/offsets to new server ok [postgres] | Deleting files from new pg_multixact/members ok [postgres] | Copying old pg_multixact/members to new server ok [postgres] | Setting next multixact ID and offset for new cluster ok [postgres] | Resetting WAL archives ok [postgres] | Setting frozenxid and minmxid counters in new cluster ok [postgres] | Restoring global objects in the new cluster ok [postgres] | Restoring database schemas in the new cluster ok [postgres] | Adding ".old" suffix to old global/pg_control ok [postgres] | [postgres] | If you want to start the old cluster, you will need to remove [postgres] | the ".old" suffix from /var/lib/postgresql/data/old/global/pg_control.old. [postgres] | Because "link" mode was used, the old cluster cannot be safely [postgres] | started once the new cluster has been started. [postgres] | Linking user relation files ok [postgres] | Setting next OID for new cluster ok [postgres] | Sync data directory to disk ok [postgres] | Creating script to delete old cluster ok [postgres] | Checking for extension updates ok [postgres] | [postgres] | Upgrade Complete [postgres] | ---------------- [postgres] | Optimizer statistics are not transferred by pg_upgrade. [postgres] | Once you start the new server, consider running: [postgres] | /usr/local/bin/vacuumdb -U root --all --analyze-in-stages [postgres] | Running this script will delete the old cluster's data files: [postgres] | ./delete_old_cluster.sh [postgres] | -------------------------------------- [postgres] | Running pg_upgrade command is complete [postgres] | -------------------------------------- [postgres] | ----------------------------------------------------- [postgres] | Moving the new database files to the active directory [postgres] | ----------------------------------------------------- [postgres] | '/var/lib/postgresql/data/new/PG_VERSION' -> '/var/lib/postgresql/data/PG_VERSION' [postgres] | '/var/lib/postgresql/data/new/base' -> '/var/lib/postgresql/data/base' [postgres] | '/var/lib/postgresql/data/new/global' -> '/var/lib/postgresql/data/global' [postgres] | '/var/lib/postgresql/data/new/pg_commit_ts' -> '/var/lib/postgresql/data/pg_commit_ts' [postgres] | '/var/lib/postgresql/data/new/pg_dynshmem' -> '/var/lib/postgresql/data/pg_dynshmem' [postgres] | '/var/lib/postgresql/data/new/pg_hba.conf' -> '/var/lib/postgresql/data/pg_hba.conf' [postgres] | '/var/lib/postgresql/data/new/pg_ident.conf' -> '/var/lib/postgresql/data/pg_ident.conf' [postgres] | '/var/lib/postgresql/data/new/pg_logical' -> '/var/lib/postgresql/data/pg_logical' [postgres] | '/var/lib/postgresql/data/new/pg_multixact' -> '/var/lib/postgresql/data/pg_multixact' [postgres] | '/var/lib/postgresql/data/new/pg_notify' -> '/var/lib/postgresql/data/pg_notify' [postgres] | '/var/lib/postgresql/data/new/pg_replslot' -> '/var/lib/postgresql/data/pg_replslot' [postgres] | '/var/lib/postgresql/data/new/pg_serial' -> '/var/lib/postgresql/data/pg_serial' [postgres] | '/var/lib/postgresql/data/new/pg_snapshots' -> '/var/lib/postgresql/data/pg_snapshots' [postgres] | '/var/lib/postgresql/data/new/pg_stat' -> '/var/lib/postgresql/data/pg_stat' [postgres] | '/var/lib/postgresql/data/new/pg_stat_tmp' -> '/var/lib/postgresql/data/pg_stat_tmp' [postgres] | '/var/lib/postgresql/data/new/pg_subtrans' -> '/var/lib/postgresql/data/pg_subtrans' [postgres] | '/var/lib/postgresql/data/new/pg_tblspc' -> '/var/lib/postgresql/data/pg_tblspc' [postgres] | '/var/lib/postgresql/data/new/pg_twophase' -> '/var/lib/postgresql/data/pg_twophase' [postgres] | '/var/lib/postgresql/data/new/pg_wal' -> '/var/lib/postgresql/data/pg_wal' [postgres] | '/var/lib/postgresql/data/new/pg_xact' -> '/var/lib/postgresql/data/pg_xact' [postgres] | '/var/lib/postgresql/data/new/postgresql.auto.conf' -> '/var/lib/postgresql/data/postgresql.auto.conf' [postgres] | '/var/lib/postgresql/data/new/postgresql.conf' -> '/var/lib/postgresql/data/postgresql.conf' [postgres] | '/var/lib/postgresql/data/new/postmaster.opts' -> '/var/lib/postgresql/data/postmaster.opts' [postgres] | ----------------------------------------- [postgres] | Moving the new database files is complete [postgres] | ----------------------------------------- [postgres] | -------------------------------------------------------------- [postgres] | Copying the old pg_hba and pg_ident configuration files across [postgres] | -------------------------------------------------------------- [postgres] | ------------------------------------------------------------------- [postgres] | Copying the old pg_hba and pg_ident configuration files is complete [postgres] | ------------------------------------------------------------------- [postgres] | --------------------------------- [postgres] | Removing left over database files [postgres] | --------------------------------- [postgres] | --------------------------------------------- [postgres] | Removing left over database files is complete [postgres] | --------------------------------------------- [postgres] | ********************************************************** [postgres] | Automatic upgrade process finished with no errors reported [postgres] | ********************************************************** [postgres] | ***************************************************************************************************** [postgres] | 'One shot' automatic upgrade was requested, so exiting now rather than starting the PostgreSQL server [postgres] | *****************************************************************************************************