PostgreSQL has released new versions on February 10: https://www.postgresql.org/about/news/postgresql-142-136-1210-1115-and-1020-released-2402/
Source RPM: (none) => postgresql11-11.14-1.mga8.src.rpm, postgresql13-13.5-1.mga8.src.rpmCC: (none) => nicolas.salguero
Suggested advisory: ======================== The updated packages fix some bugs. References: https://www.postgresql.org/about/news/postgresql-142-136-1210-1115-and-1020-released-2402/ ======================== Updated packages in core/updates_testing: ======================== lib(64)pq5.11-11.15-1.mga8 lib(64)ecpg11_6-11.15-1.mga8 postgresql11-11.15-1.mga8 postgresql11-contrib-11.15-1.mga8 postgresql11-devel-11.15-1.mga8 postgresql11-docs-11.15-1.mga8 postgresql11-pl-11.15-1.mga8 postgresql11-plperl-11.15-1.mga8 postgresql11-plpgsql-11.15-1.mga8 postgresql11-plpython3-11.15-1.mga8 postgresql11-pltcl-11.15-1.mga8 postgresql11-server-11.15-1.mga8 lib(64)pq5-13.6-1.mga8 lib(64)ecpg13_6-13.6-1.mga8 postgresql13-13.6-1.mga8 postgresql13-contrib-13.6-1.mga8 postgresql13-devel-13.6-1.mga8 postgresql13-docs-13.6-1.mga8 postgresql13-pl-13.6-1.mga8 postgresql13-plperl-13.6-1.mga8 postgresql13-plpgsql-13.6-1.mga8 postgresql13-plpython3-13.6-1.mga8 postgresql13-pltcl-13.6-1.mga8 postgresql13-server-13.6-1.mga8 from SRPMS: postgresql11-11.15-1.mga8.src.rpm postgresql13-13.6-1.mga8.src.rpm
Status: NEW => ASSIGNEDAssignee: bugsquad => qa-bugs
MGA8-64 Plasma on Lenovo B50 in Dutch. this laptop had already postgres13 installed, so tested the upgrade following bug 29369 Comment 4. # systemctl start postgresql # systemctl -l status postgresql ● postgresql.service - PostgreSQL database server Loaded: loaded (/usr/lib/systemd/system/postgresql.service; disabled; vendor preset: disabled) Active: active (running) since Sat 2022-04-16 11:29:20 CEST; 13s ago Process: 14592 ExecStartPre=/usr/libexec/postgresql_initdb.sh ${PGDATA} (code=exited, status=0/SUCCESS) Process: 14604 ExecStart=/usr/bin/pg_ctl start -D ${PGDATA} -s -o -p ${PGPORT} -w -t 300 (code=exited, status=0/SUCCESS) Main PID: 14606 (postgres) Tasks: 7 (limit: 9402) Memory: 60.4M CPU: 688ms CGroup: /system.slice/postgresql.service ├─14606 /usr/bin/postgres -D /var/lib/pgsql/data -p 5432 ├─14608 postgres: checkpointer ├─14609 postgres: background writer ├─14610 postgres: walwriter ├─14611 postgres: autovacuum launcher ├─14612 postgres: stats collector └─14613 postgres: logical replication launcher apr 16 11:29:18 mach5.hviaene.thuis systemd[1]: Starting PostgreSQL database server... apr 16 11:29:19 mach5.hviaene.thuis pg_ctl[14606]: 2022-04-16 11:29:19.947 CEST [14606] LOG: starting PostgreSQL 13.6 on x86_64-mageia-linux-gnu, compiled by x86_64-mageia-linux-gnu-gcc (Mageia 10.3.> apr 16 11:29:19 mach5.hviaene.thuis pg_ctl[14606]: 2022-04-16 11:29:19.947 CEST [14606] LOG: listening on IPv6 address "::1", port 5432 apr 16 11:29:19 mach5.hviaene.thuis pg_ctl[14606]: 2022-04-16 11:29:19.947 CEST [14606] LOG: listening on IPv4 address "127.0.0.1", port 5432 apr 16 11:29:19 mach5.hviaene.thuis pg_ctl[14606]: 2022-04-16 11:29:19.979 CEST [14606] LOG: listening on Unix socket "/tmp/.s.PGSQL.5432" apr 16 11:29:20 mach5.hviaene.thuis pg_ctl[14607]: 2022-04-16 11:29:20.047 CEST [14607] LOG: database system was shut down at 2022-04-16 11:29:18 CEST apr 16 11:29:20 mach5.hviaene.thuis pg_ctl[14606]: 2022-04-16 11:29:20.082 CEST [14606] LOG: database system is ready to accept connections apr 16 11:29:20 mach5.hviaene.thuis systemd[1]: Started PostgreSQL database server. # su - postgres $ psql psql (13.6) Type "help" for help. postgres=# CREATE DATABASE Mageia; CREATE DATABASE postgres=# SELECT datname FROM pg_database; datname ----------- postgres mageia template1 template0 (4 rows) So far so good. I wanted to test some more database functions,using either pgadmin4 or phppgadmin. Installed those with all their dependencies,but neither of them work,they don't even start properly. This should not block this update, but I would not OKit without some further testing
CC: (none) => herman.viaene
MGA8-64, Xfce - VM The following 16 packages are going to be installed: - lib64ecpg11_6-11.15-1.mga8.x86_64 - lib64openssl-devel-1.1.1n-1.mga8.x86_64 - lib64pq5.11-11.15-1.mga8.x86_64 - lib64zlib-devel-1.2.12-1.1.mga8.x86_64 - lib64zlib1-1.2.12-1.1.mga8.x86_64 - multiarch-utils-1.0.14-3.mga8.noarch - postgresql11-11.15-1.mga8.x86_64 - postgresql11-contrib-11.15-1.mga8.x86_64 - postgresql11-devel-11.15-1.mga8.x86_64 - postgresql11-docs-11.15-1.mga8.noarch - postgresql11-pl-11.15-1.mga8.x86_64 - postgresql11-plperl-11.15-1.mga8.x86_64 - postgresql11-plpgsql-11.15-1.mga8.x86_64 - postgresql11-plpython3-11.15-1.mga8.x86_64 - postgresql11-pltcl-11.15-1.mga8.x86_64 - postgresql11-server-11.15-1.mga8.x86_64 81MB of additional disk space will be used. --- after installation I go into System | Manage system services... and start postgresql. For grins I set On Boot as well I used 29369 Comment 4 like Herman did. It worked without issue [postgres@localhost ~]$ psql psql (11.15) Type "help" for help. postgres=# create database Mageia postgres-# ; CREATE DATABASE postgres=# select datname from pg_database postgres-# ; datname ----------- postgres mageia template1 template0 (4 rows)
CC: (none) => brtians1
MGA8-64 Xfce Installed postgresql 11.11.15.1 Installed Nextcloud 23, using apache, php, and manual nextcloud install System is working.
pgadmin4 is broken (temp files etc. are not set up properly). phppgadmin does work. I chose to use the update for mediawiki to also test the postgresql13 update. Validating the update.
Whiteboard: (none) => MGA8-64-OKCC: (none) => davidwhodgins, sysadmin-bugsKeywords: (none) => validated_update
Blocks: (none) => 30231
Keywords: (none) => advisory
MGA8-32, Mate, VM The following 16 packages are going to be installed: - libecpg13_6-13.6-1.mga8.i586 - libopenssl-devel-1.1.1n-1.mga8.i586 - libpq5-13.6-1.mga8.i586 - libzlib-devel-1.2.12-1.1.mga8.i586 - libzlib1-1.2.12-1.1.mga8.i586 - multiarch-utils-1.0.14-3.mga8.noarch - postgresql13-13.6-1.mga8.i586 - postgresql13-contrib-13.6-1.mga8.i586 - postgresql13-devel-13.6-1.mga8.i586 - postgresql13-docs-13.6-1.mga8.noarch - postgresql13-pl-13.6-1.mga8.i586 - postgresql13-plperl-13.6-1.mga8.i586 - postgresql13-plpgsql-13.6-1.mga8.i586 - postgresql13-plpython3-13.6-1.mga8.i586 - postgresql13-pltcl-13.6-1.mga8.i586 - postgresql13-server-13.6-1.mga8.i586 -- started service su'd over to the postgres ID $ psql psql (13.6) Type "help" for help. postgres=# create database mageia postgres-# ; CREATE DATABASE postgres=# \c mageia You are now connected to database "mageia" as user "postgres". mageia=# mageia=# create table tbl1 (fname varchar(60), lname varchar(60)); CREATE TABLE mageia=# insert into tbl1 values('first', 'last'); INSERT 0 1 mageia=# insert into tbl1 values('first #2', 'last #2'); INSERT 0 1 mageia=# create index id1 on tbl1(lname); CREATE INDEX mageia=# insert into tbl1 values('first #3', 'last #3'); INSERT 0 1 mageia=# select * from tbl1; fname | lname ----------+--------- first | last first #2 | last #2 first #3 | last #3 (3 rows) This is working in 32bit
An update for this issue has been pushed to the Mageia Updates repository. https://advisories.mageia.org/MGAA-2022-0051.html
Resolution: (none) => FIXEDStatus: ASSIGNED => RESOLVED
(In reply to Mageia Robot from comment #7) > An update for this issue has been pushed to the Mageia Updates repository. > > https://advisories.mageia.org/MGAA-2022-0051.html I selected to test the postgresql13 update alongside the mediawiki update. https://doodlecricket.io
CC: (none) => peanutsunless