Arch Linux

dalu

Member

Registered: 2014-04-16

Posts: 104

postgresql 18 upgrade, git diff patches included

been out for a while
here's a git diff

https://archlinux.org/packages/extra/x86_64/postgresql/

diff --git a/PKGBUILD b/PKGBUILD
index 205a4dc..b86b132 100644
--- a/PKGBUILD
+++ b/PKGBUILD
@@ -7,7 +7,7 @@ pkgname=(
   'postgresql-libs'
   'postgresql-docs'
 )
-pkgver=17.6
+pkgver=18.0
 _majorver=${pkgver%.*}
 pkgrel=1
 pkgdesc='Sophisticated object-relational DBMS'
@@ -57,7 +57,7 @@ source=(
   postgresql.sysusers
   postgresql.tmpfiles
 )
-md5sums=('e72b7e5dc22d44d56b113ed1f74e4084'
+md5sums=('ce1c99eafd54278847a04c299cff80c5'
          'a5b05db6d869c74a2fc0d8f752618b1d'
          'b74d848f5527740dce663ae72f39c5ae'
          'c26bfbec0b715eccfc67d9a42ef80669'
@@ -67,7 +67,7 @@ md5sums=('e72b7e5dc22d44d56b113ed1f74e4084'
          'fe9d4dea2d878a7f0b555b0dae333793'
          'da6a0dda84638d0c3463abf4bc01e621'
          '9138244e0e6b98acc770931a4b150b86')
-sha256sums=('e0630a3600aea27511715563259ec2111cd5f4353a4b040e0be827f94cd7a8b0'
+sha256sums=('0d5b903b1e5fe361bca7aa9507519933773eb34266b1357c4e7780fdee6d6078'
             '2c09429dca9caf540be647fdac9540eeccb68935994bb54cfd3f2108464916c7'
             '0fb4915c06b9767933b27adc329e7319485e043fb9f17b1697b969779a00cf14'
             '4a9bb5c8c02b410646269276345073d478fe285996b1b1564cae5f59ad02a174'
@@ -77,7 +77,7 @@ sha256sums=('e0630a3600aea27511715563259ec2111cd5f4353a4b040e0be827f94cd7a8b0'
             '3a0bbf9fd61259c4898465c55a8b7cd26202885132ff2b5c685dfe0e0ddd4968'
             '3cfe36dd202af56b3ef8e6d6a746b24e6f46f0d9e0d3fa125dbfb5e598170afb'
             'ea771830c15b24c8725ded92e6a9ba9848b13f722357c5f5857dfeb21985d54c')
-b2sums=('9287eab85e17a65333d970bf7d4d254e25295615b4787072ff2a6c705cb66b7775dbe3a0c6b6fa3e2ab37c3278d204ccfdd3e587226d4c1d6363868569149216'
+b2sums=('3ef4759a0292d039e035ddbe20ec3eeb450a68c391363ca29af8c2e31b61a8e2dbd4ae6f37bf8c58e9b21ba0e182eda959d029bc5e061814e13259ab43ff1c1d'
         'c924fd8f58a85d0ed073af7f9778467db6d106b8b66e011048c5148a6b7d02afe4d02451970bd08d351a7356abe7b9a8ea17e3bf1cce32f17977196215d49b5b'
         'd98280e004adcb1ad85053d9bd202a2b4798df6e7a72b21cb263da6b282f42b5463ce77dcc4f0b1b39d3f55303d0f6869b23f2338ffcd98720b0550204adf85a'
         '7a296d7639c72964651973d0d38bc32c8f9c96c65ed8d8e98e520de04cf26c98c361b9567875fca6fc27191eb59709499800076e7bf1354ae6e51c444e7669eb'
@@ -246,7 +246,6 @@ package_postgresql-libs() {
   # these headers are needed by the public headers of the interfaces
   install -m 644 pg_config.h "${pkgdir}/usr/include"
   install -m 644 pg_config_os.h "${pkgdir}/usr/include"
-  install -m 644 pg_config_ext.h "${pkgdir}/usr/include"
   install -m 644 postgres_ext.h "${pkgdir}/usr/include"
   install -m 644 libpq/libpq-fs.h "${pkgdir}/usr/include/libpq"
   install -m 644 pg_config_manual.h "${pkgdir}/usr/include"

builds fine, all tests pass
don't trust, verify

postgresql-old-upgrade
https://archlinux.org/packages/extra/x8 … d-upgrade/

diff --git a/PKGBUILD b/PKGBUILD
index e8150a4..f8fdfee 100644
--- a/PKGBUILD
+++ b/PKGBUILD
@@ -2,7 +2,7 @@
 # Maintainer: Dan McGee <dan@archlinux.org>
 
 pkgname=postgresql-old-upgrade
-pkgver=16.10
+pkgver=17.6
 _majorver=${pkgver%.*}
 pkgrel=1
 pkgdesc='PostgreSQL build for migrating between major versions with pg_upgrade'
@@ -37,9 +37,9 @@ makedepends=(
 source=(
   https://ftp.postgresql.org/pub/source/v${pkgver}/postgresql-${pkgver}.tar.bz2
 )
-md5sums=('96faafa6f2504827038f13c18781dc10')
-sha256sums=('de8485f4ce9c32e3ddfeef0b7c261eed1cecb54c9bcd170e437ff454cb292b42')
-b2sums=('0b07df6cdd92159ca464dec9fc3f86a806a0a5d9829937f1084e914cac55deff4c3f63b8d9ff1dcac01086b1c1d83ed726c00b007ccd57490bef15194181ddd7')
+md5sums=('e72b7e5dc22d44d56b113ed1f74e4084')
+sha256sums=('e0630a3600aea27511715563259ec2111cd5f4353a4b040e0be827f94cd7a8b0')
+b2sums=('9287eab85e17a65333d970bf7d4d254e25295615b4787072ff2a6c705cb66b7775dbe3a0c6b6fa3e2ab37c3278d204ccfdd3e587226d4c1d6363868569149216')
 
 # Upstream provides md5 and sha256

I would've created 2 PRs but I can't register, tried with github, it wants an account.

edit: docs and libs are built from postgresql package

Last edited by dalu (2025-10-04 11:29:59)

gromit

Administrator

From: Germany

Registered: 2024-02-10

Posts: 1,308

Website

Re: postgresql 18 upgrade, git diff patches included

Please write an email to accountsupport@archlinux.org to create an account

dalu

Member

Registered: 2014-04-16

Posts: 104

Re: postgresql 18 upgrade, git diff patches included

Thanks for approving.
PRs already exist, just need to be merged.
Well at least I can contribute now directly