Reference: https://www.postgresql.org/about/news/postgresql-183-179-1613-1517-and-1422-released-3246/
Flags: (none) => affects_mga9+Whiteboard: (none) => MGA9TOOSource RPM: (none) => postgresql18, postgresql15
For Cauldron, I asked for a freeze move. Suggested advisory: ======================== The updated packages fix some regressions appeared in 18.2 and 15.16. References: https://www.postgresql.org/about/news/postgresql-183-179-1613-1517-and-1422-released-3246/ ======================== Updated packages in core/updates_testing: ======================== lib(64)ecpg15_6-15.17-1.mga9 lib(64)pq5-15.17-1.mga9 postgresql15-15.17-1.mga9 postgresql15-contrib-15.17-1.mga9 postgresql15-devel-15.17-1.mga9 postgresql15-docs-15.17-1.mga9 postgresql15-pl-15.17-1.mga9 postgresql15-plperl-15.17-1.mga9 postgresql15-plpgsql-15.17-1.mga9 postgresql15-plpython3-15.17-1.mga9 postgresql15-pltcl-15.17-1.mga9 postgresql15-server-15.17-1.mga9 from SRPM: postgresql15-15.17-1.mga9.src.rpm
Flags: affects_mga9+ => (none)Whiteboard: MGA9TOO => (none)Version: Cauldron => 9Status: NEW => ASSIGNEDSource RPM: postgresql18, postgresql15 => postgresql15-15.16-1.mga9.src.rpm
Assignee: bugsquad => qa-bugs
# systemctl start postgresql [root@mach3 ~]# systemctl -l status postgresql ● postgresql.service - PostgreSQL database server Loaded: loaded (/usr/lib/systemd/system/postgresql.service; disabled; preset: disabled) Active: active (running) since Thu 2026-03-12 16:58:34 CET; 17s ago Process: 30159 ExecStartPre=/usr/libexec/postgresql_initdb.sh ${PGDATA} (code=exited, status=0/SUCCESS) Process: 30162 ExecStart=/usr/bin/pg_ctl start -D ${PGDATA} -s -o -p ${PGPORT} -w -t 300 (code=exited, status=0/SUCCESS) Main PID: 30174 (postgres) Tasks: 7 (limit: 8805) Memory: 23.5M CPU: 283ms CGroup: /system.slice/postgresql.service ├─30174 /usr/bin/postgres -D /var/lib/pgsql/data -p 5432 ├─30220 "postgres: checkpointer " ├─30221 "postgres: background writer " ├─30222 "postgres: walwriter " ├─30223 "postgres: autovacuum launcher " ├─30224 "postgres: stats collector " └─30225 "postgres: logical replication launcher " Mar 12 16:58:33 mach3.hviaene.thuis systemd[1]: Starting postgresql.service... Mar 12 16:58:33 mach3.hviaene.thuis pg_ctl[30174]: 2026-03-12 16:58:33.957 CET [30174] LOG: starting PostgreSQL 13.23 on x86_64-mageia-linux-gnu, c> Mar 12 16:58:33 mach3.hviaene.thuis pg_ctl[30174]: 2026-03-12 16:58:33.960 CET [30174] LOG: listening on IPv6 address "::1", port 5432 Mar 12 16:58:33 mach3.hviaene.thuis pg_ctl[30174]: 2026-03-12 16:58:33.961 CET [30174] LOG: listening on IPv4 address "127.0.0.1", port 5432 Mar 12 16:58:33 mach3.hviaene.thuis pg_ctl[30174]: 2026-03-12 16:58:33.990 CET [30174] LOG: listening on Unix socket "/tmp/.s.PGSQL.5432" Mar 12 16:58:34 mach3.hviaene.thuis pg_ctl[30210]: 2026-03-12 16:58:34.182 CET [30210] LOG: database system was shut down at 2026-02-16 12:20:50 CET Mar 12 16:58:34 mach3.hviaene.thuis pg_ctl[30174]: 2026-03-12 16:58:34.391 CET [30174] LOG: database system is ready to accept connections Mar 12 16:58:34 mach3.hviaene.thuis systemd[1]: Started postgresql.service. Note that a database of the previous veersion still exists. So ... # psql -U postgres psql (15.17, server 13.23) Type "help" for help. postgres=# create database mageia; ERROR: database "mageia" already exists postgres=# \c mageia; psql (15.17, server 13.23) You are now connected to database "mageia" as user "postgres". mageia=# create table mag_versions (name varchar(12), cr_date date); ERROR: relation "mag_versions" already exists mageia=# delete from mag_versions; DELETE 2 mageia=# insert into mag_versions values ('9', '26-Aug-2023'); INSERT 0 1 mageia=# insert into mag_versions values ('8', '2-Feb-2021'); INSERT 0 1 mageia=# select * from mag_versions; name | cr_date ------+------------ 9 | 2023-08-26 8 | 2021-02-02 (2 rows) mageia=# insert into mag_versions values ('10', '25-Jun-2026'); INSERT 0 1 mageia=# delete from mag_versions where name='10'; DELETE 1 mageia=# select * from mag_versions; name | cr_date ------+------------ 9 | 2023-08-26 8 | 2021-02-02 (2 rows) mageia=# quit Then used phppgadmin to login as user testpg, give it privileges: # GRANT ALL ON ALL TABLES IN SCHEMA public TO testerpg; GRANT postgres=# alter user testerpg createdb; ALTER ROLE connect to the database and create my usual table with serial column as PK, char column as unique key, other char column and timestamp column with current_timestamp as default. Inserted a few records. All works OK. Waiting for more tests, plse OK when applicable.
CC: (none) => herman.viaene
Keywords: (none) => advisory
CC: (none) => mageia
Installed and tested without issues. Tested using the CLI command psql (see below). System: Mageia 9, x86_64, Intel(R) Core(TM) i5-4590 CPU @ 3.30GHz. # uname -a Linux marte 6.6.120-server-1.mga9 #1 SMP PREEMPT_DYNAMIC Wed Jan 14 03:15:42 UTC 2026 x86_64 GNU/Linux # rpm -qa | grep 15.17 | sort lib64pq5-15.17-1.mga9 postgresql15-15.17-1.mga9 postgresql15-plpgsql-15.17-1.mga9 postgresql15-server-15.17-1.mga9 # systemctl status postgresql.service ● postgresql.service - PostgreSQL database server Loaded: loaded (/usr/lib/systemd/system/postgresql.service; disabled; preset: disabled) Active: active (running) since Thu 2026-03-19 00:33:04 WET; 2min 33s ago Process: 782062 ExecStartPre=/usr/libexec/postgresql_initdb.sh ${PGDATA} (code=exited, status=0/SUCCESS) Process: 782080 ExecStart=/usr/bin/pg_ctl start -D ${PGDATA} -s -o -p ${PGPORT} -w -t 300 (code=exited, status=0/SUCCESS) Main PID: 782082 (postgres) Tasks: 6 (limit: 19018) Memory: 143.1M CPU: 767ms CGroup: /system.slice/postgresql.service ├─782082 /usr/bin/postgres -D /var/lib/pgsql/data -p 5432 ├─782083 "postgres: checkpointer " ├─782084 "postgres: background writer " ├─782086 "postgres: walwriter " ├─782087 "postgres: autovacuum launcher " └─782088 "postgres: logical replication launcher " mar 19 00:33:01 marte systemd[1]: Starting postgresql.service... mar 19 00:33:04 marte pg_ctl[782082]: 2026-03-19 00:33:04.599 WET [782082] LOG: starting PostgreSQL 15.17 on x86_64-mageia-linux-gnu, compiled by gcc (Mageia 12.3.0-3.mga9) 12.3.0, 64-bit mar 19 00:33:04 marte pg_ctl[782082]: 2026-03-19 00:33:04.600 WET [782082] LOG: listening on IPv4 address "127.0.0.1", port 5432 mar 19 00:33:04 marte pg_ctl[782082]: 2026-03-19 00:33:04.600 WET [782082] LOG: listening on IPv6 address "::1", port 5432 mar 19 00:33:04 marte pg_ctl[782082]: 2026-03-19 00:33:04.602 WET [782082] LOG: listening on Unix socket "/tmp/.s.PGSQL.5432" mar 19 00:33:04 marte pg_ctl[782085]: 2026-03-19 00:33:04.606 WET [782085] LOG: database system was shut down at 2026-03-19 00:33:02 WET mar 19 00:33:04 marte pg_ctl[782082]: 2026-03-19 00:33:04.610 WET [782082] LOG: database system is ready to accept connections mar 19 00:33:04 marte systemd[1]: Started postgresql.service. mar 19 00:33:58 marte pg_ctl[782083]: 2026-03-19 00:33:58.263 WET [782083] LOG: checkpoint starting: immediate force wait mar 19 00:33:58 marte pg_ctl[782083]: 2026-03-19 00:33:58.332 WET [782083] LOG: checkpoint complete: wrote 38 buffers (0.2%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.005 s, sync=0.057 s, total=0.070 s; sync files=32, longe> # su postgres -c psql could not change directory to "/root": Permissão recusada psql (15.17) Type "help" for help. postgres=# CREATE DATABASE test; CREATE DATABASE postgres=# CREATE TABLE test (id INT, data TEXT); CREATE TABLE postgres=# CREATE INDEX test_idx ON test(data); CREATE INDEX postgres=# INSERT INTO test VALUES ('1', 'TEXT 1'); INSERT 0 1 postgres=# INSERT INTO test VALUES ('2', 'TEXT 2'); INSERT 0 1 postgres=# INSERT INTO test VALUES ('3', 'TEXT 3'); INSERT 0 1 postgres=# SELECT * FROM test; id | data ----+-------- 1 | TEXT 1 2 | TEXT 2 3 | TEXT 3 (3 rows) postgres=# DROP DATABASE test; DROP DATABASE postgres=# \q
Should be enough testing to give the OK.
Whiteboard: (none) => MGA9-64-OKFlags: (none) => test_passed_mga9_64+
Validating.
CC: (none) => andrewsfarm, sysadmin-bugsKeywords: (none) => validated_update
An update for this issue has been pushed to the Mageia Updates repository. https://advisories.mageia.org/MGAA-2026-0021.html
Status: ASSIGNED => RESOLVEDResolution: (none) => FIXED