GNU bug report logs - #46484
[PATCH 0/4] Update postgresql packages.

Previous Next

To add a comment to this bug, you must first unarchive it, by sending
a message to control AT debbugs.gnu.org, with unarchive 46484 in the body.
You can then email your comments to 46484 AT debbugs.gnu.org in the normal way.

Toggle the display of automated, internal messages from the tracker.

Message #5 received at submit <at> debbugs.gnu.org (full text, mbox):

From: Léo Le Bouter <lle-bout <at> zaclys.net>
To: guix-patches <at> gnu.org
Cc: Léo Le Bouter <lle-bout <at> zaclys.net>
Subject: [PATCH 0/4] Update postgresql packages.
Date: Sat, 13 Feb 2021 08:53:10 +0100

https://www.postgresql.org/about/news/postgresql-132-126-1111-1016-9621-and-9525-released-2165/

They all build successfully.

Léo Le Bouter (4):
  gnu: postgresql-13: Update to 13.2.
  gnu: postgresql-11: Update to 11.11.
  gnu: postgresql-10: Update to 10.16.
  gnu: postgresql-9.6: Update to 9.6.21.

 gnu/packages/databases.scm | 16 ++++++++--------
 1 file changed, 8 insertions(+), 8 deletions(-)

-- 
2.30.1

Message #8 received at 46484 <at> debbugs.gnu.org (full text, mbox):

From: Léo Le Bouter <lle-bout <at> zaclys.net>
To: 46484 <at> debbugs.gnu.org
Cc: Léo Le Bouter <lle-bout <at> zaclys.net>
Subject: [PATCH 3/4] gnu: postgresql-10: Update to 10.16.
Date: Sat, 13 Feb 2021 08:56:06 +0100

* gnu/packages/databases.scm (postgresql-10): Update to 10.16.
---
 gnu/packages/databases.scm | 4 ++--
 1 file changed, 2 insertions(+), 2 deletions(-)

diff --git a/gnu/packages/databases.scm b/gnu/packages/databases.scm
index 0234d9879c..d2ddf3dfea 100644
--- a/gnu/packages/databases.scm
+++ b/gnu/packages/databases.scm
@@ -1258,14 +1258,14 @@ pictures, sounds, or video.")
 (define-public postgresql-10
   (package
     (inherit postgresql-11)
-    (version "10.13")
+    (version "10.16")
     (source (origin
               (inherit (package-source postgresql-11))
               (uri (string-append "https://ftp.postgresql.org/pub/source/v"
                                   version "/postgresql-" version ".tar.bz2"))
               (sha256
                (base32
-                "1qal0yp7a90yzya7hl56gsmw5fvacplrdhpn7h9gnbyr1i2iyw2d"))))))
+                "1cvv8qw0gkkczqhiwx6ns7w88dwkvdz4cvb2d4ff14363f5p2p53"))))))
 
 (define-public postgresql-9.6
   (package
-- 
2.30.1

Message #11 received at 46484 <at> debbugs.gnu.org (full text, mbox):

From: Léo Le Bouter <lle-bout <at> zaclys.net>
To: 46484 <at> debbugs.gnu.org
Cc: Léo Le Bouter <lle-bout <at> zaclys.net>
Subject: [PATCH 1/4] gnu: postgresql-13: Update to 13.2.
Date: Sat, 13 Feb 2021 08:56:04 +0100

* gnu/packages/databases.scm (postgresql-13): Update to 13.2.
---
 gnu/packages/databases.scm | 4 ++--
 1 file changed, 2 insertions(+), 2 deletions(-)

diff --git a/gnu/packages/databases.scm b/gnu/packages/databases.scm
index e0577f1567..2f4de2c902 100644
--- a/gnu/packages/databases.scm
+++ b/gnu/packages/databases.scm
@@ -1194,14 +1194,14 @@ developed in C/C++ to MariaDB and MySQL databases.")
 (define-public postgresql-13
   (package
     (name "postgresql")
-    (version "13.1")
+    (version "13.2")
     (source (origin
               (method url-fetch)
               (uri (string-append "https://ftp.postgresql.org/pub/source/v"
                                   version "/postgresql-" version ".tar.bz2"))
               (sha256
                (base32
-                "07z6zwr58dckaa97yl9ml240z83d1lhgaxw9aq49i8lsp21mqd0j"))
+                "1z5d847jnajcfr3wa6jn52a8xjhamvwzmz18xlm5nvxqip8grmsz"))
               (patches (search-patches "postgresql-disable-resolve_symlinks.patch"))))
     (build-system gnu-build-system)
     (arguments
-- 
2.30.1

Message #14 received at 46484 <at> debbugs.gnu.org (full text, mbox):

From: Léo Le Bouter <lle-bout <at> zaclys.net>
To: 46484 <at> debbugs.gnu.org
Cc: Léo Le Bouter <lle-bout <at> zaclys.net>
Subject: [PATCH 4/4] gnu: postgresql-9.6: Update to 9.6.21.
Date: Sat, 13 Feb 2021 08:56:07 +0100

* gnu/packages/databases.scm (postgresql-9.6): Update to 9.6.21.
---
 gnu/packages/databases.scm | 4 ++--
 1 file changed, 2 insertions(+), 2 deletions(-)

diff --git a/gnu/packages/databases.scm b/gnu/packages/databases.scm
index d2ddf3dfea..1b4d532ad1 100644
--- a/gnu/packages/databases.scm
+++ b/gnu/packages/databases.scm
@@ -1270,14 +1270,14 @@ pictures, sounds, or video.")
 (define-public postgresql-9.6
   (package
     (inherit postgresql-10)
-    (version "9.6.16")
+    (version "9.6.21")
     (source (origin
               (inherit (package-source postgresql-10))
               (uri (string-append "https://ftp.postgresql.org/pub/source/v"
                                   version "/postgresql-" version ".tar.bz2"))
               (sha256
                (base32
-                "1rr2dgv4ams8r2lp13w85c77rkmzpb88fjlc28mvlw6zq2fblv2w"))))))
+                "0d0ngpadf1i7c0i2psaxcbmiwx8334ibcsn283n9fp4853pyl3wk"))))))
 
 (define-public postgresql postgresql-13)
 
-- 
2.30.1

Message #17 received at 46484 <at> debbugs.gnu.org (full text, mbox):

From: Léo Le Bouter <lle-bout <at> zaclys.net>
To: 46484 <at> debbugs.gnu.org
Cc: Léo Le Bouter <lle-bout <at> zaclys.net>
Subject: [PATCH 2/4] gnu: postgresql-11: Update to 11.11.
Date: Sat, 13 Feb 2021 08:56:05 +0100

* gnu/packages/databases.scm (postgresql-11): Update to 11.11.
---
 gnu/packages/databases.scm | 4 ++--
 1 file changed, 2 insertions(+), 2 deletions(-)

diff --git a/gnu/packages/databases.scm b/gnu/packages/databases.scm
index 2f4de2c902..0234d9879c 100644
--- a/gnu/packages/databases.scm
+++ b/gnu/packages/databases.scm
@@ -1246,14 +1246,14 @@ pictures, sounds, or video.")
   (package
     (inherit postgresql-13)
     (name "postgresql")
-    (version "11.6")
+    (version "11.11")
     (source (origin
               (inherit (package-source postgresql-13))
               (uri (string-append "https://ftp.postgresql.org/pub/source/v"
                                   version "/postgresql-" version ".tar.bz2"))
               (sha256
                (base32
-                "0w1iq488kpzfgfnlw4k32lz5by695mpnkq461jrgsr99z5zlz4j9"))))))
+                "0v0qk298nxmpzpgsxcsxma328hdkyzd7fwjs0zsn6zavl5zpnq20"))))))
 
 (define-public postgresql-10
   (package
-- 
2.30.1

Message #20 received at submit <at> debbugs.gnu.org (full text, mbox):

From: Leo Famulari <leo <at> famulari.name>
To: Léo Le Bouter via Guix-patches via <guix-patches <at> gnu.org>
Cc: 46484 <at> debbugs.gnu.org,
 Léo Le Bouter <lle-bout <at> zaclys.net>
Subject: Re: [bug#46484] [PATCH 0/4] Update postgresql packages.
Date: Sat, 13 Feb 2021 13:27:10 -0500

On Sat, Feb 13, 2021 at 08:53:10AM +0100, Léo Le Bouter via Guix-patches via wrote:
> https://www.postgresql.org/about/news/postgresql-132-126-1111-1016-9621-and-9525-released-2165/
> 
> They all build successfully.

Thanks!

There are some system tests that exercise postgres, both postgresql-10
and postgresql. Can you make sure they (or some of them) still pass?

Maybe something like this:

`make check-system TESTS="postgresql zabbix guix-data-service cuirass"

If you aren't sure which tests to try, grep in 'gnu/tests' for
"postgres" and poke around.

And let us know if you don't have the computing resources to run them.
I can test the patches on the build farm in that case.

Message #26 received at submit <at> debbugs.gnu.org (full text, mbox):

From: Léo Le Bouter <lle-bout <at> zaclys.net>
To: Leo Famulari <leo <at> famulari.name>, Léo Le Bouter via
 Guix-patches via <guix-patches <at> gnu.org>
Cc: 46484 <at> debbugs.gnu.org
Subject: Re: [bug#46484] [PATCH 0/4] Update postgresql packages.
Date: Sun, 14 Feb 2021 15:10:11 +0100

[Message part 1 (text/plain, inline)]

> Can you make sure they (or some of them) still pass?

I ran this:

$ TESTS="postgresql zabbix guix-data-service" ./pre-inst-env guix build
-m etc/system-tests.scm 

And it did complete successfully!

/gnu/store/fz735r2c6rxdfjc214zvjayqin4i9aa4-postgresql-test
/gnu/store/h1pjyfp0bcfsswqcr4dvgsfzmj02p378-guix-data-service-test
/gnu/store/5xpdc8gmj5cbglm6dblasrl61m4w1xvz-zabbix-test

However, cuirass test did not work with an unrelated error:

$ TESTS="cuirass" ./pre-inst-env guix build -m etc/system-tests.scm 
guix build: warning: failed to load '(gnu tests cuirass)':
In procedure abi-check: #<record-type <cuirass-remote-worker-
configuration>>: record ABI mismatch; recompilation needed
Selected 0 system tests...

Does that sound good to you for the package upgrades?

[signature.asc (application/pgp-signature, inline)]

Message #32 received at submit <at> debbugs.gnu.org (full text, mbox):

From: Leo Famulari <leo <at> famulari.name>
To: Léo Le Bouter <lle-bout <at> zaclys.net>
Cc: 46484 <at> debbugs.gnu.org, Léo Le Bouter via Guix-patches via
 <guix-patches <at> gnu.org>
Subject: Re: [bug#46484] [PATCH 0/4] Update postgresql packages.
Date: Sun, 14 Feb 2021 13:59:03 -0500

On Sun, Feb 14, 2021 at 03:10:11PM +0100, Léo Le Bouter wrote:
> > Can you make sure they (or some of them) still pass?
> 
> I ran this:
> 
> $ TESTS="postgresql zabbix guix-data-service" ./pre-inst-env guix build
> -m etc/system-tests.scm 
> 
> And it did complete successfully!
> 
> /gnu/store/fz735r2c6rxdfjc214zvjayqin4i9aa4-postgresql-test
> /gnu/store/h1pjyfp0bcfsswqcr4dvgsfzmj02p378-guix-data-service-test
> /gnu/store/5xpdc8gmj5cbglm6dblasrl61m4w1xvz-zabbix-test
> 
> However, cuirass test did not work with an unrelated error:
> 
> $ TESTS="cuirass" ./pre-inst-env guix build -m etc/system-tests.scm 
> guix build: warning: failed to load '(gnu tests cuirass)':
> In procedure abi-check: #<record-type <cuirass-remote-worker-
> configuration>>: record ABI mismatch; recompilation needed
> Selected 0 system tests...

Usually this means you should do `make clean-go && make`, to delete the
compiled Guile objects and rebuild everything with the new ABI.

I'll try it on a powerful server and report back shortly.

Message #38 received at submit <at> debbugs.gnu.org (full text, mbox):

From: Leo Famulari <leo <at> famulari.name>
To: Léo Le Bouter <lle-bout <at> zaclys.net>
Cc: 46484-done <at> debbugs.gnu.org,
 Léo Le Bouter via Guix-patches via <guix-patches <at> gnu.org>
Subject: Re: [bug#46484] [PATCH 0/4] Update postgresql packages.
Date: Sun, 14 Feb 2021 15:00:26 -0500

On Sun, Feb 14, 2021 at 01:59:03PM -0500, Leo Famulari wrote:
> I'll try it on a powerful server and report back shortly.

Success!

I pushed the update of postgresql-13 to staging and the rest to the
master branch as 6941dbf958a2294e0a058af3498df9c46a6a1e50

The guidelines about which branch to push changes to are in the
Submitting Patches section of the manual:

https://guix.gnu.org/manual/devel/en/html_node/Submitting-Patches.html

Postgresql 13 qualifies for the staging branch:

$ guix refresh -l postgresql <at> 13
Building the following 625 packages would ensure 1160 dependent packages are rebuilt: [...]

Message #48 received at 46484 <at> debbugs.gnu.org (full text, mbox):

From: Léo Le Bouter <lle-bout <at> zaclys.net>
To: 46484 <at> debbugs.gnu.org
Cc: Léo Le Bouter <lle-bout <at> zaclys.net>,
 Leo Famulari <leo <at> famulari.name>
Subject: [PATCH] gnu: postgresql-13: Update to 13.2 [security fixes].
Date: Sun, 14 Feb 2021 22:09:13 +0100

Fixes CVE-2021-3393 and CVE-2021-20229.

* gnu/packages/databases.scm (postgresql-13.2): New variable.
(postgresql-13)[replacement]: New field.

Signed-off-by: Leo Famulari <leo <at> famulari.name>
---
 gnu/packages/databases.scm | 15 +++++++++++++++
 1 file changed, 15 insertions(+)

diff --git a/gnu/packages/databases.scm b/gnu/packages/databases.scm
index 9e7e11b380..604b6ad7d6 100644
--- a/gnu/packages/databases.scm
+++ b/gnu/packages/databases.scm
@@ -1203,6 +1203,7 @@ developed in C/C++ to MariaDB and MySQL databases.")
                (base32
                 "07z6zwr58dckaa97yl9ml240z83d1lhgaxw9aq49i8lsp21mqd0j"))
               (patches (search-patches "postgresql-disable-resolve_symlinks.patch"))))
+    (replacement postgresql-13.2)
     (build-system gnu-build-system)
     (arguments
      `(#:configure-flags '("--with-uuid=e2fs" "--with-openssl"
@@ -1242,6 +1243,20 @@ TIMESTAMP.  It also supports storage of binary large objects, including
 pictures, sounds, or video.")
     (license (license:x11-style "file://COPYRIGHT"))))
 
+(define-public postgresql-13.2
+  (package
+    (inherit postgresql-13)
+    (name "postgresql")
+    (version "13.2")
+    (source (origin
+              (method url-fetch)
+              (uri (string-append "https://ftp.postgresql.org/pub/source/v"
+                                  version "/postgresql-" version ".tar.bz2"))
+              (sha256
+               (base32
+                "1z5d847jnajcfr3wa6jn52a8xjhamvwzmz18xlm5nvxqip8grmsz"))
+              (patches (search-patches "postgresql-disable-resolve_symlinks.patch"))))))
+
 (define-public postgresql-11
   (package
     (inherit postgresql-13)
-- 
2.30.1

Message #53 received at 46484-done <at> debbugs.gnu.org (full text, mbox):

From: Leo Famulari <leo <at> famulari.name>
To: Léo Le Bouter <lle-bout <at> zaclys.net>
Cc: 46484-done <at> debbugs.gnu.org
Subject: Re: [PATCH] gnu: postgresql-13: Update to 13.2 [security fixes].
Date: Sun, 14 Feb 2021 16:16:15 -0500

On Sun, Feb 14, 2021 at 10:09:13PM +0100, Léo Le Bouter wrote:
> Fixes CVE-2021-3393 and CVE-2021-20229.
> 
> * gnu/packages/databases.scm (postgresql-13.2): New variable.
> (postgresql-13)[replacement]: New field.
> 
> Signed-off-by: Leo Famulari <leo <at> famulari.name>

Thanks! Pushed as 392e230d5e63fe0f5d7aa9b5085516250630d879

Previous Next

GNU bug tracking system
Copyright (C) 1999 Darren O. Benham, 1997,2003 nCipher Corporation Ltd, 1994-97 Ian Jackson.