[PR PATCH] Rebuild postgresql for glibc upgrade

[PR PATCH] Rebuild postgresql for glibc upgrade

[tsndqst]

[-- Attachment #1: Type: text/plain, Size: 2206 bytes --]

There is a new pull request by tsndqst against master on the void-packages repository

https://github.com/tsndqst/void-packages rebuild-postgresql
https://github.com/void-linux/void-packages/pull/47977

Rebuild postgresql for glibc upgrade
Due to the [glibc update](https://github.com/void-linux/void-packages/pull/45501) a few days ago Postgresql needs to be rebuilt.
The following warning is shown when connecting to postgres after upgrading glibc.
```
WARNING:  database "postgres" has a collation version mismatch
DETAIL:  The database was created using collation version 2.36, but the operating system provides version 2.38.
HINT:  Rebuild all objects in this database that use the default collation and run ALTER DATABASE postgres REFRESH COLLATION VERSION, or build PostgreSQL with the right library version.
```
Since there is a new patch release for Postgresql available I decided to bump the version too.  If we just want to rebuild the existing versions I can change the template to continue using the current versions.

<!-- Uncomment relevant sections and delete options which are not applicable -->

#### Testing the changes
- I tested the changes in this PR: **NO** - my local environment fails during configure trying to find `perl.h` even though it is installed.  Perhaps it will work better in Github Actions.

<!--
#### New package
- This new package conforms to the [package requirements](https://github.com/void-linux/void-packages/blob/master/CONTRIBUTING.md#package-requirements): **YES**|**NO**
-->

<!-- Note: If the build is likely to take more than 2 hours, please add ci skip tag as described in
https://github.com/void-linux/void-packages/blob/master/CONTRIBUTING.md#continuous-integration
and test at least one native build and, if supported, at least one cross build.
Ignore this section if this PR is not skipping CI.
-->
<!--
#### Local build testing
- I built this PR locally for my native architecture, (ARCH-LIBC)
- I built this PR locally for these architectures (if supported. mark crossbuilds):
  - aarch64-musl
  - armv7l
  - armv6l-musl
-->


A patch file from https://github.com/void-linux/void-packages/pull/47977.patch is attached

[-- Warning: decoded text below may be mangled, UTF-8 assumed --]
[-- Attachment #2: github-pr-rebuild-postgresql-47977.patch --]
[-- Type: text/x-diff, Size: 2271 bytes --]

From 7c6bcd38b2d58dbe2d3416af45ec78566706d066 Mon Sep 17 00:00:00 2001
From: Tim Sandquist <tim.sandquist@gmail.com>
Date: Fri, 29 Dec 2023 08:39:51 -0600
Subject: [PATCH 1/2] postgresql14: update to 14.10.

---
 srcpkgs/postgresql14/template | 4 ++--
 1 file changed, 2 insertions(+), 2 deletions(-)

diff --git a/srcpkgs/postgresql14/template b/srcpkgs/postgresql14/template
index be30459a5aca5..7c3162ba7440f 100644
--- a/srcpkgs/postgresql14/template
+++ b/srcpkgs/postgresql14/template
@@ -1,6 +1,6 @@
 # Template file for 'postgresql14'
 pkgname=postgresql14
-version=14.9
+version=14.10
 revision=1
 build_style=gnu-configure
 make_build_target=world
@@ -21,7 +21,7 @@ license="PostgreSQL"
 homepage="https://www.postgresql.org"
 changelog="https://www.postgresql.org/docs/current/release-${version//./-}.html"
 distfiles="https://ftp.postgresql.org/pub/source/v${version}/postgresql-${version}.tar.bz2"
-checksum=b1fe3ba9b1a7f3a9637dd1656dfdad2889016073fd4d35f13b50143cbbb6a8ef
+checksum=c99431c48e9d470b0d0ab946eb2141a3cd19130c2fb4dc4b3284a7774ecc8399
 make_check=ci-skip # Postgres server can't be run as root
 
 conf_files="

From 727d51a164c574bd3c19877a9b4c994b0329f234 Mon Sep 17 00:00:00 2001
From: Tim Sandquist <tim.sandquist@gmail.com>
Date: Fri, 29 Dec 2023 08:39:54 -0600
Subject: [PATCH 2/2] postgresql15: update to 15.5.

---
 srcpkgs/postgresql15/template | 4 ++--
 1 file changed, 2 insertions(+), 2 deletions(-)

diff --git a/srcpkgs/postgresql15/template b/srcpkgs/postgresql15/template
index 7ac5762c0d9d5..c1b186288121e 100644
--- a/srcpkgs/postgresql15/template
+++ b/srcpkgs/postgresql15/template
@@ -1,6 +1,6 @@
 # Template file for 'postgresql15'
 pkgname=postgresql15
-version=15.4
+version=15.5
 revision=1
 build_style=gnu-configure
 make_build_target=world
@@ -21,7 +21,7 @@ license="PostgreSQL"
 homepage="https://www.postgresql.org"
 changelog="https://www.postgresql.org/docs/current/release-${version//./-}.html"
 distfiles="https://ftp.postgresql.org/pub/source/v${version}/postgresql-${version}.tar.bz2"
-checksum=baec5a4bdc4437336653b6cb5d9ed89be5bd5c0c58b94e0becee0a999e63c8f9
+checksum=8f53aa95d78eb8e82536ea46b68187793b42bba3b4f65aa342f540b23c9b10a6
 make_check=ci-skip # Postgres server can't be run as root
 
 conf_files="

Re: Rebuild postgresql for glibc upgrade

[tsndqst]

[-- Attachment #1: Type: text/plain, Size: 502 bytes --]

New comment by tsndqst on void-packages repository

https://github.com/void-linux/void-packages/pull/47977#issuecomment-1872153866

Comment:
Looks like it is a problem with the perl package.  The postgresql configure script hides the reason perl.h can't be used.  I tested a couple other packages (ImageMagick and hexchat) that also compile against perl and they showed the issue more clearly.
```
/usr/lib/perl5/core_perl/CORE/reentr.h:124:16: fatal error: crypt.h: No such file or directory
```

Re: [PR PATCH] [Updated] Rebuild postgresql for glibc upgrade

[tsndqst]

[-- Attachment #1: Type: text/plain, Size: 2252 bytes --]

There is an updated pull request by tsndqst against master on the void-packages repository

https://github.com/tsndqst/void-packages rebuild-postgresql
https://github.com/void-linux/void-packages/pull/47977

Rebuild postgresql for glibc upgrade
Due to the [glibc update](https://github.com/void-linux/void-packages/pull/45501) a few days ago Postgresql needs to be rebuilt.
The following warning is shown when connecting to postgres after upgrading glibc.
```
WARNING:  database "postgres" has a collation version mismatch
DETAIL:  The database was created using collation version 2.36, but the operating system provides version 2.38.
HINT:  Rebuild all objects in this database that use the default collation and run ALTER DATABASE postgres REFRESH COLLATION VERSION, or build PostgreSQL with the right library version.
```
Since there is a new patch release for Postgresql available I decided to bump the version too.  If we just want to rebuild the existing versions I can change the template to continue using the current versions.

UPDATE: I installed the package created by this PR but the warning above didn't change.  I ended up running `ALTER DATABASE postgres REFRESH COLLATION VERSION` to resolve the warning.

<!-- Uncomment relevant sections and delete options which are not applicable -->

#### Testing the changes
- I tested the changes in this PR: **YES**

<!--
#### New package
- This new package conforms to the [package requirements](https://github.com/void-linux/void-packages/blob/master/CONTRIBUTING.md#package-requirements): **YES**|**NO**
-->

<!-- Note: If the build is likely to take more than 2 hours, please add ci skip tag as described in
https://github.com/void-linux/void-packages/blob/master/CONTRIBUTING.md#continuous-integration
and test at least one native build and, if supported, at least one cross build.
Ignore this section if this PR is not skipping CI.
-->
<!--
#### Local build testing
- I built this PR locally for my native architecture, (ARCH-LIBC)
- I built this PR locally for these architectures (if supported. mark crossbuilds):
  - aarch64-musl
  - armv7l
  - armv6l-musl
-->


A patch file from https://github.com/void-linux/void-packages/pull/47977.patch is attached

[-- Warning: decoded text below may be mangled, UTF-8 assumed --]
[-- Attachment #2: github-pr-rebuild-postgresql-47977.patch --]
[-- Type: text/x-diff, Size: 2271 bytes --]

From 1947038b7a96017ec80c63bcd9199b2f17ff4420 Mon Sep 17 00:00:00 2001
From: Tim Sandquist <tim.sandquist@gmail.com>
Date: Fri, 29 Dec 2023 08:39:51 -0600
Subject: [PATCH 1/2] postgresql14: update to 14.10.

---
 srcpkgs/postgresql14/template | 4 ++--
 1 file changed, 2 insertions(+), 2 deletions(-)

diff --git a/srcpkgs/postgresql14/template b/srcpkgs/postgresql14/template
index be30459a5aca5..7c3162ba7440f 100644
--- a/srcpkgs/postgresql14/template
+++ b/srcpkgs/postgresql14/template
@@ -1,6 +1,6 @@
 # Template file for 'postgresql14'
 pkgname=postgresql14
-version=14.9
+version=14.10
 revision=1
 build_style=gnu-configure
 make_build_target=world
@@ -21,7 +21,7 @@ license="PostgreSQL"
 homepage="https://www.postgresql.org"
 changelog="https://www.postgresql.org/docs/current/release-${version//./-}.html"
 distfiles="https://ftp.postgresql.org/pub/source/v${version}/postgresql-${version}.tar.bz2"
-checksum=b1fe3ba9b1a7f3a9637dd1656dfdad2889016073fd4d35f13b50143cbbb6a8ef
+checksum=c99431c48e9d470b0d0ab946eb2141a3cd19130c2fb4dc4b3284a7774ecc8399
 make_check=ci-skip # Postgres server can't be run as root
 
 conf_files="

From c7865e800f62b4d25968e1fde19f6c042a0ffec8 Mon Sep 17 00:00:00 2001
From: Tim Sandquist <tim.sandquist@gmail.com>
Date: Fri, 29 Dec 2023 08:39:54 -0600
Subject: [PATCH 2/2] postgresql15: update to 15.5.

---
 srcpkgs/postgresql15/template | 4 ++--
 1 file changed, 2 insertions(+), 2 deletions(-)

diff --git a/srcpkgs/postgresql15/template b/srcpkgs/postgresql15/template
index 7ac5762c0d9d5..c1b186288121e 100644
--- a/srcpkgs/postgresql15/template
+++ b/srcpkgs/postgresql15/template
@@ -1,6 +1,6 @@
 # Template file for 'postgresql15'
 pkgname=postgresql15
-version=15.4
+version=15.5
 revision=1
 build_style=gnu-configure
 make_build_target=world
@@ -21,7 +21,7 @@ license="PostgreSQL"
 homepage="https://www.postgresql.org"
 changelog="https://www.postgresql.org/docs/current/release-${version//./-}.html"
 distfiles="https://ftp.postgresql.org/pub/source/v${version}/postgresql-${version}.tar.bz2"
-checksum=baec5a4bdc4437336653b6cb5d9ed89be5bd5c0c58b94e0becee0a999e63c8f9
+checksum=8f53aa95d78eb8e82536ea46b68187793b42bba3b4f65aa342f540b23c9b10a6
 make_check=ci-skip # Postgres server can't be run as root
 
 conf_files="

Re: Rebuild postgresql for glibc upgrade

[tsndqst]

[-- Attachment #1: Type: text/plain, Size: 217 bytes --]

New comment by tsndqst on void-packages repository

https://github.com/void-linux/void-packages/pull/47977#issuecomment-1872990981

Comment:
@chocimier what do you think about this PR and the glibc/collation warning?

Re: Rebuild postgresql for glibc upgrade

[Chocimier]

[-- Attachment #1: Type: text/plain, Size: 471 bytes --]

New comment by Chocimier on void-packages repository

https://github.com/void-linux/void-packages/pull/47977#issuecomment-1873048388

Comment:
IIUC the <https://www.postgresql.org/docs/current/sql-altercollation.html>, data in tables need to be refreshed to match the updated glibc.
The `right library version` mentioned in warning would be `glibc 2.36`. Using it to build our postgres is not an option. So we cannot fix issue centrally.

Thanks for reporting anyway.

Re: [PR PATCH] [Closed]: Rebuild postgresql for glibc upgrade

[Chocimier]

[-- Attachment #1: Type: text/plain, Size: 2085 bytes --]

There's a closed pull request on the void-packages repository

Rebuild postgresql for glibc upgrade
https://github.com/void-linux/void-packages/pull/47977

Description:
Due to the [glibc update](https://github.com/void-linux/void-packages/pull/45501) a few days ago Postgresql needs to be rebuilt.
The following warning is shown when connecting to postgres after upgrading glibc.
```
WARNING:  database "postgres" has a collation version mismatch
DETAIL:  The database was created using collation version 2.36, but the operating system provides version 2.38.
HINT:  Rebuild all objects in this database that use the default collation and run ALTER DATABASE postgres REFRESH COLLATION VERSION, or build PostgreSQL with the right library version.
```
Since there is a new patch release for Postgresql available I decided to bump the version too.  If we just want to rebuild the existing versions I can change the template to continue using the current versions.

UPDATE: I installed the package created by this PR but the warning above didn't change.  I ended up running `ALTER DATABASE postgres REFRESH COLLATION VERSION` to resolve the warning.

<!-- Uncomment relevant sections and delete options which are not applicable -->

#### Testing the changes
- I tested the changes in this PR: **YES**

<!--
#### New package
- This new package conforms to the [package requirements](https://github.com/void-linux/void-packages/blob/master/CONTRIBUTING.md#package-requirements): **YES**|**NO**
-->

<!-- Note: If the build is likely to take more than 2 hours, please add ci skip tag as described in
https://github.com/void-linux/void-packages/blob/master/CONTRIBUTING.md#continuous-integration
and test at least one native build and, if supported, at least one cross build.
Ignore this section if this PR is not skipping CI.
-->
<!--
#### Local build testing
- I built this PR locally for my native architecture, (ARCH-LIBC)
- I built this PR locally for these architectures (if supported. mark crossbuilds):
  - aarch64-musl
  - armv7l
  - armv6l-musl
-->

Re: Rebuild postgresql for glibc upgrade

[Chocimier]

[-- Attachment #1: Type: text/plain, Size: 161 bytes --]

New comment by Chocimier on void-packages repository

https://github.com/void-linux/void-packages/pull/47977#issuecomment-1874512343

Comment:
Updated in #48022