[PR PATCH] postgresql

[PR PATCH] postgresql

[Chocimier]

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

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

https://github.com/Chocimier/void-packages-org postgres
https://github.com/void-linux/void-packages/pull/38723

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

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

<!--
#### 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/38723.patch is attached

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

From e765d7e97551a7785cfefc2e1674f60bd1d260a5 Mon Sep 17 00:00:00 2001
From: =?UTF-8?q?Piotr=20W=C3=B3jcik?= <chocimier@tlen.pl>
Date: Tue, 16 Aug 2022 20:59:57 +0200
Subject: [PATCH 1/2] postgresql13: update to 13.8.

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

diff --git a/srcpkgs/postgresql13/template b/srcpkgs/postgresql13/template
index 08e67ba226bd..1cd078cd6d87 100644
--- a/srcpkgs/postgresql13/template
+++ b/srcpkgs/postgresql13/template
@@ -1,6 +1,6 @@
 # Template file for 'postgresql13'
 pkgname=postgresql13
-version=13.7
+version=13.8
 revision=1
 wrksrc="postgresql-${version}"
 build_style=gnu-configure
@@ -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=1b905bf4f3d83614a393b3c51fd345910fd261e4f5124a68d9a1fdd3a2a46399
+checksum=73876fdd3a517087340458dca4ce15b8d2a4dbceb334c0441424551ae6c4cded
 make_check=ci-skip # Postgres server can't be run as root
 
 conf_files="

From 08771aa6dc36a976627f71f7dbd1be8a95abd481 Mon Sep 17 00:00:00 2001
From: =?UTF-8?q?Piotr=20W=C3=B3jcik?= <chocimier@tlen.pl>
Date: Tue, 16 Aug 2022 20:59:58 +0200
Subject: [PATCH 2/2] postgresql14: update to 14.5.

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

diff --git a/srcpkgs/postgresql14/template b/srcpkgs/postgresql14/template
index 2aa65e684a1d..00584734435c 100644
--- a/srcpkgs/postgresql14/template
+++ b/srcpkgs/postgresql14/template
@@ -1,6 +1,6 @@
 # Template file for 'postgresql14'
 pkgname=postgresql14
-version=14.4
+version=14.5
 revision=1
 wrksrc="postgresql-${version}"
 build_style=gnu-configure
@@ -22,7 +22,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=c23b6237c5231c791511bdc79098617d6852e9e3bdf360efd8b5d15a1a3d8f6a
+checksum=d4f72cb5fb857c9a9f75ec8cf091a1771272802f2178f0b2e65b7b6ff64f4a30
 make_check=ci-skip # Postgres server can't be run as root
 
 conf_files="

Re: postgresql

[Chocimier]

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

New comment by Chocimier on void-packages repository

https://github.com/void-linux/void-packages/pull/38723#issuecomment-1217048234

Comment:
Hi @sgn,

the recursive symlink `/usr/share/zoneinfo/posix` breaks parsing of zones by postgres. Can we change tzdata? Last time that occured - [gentoo, 2015](https://bugs.gentoo.org/show_bug.cgi?id=486532) - it was solved by removing recursive symlink. I haven't found a distro that install zones that way.

Re: postgresql

[sgn]

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

New comment by sgn on void-packages repository

https://github.com/void-linux/void-packages/pull/38723#issuecomment-1217414701

Comment:
I see, the symlink was meant to keep backward compatibility, I will fix them, then.

Re: postgresql

[sgn]

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

New comment by sgn on void-packages repository

https://github.com/void-linux/void-packages/pull/38723#issuecomment-1218007223

Comment:
A new version has been pushed.

Re: [PR PATCH] [Updated] postgresql

[Chocimier]

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

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

https://github.com/Chocimier/void-packages-org postgres
https://github.com/void-linux/void-packages/pull/38723

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

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

<!--
#### 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/38723.patch is attached

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

From 61e91ce99d5cf58f6e24a92f8b99beff62d02f31 Mon Sep 17 00:00:00 2001
From: =?UTF-8?q?Piotr=20W=C3=B3jcik?= <chocimier@tlen.pl>
Date: Mon, 3 Oct 2022 23:12:18 +0200
Subject: [PATCH 1/2] postgresql13: update to 13.8.

---
 srcpkgs/postgresql13/template | 6 +++---
 1 file changed, 3 insertions(+), 3 deletions(-)

diff --git a/srcpkgs/postgresql13/template b/srcpkgs/postgresql13/template
index c208866183f3..1cd078cd6d87 100644
--- a/srcpkgs/postgresql13/template
+++ b/srcpkgs/postgresql13/template
@@ -1,7 +1,7 @@
 # Template file for 'postgresql13'
 pkgname=postgresql13
-version=13.7
-revision=2
+version=13.8
+revision=1
 wrksrc="postgresql-${version}"
 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=1b905bf4f3d83614a393b3c51fd345910fd261e4f5124a68d9a1fdd3a2a46399
+checksum=73876fdd3a517087340458dca4ce15b8d2a4dbceb334c0441424551ae6c4cded
 make_check=ci-skip # Postgres server can't be run as root
 
 conf_files="

From 402cb54fd9d78d90615ba92adc796f2276096110 Mon Sep 17 00:00:00 2001
From: =?UTF-8?q?Piotr=20W=C3=B3jcik?= <chocimier@tlen.pl>
Date: Mon, 3 Oct 2022 23:12:19 +0200
Subject: [PATCH 2/2] postgresql14: update to 14.5.

---
 srcpkgs/postgresql14/template | 6 +++---
 1 file changed, 3 insertions(+), 3 deletions(-)

diff --git a/srcpkgs/postgresql14/template b/srcpkgs/postgresql14/template
index f1b1dbcbb112..00584734435c 100644
--- a/srcpkgs/postgresql14/template
+++ b/srcpkgs/postgresql14/template
@@ -1,7 +1,7 @@
 # Template file for 'postgresql14'
 pkgname=postgresql14
-version=14.4
-revision=2
+version=14.5
+revision=1
 wrksrc="postgresql-${version}"
 build_style=gnu-configure
 make_build_target=world
@@ -22,7 +22,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=c23b6237c5231c791511bdc79098617d6852e9e3bdf360efd8b5d15a1a3d8f6a
+checksum=d4f72cb5fb857c9a9f75ec8cf091a1771272802f2178f0b2e65b7b6ff64f4a30
 make_check=ci-skip # Postgres server can't be run as root
 
 conf_files="

Re: postgresql

[Chocimier]

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

New comment by Chocimier on void-packages repository

https://github.com/void-linux/void-packages/pull/38723#issuecomment-1266074170

Comment:
Thanks, @sgn.

Re: [PR PATCH] [Merged]: postgresql

[Chocimier]

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

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

postgresql
https://github.com/void-linux/void-packages/pull/38723

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

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

<!--
#### 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: [PR PATCH] [Updated] Postgresql

[Chocimier]

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

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

https://github.com/Chocimier/void-packages-org postgres
https://github.com/void-linux/void-packages/pull/45532

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

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

<!--
#### 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/45532.patch is attached

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

From d1abe87f21f08c29bcc74681f6dc72868bd9d963 Mon Sep 17 00:00:00 2001
From: =?UTF-8?q?Piotr=20W=C3=B3jcik?= <chocimier@tlen.pl>
Date: Thu, 10 Aug 2023 17:41:19 +0200
Subject: [PATCH 1/4] postgresql14: update to 14.9.

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

diff --git a/srcpkgs/postgresql14/template b/srcpkgs/postgresql14/template
index a6f290842ff33..be30459a5aca5 100644
--- a/srcpkgs/postgresql14/template
+++ b/srcpkgs/postgresql14/template
@@ -1,7 +1,7 @@
 # Template file for 'postgresql14'
 pkgname=postgresql14
-version=14.8
-revision=5
+version=14.9
+revision=1
 build_style=gnu-configure
 make_build_target=world
 _major="${version%%.*}"
@@ -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=39d38f0030737ed03835debeefee3b37d335462ce4995e2497bc38d621ebe45a
+checksum=b1fe3ba9b1a7f3a9637dd1656dfdad2889016073fd4d35f13b50143cbbb6a8ef
 make_check=ci-skip # Postgres server can't be run as root
 
 conf_files="
@@ -112,6 +112,8 @@ postgresql14-doc_package() {
 postgresql14-libs_package() {
 	short_desc="PostgreSQL shared libraries"
 	conflicts="postgresql9.6-libs>=0 postgresql12-libs>=0 postgresql13-libs>=0"
+	# This package exist to build extensions. Link all to postgresql-libs.
+	noshlibprovides=yes
 	pkg_install() {
 		vmove "${_prefix}/lib/*.so*"
 		for d in $(find ${DESTDIR}/${_prefix}/share/locale \
@@ -124,7 +126,7 @@ postgresql14-libs_package() {
 }
 
 postgresql14-libs-devel_package() {
-	depends="postgresql14-libs>=${version}_${revision} openssl-devel"
+	depends="postgresql-libs>=${version}_${revision} openssl-devel"
 	short_desc="PostgreSQL shared libraries (development files)"
 	conflicts="postgresql9.6-libs-devel>=0 postgresql12-libs-devel>=0 postgresql13-libs-devel>=0"
 	pkg_install() {

From 059490f595c1dfd58ecf83b3601714b946a38f7c Mon Sep 17 00:00:00 2001
From: =?UTF-8?q?Piotr=20W=C3=B3jcik?= <chocimier@tlen.pl>
Date: Thu, 10 Aug 2023 17:41:20 +0200
Subject: [PATCH 2/4] postgresql15: update to 15.4.

---
 srcpkgs/postgresql15/template | 6 +++---
 1 file changed, 3 insertions(+), 3 deletions(-)

diff --git a/srcpkgs/postgresql15/template b/srcpkgs/postgresql15/template
index c817930d91cc9..7ac5762c0d9d5 100644
--- a/srcpkgs/postgresql15/template
+++ b/srcpkgs/postgresql15/template
@@ -1,7 +1,7 @@
 # Template file for 'postgresql15'
 pkgname=postgresql15
-version=15.3
-revision=4
+version=15.4
+revision=1
 build_style=gnu-configure
 make_build_target=world
 _major="${version%%.*}"
@@ -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=ffc7d4891f00ffbf5c3f4eab7fbbced8460b8c0ee63c5a5167133b9e6599d932
+checksum=baec5a4bdc4437336653b6cb5d9ed89be5bd5c0c58b94e0becee0a999e63c8f9
 make_check=ci-skip # Postgres server can't be run as root
 
 conf_files="

From 7445376c7f91bdc7c4a8e4baf5d2d59368f52105 Mon Sep 17 00:00:00 2001
From: =?UTF-8?q?Piotr=20W=C3=B3jcik?= <chocimier@tlen.pl>
Date: Thu, 10 Aug 2023 17:41:22 +0200
Subject: [PATCH 3/4] postgis-postgresql14: update to 3.3.4.

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

diff --git a/srcpkgs/postgis-postgresql14/template b/srcpkgs/postgis-postgresql14/template
index e159771737955..aeb7924719a04 100644
--- a/srcpkgs/postgis-postgresql14/template
+++ b/srcpkgs/postgis-postgresql14/template
@@ -1,6 +1,6 @@
 # Template file for 'postgis-postgresql14'
 pkgname=postgis-postgresql14
-version=3.3.2
+version=3.3.4
 revision=1
 build_style=gnu-configure
 configure_args="
@@ -19,7 +19,7 @@ license="GPL-2.0-or-later"
 homepage="https://postgis.net/"
 changelog="https://git.osgeo.org/gitea/postgis/postgis/raw/tag/${version}/NEWS"
 distfiles="https://download.osgeo.org/postgis/source/postgis-${version}.tar.gz"
-checksum=9a2a219da005a1730a39d1959a1c7cec619b1efb009b65be80ffc25bad299068
+checksum=9d41eaef70e811a4fe2f4a431d144c0c57ce17c2c1a3c938ddaf4e5a3813b0d8
 nocross="FIXME: Cannot run test program to determine PROJ version"
 
 pre_configure() {

From 35bf480444cdac9b41a87cb687b1dc550325d056 Mon Sep 17 00:00:00 2001
From: =?UTF-8?q?Piotr=20W=C3=B3jcik?= <chocimier@tlen.pl>
Date: Thu, 10 Aug 2023 17:41:23 +0200
Subject: [PATCH 4/4] postgis-postgresql15: update to 3.3.4.

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

diff --git a/srcpkgs/postgis-postgresql15/template b/srcpkgs/postgis-postgresql15/template
index eb8650e167550..7f75fb0c1543d 100644
--- a/srcpkgs/postgis-postgresql15/template
+++ b/srcpkgs/postgis-postgresql15/template
@@ -1,6 +1,6 @@
 # Template file for 'postgis-postgresql15'
 pkgname=postgis-postgresql15
-version=3.3.2
+version=3.3.4
 revision=1
 build_style=gnu-configure
 configure_args="
@@ -19,7 +19,7 @@ license="GPL-2.0-or-later"
 homepage="https://postgis.net/"
 changelog="https://git.osgeo.org/gitea/postgis/postgis/raw/tag/${version}/NEWS"
 distfiles="https://download.osgeo.org/postgis/source/postgis-${version}.tar.gz"
-checksum=9a2a219da005a1730a39d1959a1c7cec619b1efb009b65be80ffc25bad299068
+checksum=9d41eaef70e811a4fe2f4a431d144c0c57ce17c2c1a3c938ddaf4e5a3813b0d8
 nocross="FIXME: Cannot run test program to determine PROJ version"
 
 pre_configure() {

Re: [PR PATCH] [Updated] Postgresql

[Chocimier]

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

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

https://github.com/Chocimier/void-packages-org postgres
https://github.com/void-linux/void-packages/pull/45532

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

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

<!--
#### 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/45532.patch is attached

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

From fcda6a322fe03269410e66dd7e11f217620b827f Mon Sep 17 00:00:00 2001
From: =?UTF-8?q?Piotr=20W=C3=B3jcik?= <chocimier@tlen.pl>
Date: Thu, 10 Aug 2023 17:41:19 +0200
Subject: [PATCH 1/4] postgresql14: update to 14.9.

---
 srcpkgs/postgresql14/template | 8 +++++---
 1 file changed, 5 insertions(+), 3 deletions(-)

diff --git a/srcpkgs/postgresql14/template b/srcpkgs/postgresql14/template
index 75703e59eb5fc..be30459a5aca5 100644
--- a/srcpkgs/postgresql14/template
+++ b/srcpkgs/postgresql14/template
@@ -1,7 +1,7 @@
 # Template file for 'postgresql14'
 pkgname=postgresql14
-version=14.8
-revision=3
+version=14.9
+revision=1
 build_style=gnu-configure
 make_build_target=world
 _major="${version%%.*}"
@@ -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=39d38f0030737ed03835debeefee3b37d335462ce4995e2497bc38d621ebe45a
+checksum=b1fe3ba9b1a7f3a9637dd1656dfdad2889016073fd4d35f13b50143cbbb6a8ef
 make_check=ci-skip # Postgres server can't be run as root
 
 conf_files="
@@ -112,6 +112,8 @@ postgresql14-doc_package() {
 postgresql14-libs_package() {
 	short_desc="PostgreSQL shared libraries"
 	conflicts="postgresql9.6-libs>=0 postgresql12-libs>=0 postgresql13-libs>=0"
+	# This package exist to build extensions. Link all to postgresql-libs.
+	noshlibprovides=yes
 	pkg_install() {
 		vmove "${_prefix}/lib/*.so*"
 		for d in $(find ${DESTDIR}/${_prefix}/share/locale \

From 45e1709064171277e54c8ce2fe0fa077eab51822 Mon Sep 17 00:00:00 2001
From: =?UTF-8?q?Piotr=20W=C3=B3jcik?= <chocimier@tlen.pl>
Date: Thu, 10 Aug 2023 17:41:20 +0200
Subject: [PATCH 2/4] postgresql15: update to 15.4.

---
 srcpkgs/postgresql15/template | 6 +++---
 1 file changed, 3 insertions(+), 3 deletions(-)

diff --git a/srcpkgs/postgresql15/template b/srcpkgs/postgresql15/template
index 9764611c3cae7..7ac5762c0d9d5 100644
--- a/srcpkgs/postgresql15/template
+++ b/srcpkgs/postgresql15/template
@@ -1,7 +1,7 @@
 # Template file for 'postgresql15'
 pkgname=postgresql15
-version=15.3
-revision=3
+version=15.4
+revision=1
 build_style=gnu-configure
 make_build_target=world
 _major="${version%%.*}"
@@ -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=ffc7d4891f00ffbf5c3f4eab7fbbced8460b8c0ee63c5a5167133b9e6599d932
+checksum=baec5a4bdc4437336653b6cb5d9ed89be5bd5c0c58b94e0becee0a999e63c8f9
 make_check=ci-skip # Postgres server can't be run as root
 
 conf_files="

From b02e3a0c81fd6792306c49e5c2fa40502ac8d3c1 Mon Sep 17 00:00:00 2001
From: =?UTF-8?q?Piotr=20W=C3=B3jcik?= <chocimier@tlen.pl>
Date: Thu, 10 Aug 2023 17:41:22 +0200
Subject: [PATCH 3/4] postgis-postgresql14: update to 3.3.4.

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

diff --git a/srcpkgs/postgis-postgresql14/template b/srcpkgs/postgis-postgresql14/template
index e159771737955..aeb7924719a04 100644
--- a/srcpkgs/postgis-postgresql14/template
+++ b/srcpkgs/postgis-postgresql14/template
@@ -1,6 +1,6 @@
 # Template file for 'postgis-postgresql14'
 pkgname=postgis-postgresql14
-version=3.3.2
+version=3.3.4
 revision=1
 build_style=gnu-configure
 configure_args="
@@ -19,7 +19,7 @@ license="GPL-2.0-or-later"
 homepage="https://postgis.net/"
 changelog="https://git.osgeo.org/gitea/postgis/postgis/raw/tag/${version}/NEWS"
 distfiles="https://download.osgeo.org/postgis/source/postgis-${version}.tar.gz"
-checksum=9a2a219da005a1730a39d1959a1c7cec619b1efb009b65be80ffc25bad299068
+checksum=9d41eaef70e811a4fe2f4a431d144c0c57ce17c2c1a3c938ddaf4e5a3813b0d8
 nocross="FIXME: Cannot run test program to determine PROJ version"
 
 pre_configure() {

From 0cd4a4bc9b5e765b49ca4e2b811fd51ea4681e62 Mon Sep 17 00:00:00 2001
From: =?UTF-8?q?Piotr=20W=C3=B3jcik?= <chocimier@tlen.pl>
Date: Thu, 10 Aug 2023 17:41:23 +0200
Subject: [PATCH 4/4] postgis-postgresql15: update to 3.3.4.

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

diff --git a/srcpkgs/postgis-postgresql15/template b/srcpkgs/postgis-postgresql15/template
index eb8650e167550..7f75fb0c1543d 100644
--- a/srcpkgs/postgis-postgresql15/template
+++ b/srcpkgs/postgis-postgresql15/template
@@ -1,6 +1,6 @@
 # Template file for 'postgis-postgresql15'
 pkgname=postgis-postgresql15
-version=3.3.2
+version=3.3.4
 revision=1
 build_style=gnu-configure
 configure_args="
@@ -19,7 +19,7 @@ license="GPL-2.0-or-later"
 homepage="https://postgis.net/"
 changelog="https://git.osgeo.org/gitea/postgis/postgis/raw/tag/${version}/NEWS"
 distfiles="https://download.osgeo.org/postgis/source/postgis-${version}.tar.gz"
-checksum=9a2a219da005a1730a39d1959a1c7cec619b1efb009b65be80ffc25bad299068
+checksum=9d41eaef70e811a4fe2f4a431d144c0c57ce17c2c1a3c938ddaf4e5a3813b0d8
 nocross="FIXME: Cannot run test program to determine PROJ version"
 
 pre_configure() {

Re: [PR PATCH] [Updated] Postgresql

[Chocimier]

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

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

https://github.com/Chocimier/void-packages-org postgres
https://github.com/void-linux/void-packages/pull/45532

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

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

<!--
#### 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/45532.patch is attached

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

From b79c0f9c1622d0900d5397c5d75cc8fb4d5c0d62 Mon Sep 17 00:00:00 2001
From: =?UTF-8?q?Piotr=20W=C3=B3jcik?= <chocimier@tlen.pl>
Date: Thu, 10 Aug 2023 17:41:19 +0200
Subject: [PATCH 1/4] postgresql14: update to 14.9.

---
 srcpkgs/postgresql14/template | 6 +++---
 1 file changed, 3 insertions(+), 3 deletions(-)

diff --git a/srcpkgs/postgresql14/template b/srcpkgs/postgresql14/template
index e42d55bb1422f..6275eb83d85b8 100644
--- a/srcpkgs/postgresql14/template
+++ b/srcpkgs/postgresql14/template
@@ -1,7 +1,7 @@
 # Template file for 'postgresql14'
 pkgname=postgresql14
-version=14.8
-revision=2
+version=14.9
+revision=1
 build_style=gnu-configure
 make_build_target=world
 _major="${version%%.*}"
@@ -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=39d38f0030737ed03835debeefee3b37d335462ce4995e2497bc38d621ebe45a
+checksum=b1fe3ba9b1a7f3a9637dd1656dfdad2889016073fd4d35f13b50143cbbb6a8ef
 make_check=ci-skip # Postgres server can't be run as root
 
 conf_files="

From 62fac5ac0ea970f2de562390472c58b3d6614aa4 Mon Sep 17 00:00:00 2001
From: =?UTF-8?q?Piotr=20W=C3=B3jcik?= <chocimier@tlen.pl>
Date: Thu, 10 Aug 2023 17:41:20 +0200
Subject: [PATCH 2/4] postgresql15: update to 15.4.

---
 srcpkgs/postgresql15/template | 6 +++---
 1 file changed, 3 insertions(+), 3 deletions(-)

diff --git a/srcpkgs/postgresql15/template b/srcpkgs/postgresql15/template
index 88e5db2678ebc..7ac5762c0d9d5 100644
--- a/srcpkgs/postgresql15/template
+++ b/srcpkgs/postgresql15/template
@@ -1,7 +1,7 @@
 # Template file for 'postgresql15'
 pkgname=postgresql15
-version=15.3
-revision=2
+version=15.4
+revision=1
 build_style=gnu-configure
 make_build_target=world
 _major="${version%%.*}"
@@ -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=ffc7d4891f00ffbf5c3f4eab7fbbced8460b8c0ee63c5a5167133b9e6599d932
+checksum=baec5a4bdc4437336653b6cb5d9ed89be5bd5c0c58b94e0becee0a999e63c8f9
 make_check=ci-skip # Postgres server can't be run as root
 
 conf_files="

From a6eb424643809e7ff6aa4094d6b7b348348b55c3 Mon Sep 17 00:00:00 2001
From: =?UTF-8?q?Piotr=20W=C3=B3jcik?= <chocimier@tlen.pl>
Date: Thu, 10 Aug 2023 17:41:22 +0200
Subject: [PATCH 3/4] postgis-postgresql14: update to 3.3.4.

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

diff --git a/srcpkgs/postgis-postgresql14/template b/srcpkgs/postgis-postgresql14/template
index e159771737955..aeb7924719a04 100644
--- a/srcpkgs/postgis-postgresql14/template
+++ b/srcpkgs/postgis-postgresql14/template
@@ -1,6 +1,6 @@
 # Template file for 'postgis-postgresql14'
 pkgname=postgis-postgresql14
-version=3.3.2
+version=3.3.4
 revision=1
 build_style=gnu-configure
 configure_args="
@@ -19,7 +19,7 @@ license="GPL-2.0-or-later"
 homepage="https://postgis.net/"
 changelog="https://git.osgeo.org/gitea/postgis/postgis/raw/tag/${version}/NEWS"
 distfiles="https://download.osgeo.org/postgis/source/postgis-${version}.tar.gz"
-checksum=9a2a219da005a1730a39d1959a1c7cec619b1efb009b65be80ffc25bad299068
+checksum=9d41eaef70e811a4fe2f4a431d144c0c57ce17c2c1a3c938ddaf4e5a3813b0d8
 nocross="FIXME: Cannot run test program to determine PROJ version"
 
 pre_configure() {

From d82e3b28cfeec1c101cc117f8e8b8e2652bd0464 Mon Sep 17 00:00:00 2001
From: =?UTF-8?q?Piotr=20W=C3=B3jcik?= <chocimier@tlen.pl>
Date: Thu, 10 Aug 2023 17:41:23 +0200
Subject: [PATCH 4/4] postgis-postgresql15: update to 3.3.4.

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

diff --git a/srcpkgs/postgis-postgresql15/template b/srcpkgs/postgis-postgresql15/template
index eb8650e167550..7f75fb0c1543d 100644
--- a/srcpkgs/postgis-postgresql15/template
+++ b/srcpkgs/postgis-postgresql15/template
@@ -1,6 +1,6 @@
 # Template file for 'postgis-postgresql15'
 pkgname=postgis-postgresql15
-version=3.3.2
+version=3.3.4
 revision=1
 build_style=gnu-configure
 configure_args="
@@ -19,7 +19,7 @@ license="GPL-2.0-or-later"
 homepage="https://postgis.net/"
 changelog="https://git.osgeo.org/gitea/postgis/postgis/raw/tag/${version}/NEWS"
 distfiles="https://download.osgeo.org/postgis/source/postgis-${version}.tar.gz"
-checksum=9a2a219da005a1730a39d1959a1c7cec619b1efb009b65be80ffc25bad299068
+checksum=9d41eaef70e811a4fe2f4a431d144c0c57ce17c2c1a3c938ddaf4e5a3813b0d8
 nocross="FIXME: Cannot run test program to determine PROJ version"
 
 pre_configure() {