PostgreSQL has released new versions on November 10: https://www.postgresql.org/about/news/postgresql-151-146-139-1213-1118-and-1023-released-2543/
CC: (none) => nicolas.salgueroAssignee: bugsquad => nicolas.salguero
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-bugsStatus: NEW => ASSIGNED
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 working
CC: (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.
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-bugsKeywords: (none) => validated_updateWhiteboard: MGA8-64-OK => MGA8-32-OK MGA8-64-OK
CC: (none) => davidwhodginsKeywords: (none) => advisory
An update for this issue has been pushed to the Mageia Updates repository. https://advisories.mageia.org/MGAA-2022-0148.html
Resolution: (none) => FIXEDStatus: ASSIGNED => RESOLVED