| Summary: | postgresql 11.18 and 13.9 | ||
|---|---|---|---|
| Product: | Mageia | Reporter: | Nicolas Salguero <nicolas.salguero> |
| Component: | RPM Packages | Assignee: | QA Team <qa-bugs> |
| Status: | RESOLVED FIXED | QA Contact: | |
| Severity: | normal | ||
| Priority: | Normal | CC: | andrewsfarm, brtians1, davidwhodgins, herman.viaene, nicolas.salguero, sysadmin-bugs |
| Version: | 8 | Keywords: | advisory, validated_update |
| Target Milestone: | --- | ||
| Hardware: | All | ||
| OS: | Linux | ||
| Whiteboard: | MGA8-32-OK MGA8-64-OK | ||
| Source RPM: | postgresql11-11.17-1.mga8.src.rpm, postgresql13-13.8-1.mga8.src.rpm | CVE: | |
| Status comment: | |||
|
Description
Nicolas Salguero
2022-11-15 09:30:06 CET
Nicolas Salguero
2022-11-15 09:30:22 CET
CC:
(none) =>
nicolas.salguero
Nicolas Salguero
2022-11-15 09:47:35 CET
Source RPM:
(none) =>
postgresql11-11.17-1.mga8.src.rpm, postgresql13-13.8-1.mga8.src.rpm Suggested advisory: ======================== The updated packages fix some bugs. References: https://www.postgresql.org/about/news/postgresql-151-146-139-1213-1118-and-1023-released-2543/ ======================== Updated packages in core/updates_testing: ======================== lib(64)pq5.11-11.18-1.mga8 lib(64)ecpg11_6-11.18-1.mga8 postgresql11-11.18-1.mga8 postgresql11-contrib-11.18-1.mga8 postgresql11-devel-11.18-1.mga8 postgresql11-docs-11.18-1.mga8 postgresql11-pl-11.18-1.mga8 postgresql11-plperl-11.18-1.mga8 postgresql11-plpgsql-11.18-1.mga8 postgresql11-plpython3-11.18-1.mga8 postgresql11-pltcl-11.18-1.mga8 postgresql11-server-11.18-1.mga8 lib(64)pq5-13.9-1.mga8 lib(64)ecpg13_6-13.9-1.mga8 postgresql13-13.9-1.mga8 postgresql13-contrib-13.9-1.mga8 postgresql13-devel-13.9-1.mga8 postgresql13-docs-13.9-1.mga8 postgresql13-pl-13.9-1.mga8 postgresql13-plperl-13.9-1.mga8 postgresql13-plpgsql-13.9-1.mga8 postgresql13-plpython3-13.9-1.mga8 postgresql13-pltcl-13.9-1.mga8 postgresql13-server-13.9-1.mga8 from SRPMS: postgresql11-11.18-1.mga8.src.rpm postgresql13-13.9-1.mga8.src.rpm Assignee:
nicolas.salguero =>
qa-bugs MGA8-64 MATE on Acer Aspire 5253 No installation issues Made sure postgres and httpd are running, then used pgadmin4 to access the database created with the previous version, delete it, create a new one, define in it a table with 4 columns, a primary key, a unique constraint and a default timestamp. Populated the table with some rows, all worked OK. CC:
(none) =>
herman.viaene MGA8-64, Mate, vbox
The following 17 packages are going to be installed:
- glibc-2.32-29.mga8.x86_64
- glibc-devel-2.32-29.mga8.x86_64
- lib64ecpg11_6-11.18-1.mga8.x86_64
- lib64openssl-devel-1.1.1q-1.mga8.x86_64
- lib64pq5.11-11.18-1.mga8.x86_64
- lib64zlib-devel-1.2.12-1.3.mga8.x86_64
- multiarch-utils-1.0.14-3.mga8.noarch
- postgresql11-11.18-1.mga8.x86_64
- postgresql11-contrib-11.18-1.mga8.x86_64
- postgresql11-devel-11.18-1.mga8.x86_64
- postgresql11-docs-11.18-1.mga8.noarch
- postgresql11-pl-11.18-1.mga8.x86_64
- postgresql11-plperl-11.18-1.mga8.x86_64
- postgresql11-plpgsql-11.18-1.mga8.x86_64
- postgresql11-plpython3-11.18-1.mga8.x86_64
- postgresql11-pltcl-11.18-1.mga8.x86_64
- postgresql11-server-11.18-1.mga8.x86_64
Went into system | services and enabled and started postgres
postgres=# select version();
version
--------------------------------------------------------------------------------
--------------------------------------------
PostgreSQL 11.18 on x86_64-mageia-linux-gnu, compiled by x86_64-mageia-linux-gn
u-gcc (Mageia 10.4.0-3.mga8) 10.4.0, 64-bit
(1 row)
postgres=#
[postgres@localhost ~]$ createdb brian
[postgres@localhost ~]$ psql brian
psql (11.18)
Type "help" for help.
brian=# create table mageia8test (name varchar(50), crdate date);
brian=# \d mageia8test
Table "public.mageia8test"
Column | Type | Collation | Nullable | Default
--------+-----------------------+-----------+----------+---------
name | character varying(50) | | |
crdate | date | | |
brian=# insert into mageia8test values ('Mageia', '2022-11-24');
brian=# select * from mageia8test;
name | crdate
--------+------------
Mageia | 2022-11-24
brian=# update Mageia8test set crdate = '2020-02-21' where name = 'Mageia';
UPDATE 1
brian=# select * from mageia8test;
name | crdate
--------+------------
Mageia | 2020-02-21
(1 row)
base level product is workingCC:
(none) =>
brtians1 MGA8-64, Mate, vbox
The following 17 packages are going to be installed:
- glibc-2.32-29.mga8.x86_64
- glibc-devel-2.32-29.mga8.x86_64
- lib64ecpg13_6-13.9-1.mga8.x86_64
- lib64openssl-devel-1.1.1q-1.mga8.x86_64
- lib64pq5-13.9-1.mga8.x86_64
- lib64zlib-devel-1.2.12-1.3.mga8.x86_64
- multiarch-utils-1.0.14-3.mga8.noarch
- postgresql13-13.9-1.mga8.x86_64
- postgresql13-contrib-13.9-1.mga8.x86_64
- postgresql13-devel-13.9-1.mga8.x86_64
- postgresql13-docs-13.9-1.mga8.noarch
- postgresql13-pl-13.9-1.mga8.x86_64
- postgresql13-plperl-13.9-1.mga8.x86_64
- postgresql13-plpgsql-13.9-1.mga8.x86_64
- postgresql13-plpython3-13.9-1.mga8.x86_64
- postgresql13-pltcl-13.9-1.mga8.x86_64
- postgresql13-server-13.9-1.mga8.x86_64
IPL'd
postgres=# select version();
version
--------------------------------------------------------------------------------
-------------------------------------------
PostgreSQL 13.9 on x86_64-mageia-linux-gnu, compiled by x86_64-mageia-linux-gnu
-gcc (Mageia 10.4.0-3.mga8) 10.4.0, 64-bit
(1 row)
postgres=#
postgres=# \q
[postgres@localhost ~]$ createdb post13
[postgres@localhost ~]$ psql post13
psql (13.9)
Type "help" for help.
post13=# create table mageia8test (name varchar(50), crdate date);
CREATE TABLE
post13=# \d mageia8test
Table "public.mageia8test"
Column | Type | Collation | Nullable | Default
--------+-----------------------+-----------+----------+---------
name | character varying(50) | | |
crdate | date | | |
post13=# insert into mageia8test values ('Mageia', '2022-11-24');
INSERT 0 1
post13=# insert into mageia8test values ('Mageia8', '2022-11-24');
INSERT 0 1
post13=# select * from mageia8test;
name | crdate
---------+------------
Mageia | 2022-11-24
Mageia8 | 2022-11-24
(2 rows)
post13=# update Mageia8test set crdate = '2020-02-21' where name = 'Mageia';
UPDATE 1
post13=# select * from mageia8test;
name | crdate
---------+------------
Mageia8 | 2022-11-24
Mageia | 2020-02-21
(2 rows)
post13=# create index b1 on Mageia8test (name);
CREATE INDEX
post13=# \d mageia8test
Table "public.mageia8test"
Column | Type | Collation | Nullable | Default
--------+-----------------------+-----------+----------+---------
name | character varying(50) | | |
crdate | date | | |
Indexes:
"b1" btree (name)
post13=# insert into mageia8test values ('Mageia9', '2023-2-4');
INSERT 0 1
post13=# select * from mageia8test;
name | crdate
---------+------------
Mageia8 | 2022-11-24
Mageia | 2020-02-21
Mageia9 | 2023-02-04
(3 rows)
post13=# update Mageia8test set crdate = '2010-02-21' where name = 'Mageia';
UPDATE 1
post13=# select * from mageia8test;
name | crdate
---------+------------
Mageia8 | 2022-11-24
Mageia9 | 2023-02-04
Mageia | 2010-02-21
(3 rows)
working for me
MGA8-32, Mate, Vbox
The following 17 packages are going to be installed:
- glibc-2.32-29.mga8.i586
- glibc-devel-2.32-29.mga8.i586
- libecpg11_6-11.18-1.mga8.i586
- libopenssl-devel-1.1.1q-1.mga8.i586
- libpq5.11-11.18-1.mga8.i586
- libzlib-devel-1.2.12-1.3.mga8.i586
- multiarch-utils-1.0.14-3.mga8.noarch
- postgresql11-11.18-1.mga8.i586
- postgresql11-contrib-11.18-1.mga8.i586
- postgresql11-devel-11.18-1.mga8.i586
- postgresql11-docs-11.18-1.mga8.noarch
- postgresql11-pl-11.18-1.mga8.i586
- postgresql11-plperl-11.18-1.mga8.i586
- postgresql11-plpgsql-11.18-1.mga8.i586
- postgresql11-plpython3-11.18-1.mga8.i586
- postgresql11-pltcl-11.18-1.mga8.i586
- postgresql11-server-11.18-1.mga8.i586
80MB of additional disk space will be used.
IPL'd
[postgres@localhost ~]$ psql
psql (11.18)
Type "help" for help.
postgres=# select version();
version
--------------------------------------------------------------------------------
----------------------------------------
PostgreSQL 11.18 on i586-mageia-linux-gnu, compiled by i586-mageia-linux-gnu-gc
c (Mageia 10.4.0-3.mga8) 10.4.0, 32-bit
(1 row)
postgres=#
[postgres@localhost ~]$ createdb post11
[postgres@localhost ~]$ psql post11
psql (11.18)
Type "help" for help.
post11=# create table mageia8test (name varchar(50), crdate date);
CREATE TABLE
post11=# \d mageia8test
Table "public.mageia8test"
Column | Type | Collation | Nullable | Default
--------+-----------------------+-----------+----------+---------
name | character varying(50) | | |
crdate | date | | |
post11=# insert into mageia8test values ('Mageia', '2022-11-24');
INSERT 0 1
post11=# insert into mageia8test values ('Mageia8', '2022-11-24');
INSERT 0 1
post11=# select * from mageia8test;
name | crdate
---------+------------
Mageia | 2022-11-24
Mageia8 | 2022-11-24
(2 rows)
post11=# create index b1 on Mageia8test (name);
CREATE INDEX
post11=# update Mageia8test set crdate = '2020-02-21' where name = 'Mageia';
UPDATE 1
post11=# select * from mageia8test;
name | crdate
---------+------------
Mageia8 | 2022-11-24
Mageia | 2020-02-21
(2 rows)
post11=# insert into mageia8test values ('Mageia9', '2023-2-4');
INSERT 0 1
post11=# select * from mageia8test;
name | crdate
---------+------------
Mageia8 | 2022-11-24
Mageia | 2020-02-21
Mageia9 | 2023-02-04
(3 rows)
Works - I'm done.
Brian Rockwell
2022-11-24 18:56:32 CET
Whiteboard:
(none) =>
MGA8-64-OK Also giving this a 32-bit OK because of comment 5. Validating. Advisory in Comment 1. CC:
(none) =>
andrewsfarm, sysadmin-bugs
Dave Hodgins
2022-11-27 19:00:12 CET
CC:
(none) =>
davidwhodgins An update for this issue has been pushed to the Mageia Updates repository. https://advisories.mageia.org/MGAA-2022-0148.html Resolution:
(none) =>
FIXED |