- 🇫🇷France andypost
Nor sure we need to update existing images, probably better to rename 14.1 to 14.9
- @andypost opened merge request.
- 🇫🇷France andypost
Using version 15.4 as latest and have to update config https://www.percona.com/blog/postgresql-15-stats-collector-gone-whats-new/
postgres@a5a67edc90c0:~$ bash /opt/startup.sh PGSQL VERSION: 15.4 rebuilding PostgreSQL database cluster Error: specified cluster does not exist Creating new PostgreSQL cluster 15/main ... /usr/lib/postgresql/15/bin/initdb -D /var/lib/postgresql/15.4/main --auth-local peer --auth-host scram-sha-256 --no-instructions The files belonging to this database system will be owned by user "postgres". This user must also own the server process. The database cluster will be initialized with locale "en_US.UTF-8". The default database encoding has accordingly been set to "UTF8". The default text search configuration will be set to "english". Data page checksums are disabled. fixing permissions on existing directory /var/lib/postgresql/15.4/main ... ok creating subdirectories ... ok selecting dynamic shared memory implementation ... posix selecting default max_connections ... 100 selecting default shared_buffers ... 128MB selecting default time zone ... Etc/UTC creating configuration files ... ok running bootstrap script ... ok performing post-bootstrap initialization ... ok syncing data to disk ... ok Ver Cluster Port Status Owner Data directory Log file 15 main 5432 online postgres /var/lib/postgresql/15.4/main /var/log/postgresql/postgresql-15-main.log CREATE ROLE CREATE DATABASE CREATE EXTENSION CREATE SCHEMA 2023-09-16 21:36:17.353 GMT [91] LOG: skipping missing configuration file "/var/lib/postgresql/15/main_data/postgresql.auto.conf" 2023-09-16 21:36:17.353 GMT [91] LOG: unrecognized configuration parameter "stats_temp_directory" in file "/etc/postgresql/15/main/postgresql.conf" line 621 2023-09-16 21:36:17.353 GMT [91] FATAL: configuration file "/etc/postgresql/15/main/postgresql.conf" contains errors pgsql died at Sat Sep 16 09:36:17 PM UTC 2023
-
andypost →
committed 09d6157c on dev
add db/pgsql-15 #3240346
-
andypost →
committed 09d6157c on dev
-
andypost →
committed 3bcede8f on dev
add db/pgsql-15 #3240346
-
andypost →
committed 3bcede8f on dev
-
andypost →
committed a88e29db on dev
Resolve #3240346 "Pgsql 16"
-
andypost →
committed a88e29db on dev
- Status changed to Needs review
over 1 year ago 10:42pm 16 September 2023 - 🇫🇷France andypost
Dev images pushed and here's testing https://git.drupalcode.org/project/drupal/-/merge_requests/4804
-
andypost →
committed a69764ef on production
Resolve #3240346 "Pgsql 16"
-
andypost →
committed a69764ef on production
-
andypost →
committed 9b097665 on production
add db/pgsql-15 #3240346
-
andypost →
committed 9b097665 on production
- Status changed to Fixed
over 1 year ago 1:53am 19 September 2023 - 🇫🇷France andypost
Added to 10.2-dev core 📌 Add postgresql 15/16 to testing matrix Needs review
Automatically closed - issue fixed for 2 weeks with no activity.
- Status changed to Fixed
10 months ago 11:13am 13 February 2024 - 🇫🇷France andypost
Looks it needs to upgrade this images for new security releases
- 🇫🇷France andypost