****@****:/home/odkadmin/central# docker compose up postgres [+] Running 2/2 ✔ Volume "central_postgres14" Created 0.0s ✔ Container central_postgres_1 Recreated 0.3s Attaching to central-postgres-1 central-postgres-1 | Thu Sep 28 11:29:31 AM GMT 2023 [upgrade-postgres.sh] Checking for existing upgrade marker file... central-postgres-1 | Thu Sep 28 11:29:31 AM GMT 2023 [upgrade-postgres.sh] Upgrade not run previously; upgrading now... central-postgres-1 | Thu Sep 28 11:29:31 AM GMT 2023 [upgrade-postgres.sh] From: /var/lib/postgresql/data central-postgres-1 | Thu Sep 28 11:29:31 AM GMT 2023 [upgrade-postgres.sh] To: /var/lib/postgresql/14/data central-postgres-1 | The files belonging to this database system will be owned by user "postgres". central-postgres-1 | This user must also own the server process. central-postgres-1 | central-postgres-1 | The database cluster will be initialized with locale "en_US.utf8". central-postgres-1 | The default database encoding has accordingly been set to "UTF8". central-postgres-1 | The default text search configuration will be set to "english". central-postgres-1 | central-postgres-1 | Data page checksums are disabled. central-postgres-1 | central-postgres-1 | fixing permissions on existing directory /var/lib/postgresql/14/data ... ok central-postgres-1 | creating subdirectories ... ok central-postgres-1 | selecting dynamic shared memory implementation ... posix central-postgres-1 | selecting default max_connections ... 100 central-postgres-1 | selecting default shared_buffers ... 128MB central-postgres-1 | selecting default time zone ... Etc/UTC central-postgres-1 | creating configuration files ... ok central-postgres-1 | running bootstrap script ... ok central-postgres-1 | performing post-bootstrap initialization ... ok central-postgres-1 | syncing data to disk ... ok central-postgres-1 | central-postgres-1 | initdb: warning: enabling "trust" authentication for local connections central-postgres-1 | You can change this by editing pg_hba.conf or using the option -A, or central-postgres-1 | --auth-local and --auth-host, the next time you run initdb. central-postgres-1 | central-postgres-1 | Success. You can now start the database server using: central-postgres-1 | central-postgres-1 | pg_ctl -D /var/lib/postgresql/14/data -l logfile start central-postgres-1 | central-postgres-1 | Performing Consistency Checks central-postgres-1 | ----------------------------- central-postgres-1 | Checking cluster versions ok central-postgres-1 | Checking database user is the install user ok central-postgres-1 | Checking database connection settings ok central-postgres-1 | Checking for prepared transactions ok central-postgres-1 | Checking for system-defined composite types in user tables ok central-postgres-1 | Checking for reg* data types in user tables ok central-postgres-1 | Checking for contrib/isn with bigint-passing mismatch ok central-postgres-1 | Checking for user-defined encoding conversions ok central-postgres-1 | Checking for user-defined postfix operators ok central-postgres-1 | Checking for incompatible polymorphic functions ok central-postgres-1 | Checking for tables WITH OIDS ok central-postgres-1 | Checking for invalid "sql_identifier" user columns ok central-postgres-1 | Checking for invalid "unknown" user columns ok central-postgres-1 | Creating dump of global objects ok central-postgres-1 | Creating dump of database schemas central-postgres-1 | odk central-postgres-1 | postgres central-postgres-1 | template1 central-postgres-1 | ok central-postgres-1 | Checking for presence of required libraries ok central-postgres-1 | Checking database user is the install user ok central-postgres-1 | Checking for prepared transactions ok central-postgres-1 | Checking for new cluster tablespace directories ok central-postgres-1 | central-postgres-1 | If pg_upgrade fails after this point, you must re-initdb the central-postgres-1 | new cluster before continuing. central-postgres-1 | central-postgres-1 | Performing Upgrade central-postgres-1 | ------------------ central-postgres-1 | Analyzing all rows in the new cluster ok central-postgres-1 | Freezing all rows in the new cluster ok central-postgres-1 | Deleting files from new pg_xact ok central-postgres-1 | Copying old pg_clog to new server ok central-postgres-1 | Setting oldest XID for new cluster ok central-postgres-1 | Setting next transaction ID and epoch for new cluster ok central-postgres-1 | Deleting files from new pg_multixact/offsets ok central-postgres-1 | Copying old pg_multixact/offsets to new server ok central-postgres-1 | Deleting files from new pg_multixact/members ok central-postgres-1 | Copying old pg_multixact/members to new server ok central-postgres-1 | Setting next multixact ID and offset for new cluster ok central-postgres-1 | Resetting WAL archives ok central-postgres-1 | Setting frozenxid and minmxid counters in new cluster ok central-postgres-1 | Restoring global objects in the new cluster ok central-postgres-1 | Restoring database schemas in the new cluster central-postgres-1 | template1 central-postgres-1 | odk central-postgres-1 | postgres central-postgres-1 | ok central-postgres-1 | Copying user relation files central-postgres-1 | /var/lib/postgresql/data/base/16384/2613 central-postgres-1 | /var/lib/postgresql/data/base/16384/2683 central-postgres-1 | /var/lib/postgresql/data/base/16384/16387 central-postgres-1 | /var/lib/postgresql/data/base/16384/16391 central-postgres-1 | /var/lib/postgresql/data/base/16384/16395 central-postgres-1 | /var/lib/postgresql/data/base/16384/16399 central-postgres-1 | /var/lib/postgresql/data/base/16384/16611 central-postgres-1 | /var/lib/postgresql/data/base/16384/16611_fsm central-postgres-1 | /var/lib/postgresql/data/base/16384/16611_vm central-postgres-1 | /var/lib/postgresql/data/base/16384/16617 central-postgres-1 | /var/lib/postgresql/data/base/16384/16618 central-postgres-1 | /var/lib/postgresql/data/base/16384/16417 central-postgres-1 | /var/lib/postgresql/data/base/16384/16417_fsm central-postgres-1 | /var/lib/postgresql/data/base/16384/16421 central-postgres-1 | /var/lib/postgresql/data/base/16384/16423 central-postgres-1 | /var/lib/postgresql/data/base/16384/16424 central-postgres-1 | /var/lib/postgresql/data/base/16384/16426 central-postgres-1 | /var/lib/postgresql/data/base/16384/16432 central-postgres-1 | /var/lib/postgresql/data/base/16384/16433 central-postgres-1 | /var/lib/postgresql/data/base/16384/16433_fsm central-postgres-1 | /var/lib/postgresql/data/base/16384/16624 central-postgres-1 | /var/lib/postgresql/data/base/16384/16624_fsm central-postgres-1 | /var/lib/postgresql/data/base/16384/16630 central-postgres-1 | /var/lib/postgresql/data/base/16384/16448 central-postgres-1 | /var/lib/postgresql/data/base/16384/16451 central-postgres-1 | /var/lib/postgresql/data/base/16384/16451_fsm central-postgres-1 | /var/lib/postgresql/data/base/16384/16451_vm central-postgres-1 | /var/lib/postgresql/data/base/16384/16460 central-postgres-1 | /var/lib/postgresql/data/base/16384/16467 central-postgres-1 | /var/lib/postgresql/data/base/16384/16481 central-postgres-1 | /var/lib/postgresql/data/base/16384/16517 central-postgres-1 | /var/lib/postgresql/data/base/16384/16632 central-postgres-1 | /var/lib/postgresql/data/base/16384/17070 central-postgres-1 | /var/lib/postgresql/data/base/16384/17070_fsm central-postgres-1 | /var/lib/postgresql/data/base/16384/17070_vm central-postgres-1 | /var/lib/postgresql/data/base/16384/17076 central-postgres-1 | /var/lib/postgresql/data/base/16384/17077 central-postgres-1 | /var/lib/postgresql/data/base/16384/16554 central-postgres-1 | /var/lib/postgresql/data/base/16384/16557 central-postgres-1 | /var/lib/postgresql/data/base/16384/16571 central-postgres-1 | /var/lib/postgresql/data/base/16384/16571_fsm central-postgres-1 | /var/lib/postgresql/data/base/16384/16575 central-postgres-1 | /var/lib/postgresql/data/base/16384/16575_fsm central-postgres-1 | /var/lib/postgresql/data/base/16384/16575_vm central-postgres-1 | /var/lib/postgresql/data/base/16384/16577 central-postgres-1 | /var/lib/postgresql/data/base/16384/16577_fsm central-postgres-1 | /var/lib/postgresql/data/base/16384/16578 central-postgres-1 | /var/lib/postgresql/data/base/16384/16580 central-postgres-1 | /var/lib/postgresql/data/base/16384/16580_fsm central-postgres-1 | /var/lib/postgresql/data/base/16384/16583 central-postgres-1 | /var/lib/postgresql/data/base/16384/16585 central-postgres-1 | /var/lib/postgresql/data/base/16384/16586 central-postgres-1 | /var/lib/postgresql/data/base/16384/16590 central-postgres-1 | /var/lib/postgresql/data/base/16384/16602 central-postgres-1 | /var/lib/postgresql/data/base/16384/16605 central-postgres-1 | /var/lib/postgresql/data/base/16384/16607 central-postgres-1 | /var/lib/postgresql/data/base/16384/16608 central-postgres-1 | /var/lib/postgresql/data/base/16384/16614 central-postgres-1 | /var/lib/postgresql/data/base/16384/16616 central-postgres-1 | /var/lib/postgresql/data/base/16384/16620 central-postgres-1 | /var/lib/postgresql/data/base/16384/16627 central-postgres-1 | /var/lib/postgresql/data/base/16384/16629 central-postgres-1 | /var/lib/postgresql/data/base/16384/16635 central-postgres-1 | /var/lib/postgresql/data/base/16384/16638 central-postgres-1 | /var/lib/postgresql/data/base/16384/16640 central-postgres-1 | /var/lib/postgresql/data/base/16384/16658 central-postgres-1 | /var/lib/postgresql/data/base/16384/16745 central-postgres-1 | /var/lib/postgresql/data/base/16384/16746 central-postgres-1 | /var/lib/postgresql/data/base/16384/16748 central-postgres-1 | /var/lib/postgresql/data/base/16384/16749 central-postgres-1 | /var/lib/postgresql/data/base/16384/16752 central-postgres-1 | /var/lib/postgresql/data/base/16384/16752_fsm central-postgres-1 | /var/lib/postgresql/data/base/16384/16752_vm central-postgres-1 | /var/lib/postgresql/data/base/16384/16756 central-postgres-1 | /var/lib/postgresql/data/base/16384/16758 central-postgres-1 | /var/lib/postgresql/data/base/16384/16759 central-postgres-1 | /var/lib/postgresql/data/base/16384/16761 central-postgres-1 | /var/lib/postgresql/data/base/16384/16770 central-postgres-1 | /var/lib/postgresql/data/base/16384/17078 central-postgres-1 | /var/lib/postgresql/data/base/16384/17079 central-postgres-1 | /var/lib/postgresql/data/base/16384/16781 central-postgres-1 | /var/lib/postgresql/data/base/16384/16785 central-postgres-1 | /var/lib/postgresql/data/base/16384/16787 central-postgres-1 | /var/lib/postgresql/data/base/16384/16788 central-postgres-1 | /var/lib/postgresql/data/base/16384/16804 central-postgres-1 | /var/lib/postgresql/data/base/16384/16804_fsm central-postgres-1 | /var/lib/postgresql/data/base/16384/16804_vm central-postgres-1 | /var/lib/postgresql/data/base/16384/16807 central-postgres-1 | /var/lib/postgresql/data/base/16384/16824 central-postgres-1 | /var/lib/postgresql/data/base/16384/16895 central-postgres-1 | /var/lib/postgresql/data/base/16384/16896 central-postgres-1 | /var/lib/postgresql/data/base/16384/16897 central-postgres-1 | /var/lib/postgresql/data/base/16384/16912 central-postgres-1 | /var/lib/postgresql/data/base/16384/16912_fsm central-postgres-1 | /var/lib/postgresql/data/base/16384/16912_vm central-postgres-1 | /var/lib/postgresql/data/base/16384/16916 central-postgres-1 | /var/lib/postgresql/data/base/16384/16916_fsm central-postgres-1 | /var/lib/postgresql/data/base/16384/16916_vm central-postgres-1 | /var/lib/postgresql/data/base/16384/16918 central-postgres-1 | /var/lib/postgresql/data/base/16384/16919 central-postgres-1 | /var/lib/postgresql/data/base/16384/16940 central-postgres-1 | /var/lib/postgresql/data/base/16384/16940_fsm central-postgres-1 | /var/lib/postgresql/data/base/16384/16944 central-postgres-1 | /var/lib/postgresql/data/base/16384/16944_fsm central-postgres-1 | /var/lib/postgresql/data/base/16384/16946 central-postgres-1 | /var/lib/postgresql/data/base/16384/16947 central-postgres-1 | /var/lib/postgresql/data/base/16384/16949 central-postgres-1 | /var/lib/postgresql/data/base/16384/16950 central-postgres-1 | /var/lib/postgresql/data/base/16384/16976 central-postgres-1 | /var/lib/postgresql/data/base/16384/16983 central-postgres-1 | /var/lib/postgresql/data/base/16384/17006 central-postgres-1 | /var/lib/postgresql/data/base/16384/17010 central-postgres-1 | /var/lib/postgresql/data/base/16384/17012 central-postgres-1 | /var/lib/postgresql/data/base/16384/17013 central-postgres-1 | /var/lib/postgresql/data/base/16384/17015 central-postgres-1 | /var/lib/postgresql/data/base/16384/17017 central-postgres-1 | /var/lib/postgresql/data/base/16384/17035 central-postgres-1 | /var/lib/postgresql/data/base/16384/17036 central-postgres-1 | /var/lib/postgresql/data/base/16384/17036_fsm central-postgres-1 | /var/lib/postgresql/data/base/16384/17039 central-postgres-1 | /var/lib/postgresql/data/base/16384/17041 central-postgres-1 | /var/lib/postgresql/data/base/16384/17047 central-postgres-1 | /var/lib/postgresql/data/base/16384/17080 central-postgres-1 | /var/lib/postgresql/data/base/16384/17080_fsm central-postgres-1 | /var/lib/postgresql/data/base/16384/17081 central-postgres-1 | /var/lib/postgresql/data/base/16384/17073 central-postgres-1 | /var/lib/postgresql/data/base/16384/17075 central-postgres-1 | /var/lib/postgresql/data/base/16384/17082 central-postgres-1 | /var/lib/postgresql/data/base/16384/17082_fsm central-postgres-1 | /var/lib/postgresql/data/base/16384/17085 central-postgres-1 | /var/lib/postgresql/data/base/16384/17087 central-postgres-1 | /var/lib/postgresql/data/base/16384/17088 central-postgres-1 | /var/lib/postgresql/data/base/16384/17090 central-postgres-1 | /var/lib/postgresql/data/base/16384/17091 central-postgres-1 | /var/lib/postgresql/data/base/16384/17092 central-postgres-1 | /var/lib/postgresql/data/base/16384/17103 central-postgres-1 | /var/lib/postgresql/data/base/16384/17111 central-postgres-1 | /var/lib/postgresql/data/base/16384/17123 central-postgres-1 | /var/lib/postgresql/data/base/16384/17130 central-postgres-1 | /var/lib/postgresql/data/base/16384/17133 central-postgres-1 | /var/lib/postgresql/data/base/12407/2613 central-postgres-1 | /var/lib/postgresql/data/base/12407/2683 central-postgres-1 | /var/lib/postgresql/data/base/1/2613 central-postgres-1 | /var/lib/postgresql/data/base/1/2683 central-postgres-1 | ok central-postgres-1 | Setting next OID for new cluster ok central-postgres-1 | Sync data directory to disk ok central-postgres-1 | Creating script to delete old cluster ok central-postgres-1 | Checking for hash indexes ok central-postgres-1 | Checking for extension updates notice central-postgres-1 | central-postgres-1 | Your installation contains extensions that should be updated central-postgres-1 | with the ALTER EXTENSION command. The file central-postgres-1 | update_extensions.sql central-postgres-1 | when executed by psql by the database superuser will update central-postgres-1 | these extensions. central-postgres-1 | central-postgres-1 | central-postgres-1 | Upgrade Complete central-postgres-1 | ---------------- central-postgres-1 | Optimizer statistics are not transferred by pg_upgrade. central-postgres-1 | Once you start the new server, consider running: central-postgres-1 | /usr/lib/postgresql/14/bin/vacuumdb --all --analyze-in-stages central-postgres-1 | central-postgres-1 | Running this script will delete the old cluster's data files: central-postgres-1 | ./delete_old_cluster.sh central-postgres-1 | Thu Sep 28 11:29:40 AM GMT 2023 [upgrade-postgres.sh] Starting postgres server for maintenance... central-postgres-1 | waiting for server to start.... done central-postgres-1 | server started central-postgres-1 | Thu Sep 28 11:29:40 AM GMT 2023 [upgrade-postgres.sh] Updating extensions... central-postgres-1 | You are now connected to database "odk" as user "odk". central-postgres-1 | ALTER EXTENSION central-postgres-1 | ALTER EXTENSION central-postgres-1 | Thu Sep 28 11:29:40 AM GMT 2023 [upgrade-postgres.sh] Regenerating optimizer statistics... central-postgres-1 | vacuumdb: processing database "odk": Generating minimal optimizer statistics (1 target) central-postgres-1 | vacuumdb: processing database "postgres": Generating minimal optimizer statistics (1 target) central-postgres-1 | vacuumdb: processing database "template1": Generating minimal optimizer statistics (1 target) central-postgres-1 | vacuumdb: processing database "odk": Generating medium optimizer statistics (10 targets) central-postgres-1 | vacuumdb: processing database "postgres": Generating medium optimizer statistics (10 targets) central-postgres-1 | vacuumdb: processing database "template1": Generating medium optimizer statistics (10 targets) central-postgres-1 | vacuumdb: processing database "odk": Generating default (full) optimizer statistics central-postgres-1 | vacuumdb: processing database "postgres": Generating default (full) optimizer statistics central-postgres-1 | vacuumdb: processing database "template1": Generating default (full) optimizer statistics central-postgres-1 | Thu Sep 28 11:29:42 AM GMT 2023 [upgrade-postgres.sh] Stopping postgres server... central-postgres-1 | waiting for server to shut down............................................................... failed central-postgres-1 | pg_ctl: server does not shut down central-postgres-1 | HINT: The "-m fast" option immediately disconnects sessions rather than central-postgres-1 | waiting for session-initiated disconnection. central-postgres-1 exited with code 1 ****@****:/home/odkadmin/central# docker compose up postgres [+] Running 1/0 ✔ Container central-postgres-1 Created 0.0s Attaching to central-postgres-1 central-postgres-1 | Thu Sep 28 11:31:58 AM GMT 2023 [upgrade-postgres.sh] Checking for existing upgrade marker file... central-postgres-1 | Thu Sep 28 11:31:58 AM GMT 2023 [upgrade-postgres.sh] !!! central-postgres-1 | Thu Sep 28 11:31:58 AM GMT 2023 [upgrade-postgres.sh] !!! ERROR: New data found, but upgrade not flagged as complete. central-postgres-1 | Thu Sep 28 11:31:58 AM GMT 2023 [upgrade-postgres.sh] !!! central-postgres-1 | Thu Sep 28 11:31:58 AM GMT 2023 [upgrade-postgres.sh] !!! Please email support@getodk.org for assistance. central-postgres-1 | Thu Sep 28 11:31:58 AM GMT 2023 [upgrade-postgres.sh] !!! central-postgres-1 exited with code 1