[PR PATCH] postgresql: update to 12.1

[PR PATCH] postgresql: update to 12.1

[voidlinux-github]

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

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

https://github.com/mustaqimM/void-packages update_postgresql
https://github.com/void-linux/void-packages/pull/18103

postgresql: update to 12.1
[`createlang`](https://stackoverflow.com/questions/52107949/createlang-command-not-found-in-postgres#answer-52109145) and [`droplang`](https://www.postgresql.org/docs/9.6/app-droplang.html) has been deprecated since PostgreSQL 9.1

`plctcl` - Since `createlang` has been deprecated, `CREATE EXTENSION {pltcl,pltclu}` is needed to use it (I don't use this, so could someone please check if it's correct). See [here](https://www.postgresql.org/docs/10/pltcl-overview.html)

New versioning policy since [PostgreSQL 10](https://www.postgresql.org/support/versioning/)

[PostgreSQL 12 release notes](https://www.postgresql.org/docs/current/release-12.html)
[PostgreSQL 11 release notes](https://www.postgresql.org/docs/current/release-11.html)
[PostgreSQL 10 release notes](https://www.postgresql.org/docs/current/release-10.html)

Since more than 1 version has passed, `pg_upgrade` or `pg_dumpall` might be needed to be run on any DBs.

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

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

From 2e165a54d36304c26fe0d46e4bc962a06511bbaa Mon Sep 17 00:00:00 2001
From: mustaqim <mustaqim@pm.me>
Date: Wed, 8 Jan 2020 12:00:17 +0200
Subject: [PATCH] postgresql: update to 12.1

---
 srcpkgs/postgresql/template | 14 ++++++--------
 1 file changed, 6 insertions(+), 8 deletions(-)

diff --git a/srcpkgs/postgresql/template b/srcpkgs/postgresql/template
index 58dbbe1bd9a..734480922a1 100644
--- a/srcpkgs/postgresql/template
+++ b/srcpkgs/postgresql/template
@@ -1,6 +1,6 @@
 # Template file for 'postgresql'
 pkgname=postgresql
-version=9.6.16
+version=12.1
 revision=1
 build_style=gnu-configure
 make_build_target=world
@@ -17,7 +17,8 @@ maintainer="Johannes <johannes.brechtmann@gmail.com>"
 license="PostgreSQL"
 homepage="https://www.postgresql.org"
 distfiles="https://ftp.postgresql.org/pub/source/v${version}/${pkgname}-${version}.tar.bz2"
-checksum=5c6cba9cc0df70ba2b128c4a87d0babfce7c0e2b888f70a9c8485745f66b22e7
+checksum=a09bf3abbaf6763980d0f8acbb943b7629a8b20073de18d867aecdb7988483ed
+
 
 conf_files="
 	/etc/default/${pkgname}
@@ -76,7 +77,7 @@ postgresql-libs_package() {
 	pkg_install() {
 		vmove "usr/lib/*.so*"
 		for d in $(find ${DESTDIR}/usr/share/locale \
-		    -type f -name libpq5\*); do
+			-type f -name libpq5\*); do
 			mkdir -p ${PKGDESTDIR}/$(dirname ${d#${DESTDIR}})
 			mv ${d} ${PKGDESTDIR}/$(dirname ${d#${DESTDIR}})
 		done
@@ -137,14 +138,12 @@ postgresql-pltcl_package() {
 	depends="postgresql>=$version"
 	short_desc="PL/Tcl procedural language for PostgreSQL"
 	pkg_install() {
-		vmove "usr/bin/pltcl*"
 		vmove "usr/lib/postgresql/pltcl*"
 		for d in $(find ${DESTDIR}/usr/share/locale \
 		   -type f -name pltcl\*); do
 			mkdir -p ${PKGDESTDIR}/$(dirname ${d#${DESTDIR}})
 			mv ${d} ${PKGDESTDIR}/$(dirname ${d#${DESTDIR}})
 		done
-		vmove "usr/share/postgresql/*.pltcl"
 	}
 }
 
@@ -153,9 +152,8 @@ fi # !CROSS_BUILD
 postgresql-client_package() {
 	short_desc="Client frontends programs for PostgreSQL"
 	pkg_install() {
-		for f in clusterdb createdb createlang createuser dropdb droplang \
-			dropuser pg_dump pg_dumpall pg_isready pg_restore psql reindexdb \
-			vacuumdb; do
+		for f in clusterdb createdb createuser dropdb dropuser \
+			pg_dump pg_dumpall pg_isready pg_restore psql reindexdb vacuumdb; do
 			vmove usr/bin/${f}
 			vmove usr/share/man/man1/$(basename ${f}).1
 		done

Re: postgresql: update to 12.1

[voidlinux-github]

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

New comment by Chocimier on void-packages repository

https://github.com/void-linux/void-packages/pull/18103#issuecomment-572164213

Comment:
Upgrading with `pg_upgrade` requires to have binaries of both version installed at the same time, and updating with `pg_dumpall` require to bump database before uninstalling old version. Simply upgrading package will make exisiting databases unusable. I am working on separate packages installing version 12 aside, will push in-progress state soon.

Re: postgresql: update to 12.1

[voidlinux-github]

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

New comment by Chocimier on void-packages repository

https://github.com/void-linux/void-packages/pull/18103#issuecomment-572164213

Comment:
Upgrading with `pg_upgrade` requires to have binaries of both version installed at the same time, and updating with `pg_dumpall` require to dump database before uninstalling old version. Simply upgrading package will make exisiting databases unusable. I am working on separate packages installing version 12 aside, will push in-progress state soon.

Re: postgresql: update to 12.1

[voidlinux-github]

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

New comment by mustaqimM on void-packages repository

https://github.com/void-linux/void-packages/pull/18103#issuecomment-572219115

Comment:
sorry, didn't see the PR, multiple versions would be the better method

Re: [PR PATCH] [Closed]: postgresql: update to 12.1

[voidlinux-github]

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

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

postgresql: update to 12.1
https://github.com/void-linux/void-packages/pull/18103

Description:
[`createlang`](https://stackoverflow.com/questions/52107949/createlang-command-not-found-in-postgres#answer-52109145) and [`droplang`](https://www.postgresql.org/docs/9.6/app-droplang.html) has been deprecated since PostgreSQL 9.1

`plctcl` - Since `createlang` has been deprecated, `CREATE EXTENSION {pltcl,pltclu}` is needed to use it (I don't use this, so could someone please check if it's correct). See [here](https://www.postgresql.org/docs/10/pltcl-overview.html)

New versioning policy since [PostgreSQL 10](https://www.postgresql.org/support/versioning/)

[PostgreSQL 12 release notes](https://www.postgresql.org/docs/current/release-12.html)
[PostgreSQL 11 release notes](https://www.postgresql.org/docs/current/release-11.html)
[PostgreSQL 10 release notes](https://www.postgresql.org/docs/current/release-10.html)

Since more than 1 version has passed, `pg_upgrade` or `pg_dumpall` might be needed to be run on any DBs.