Bug 30283

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 => ASSIGNED
Assignee: 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-OK
CC: (none) => davidwhodgins, sysadmin-bugs
Keywords: (none) => validated_update

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) => FIXED
Status: ASSIGNED => RESOLVED