Skip to content

Add support for Postgres 14

Matthias Käppler requested to merge 81-pg-14 into master

Adds Postgres 14 support

Refs #81 (closed)

Tested for the 13 => 14 upgrade path:

[10:38:26] work/gl-gck::81-pg-14 ✗ bats bats
pg_upgrade.bats
 ✓ Migrate PostgreSQL 12 to 14
 ✓ Migrate PostgreSQL 13 to 14

2 tests, 0 failures

Also:

$ docker logs gl-gck_postgres_1
...
Upgrade Complete
----------------
Optimizer statistics are not transferred by pg_upgrade.
Once you start the new server, consider running:
    /usr/local/bin/vacuumdb --all --analyze-in-stages

Running this script will delete the old cluster's data files:
    ./delete_old_cluster.sh
Starting '/var/lib/postgresql/data/14'...
waiting for server to start....2023-11-07 09:21:31.886 UTC [251] LOG:  starting PostgreSQL 14.9 on x86_64-pc-linux-musl, compiled by gcc (Alpine 12.2.1_git20220924-r10) 12.2.1 20220924, 64-bit
2023-11-07 09:21:31.886 UTC [251] LOG:  listening on IPv4 address "0.0.0.0", port 5432
2023-11-07 09:21:31.886 UTC [251] LOG:  listening on IPv6 address "::", port 5432
2023-11-07 09:21:31.904 UTC [251] LOG:  listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
2023-11-07 09:21:31.930 UTC [252] LOG:  database system was shut down at 2023-11-07 09:21:31 UTC
2023-11-07 09:21:31.940 UTC [251] LOG:  database system is ready to accept connections
 done
server started
Edited by Matthias Käppler

Merge request reports