Hi,
Here is a diff to update PostgreSQL to it's latest version (10.6).
Release note : https://www.postgresql.org/about/news/1905/
(It fixes CVE-2018-16850)
Tested on @amd64.
Comments, ok ?
Regards,
Index: Makefile
===================================================================
RCS file: /cvs/ports/databases/postgresql/Makefile,v
retrieving revision 1.243
diff -u -p -u -p -r1.243 Makefile
--- Makefile 4 Oct 2018 14:48:15 -0000 1.243
+++ Makefile 8 Nov 2018 17:31:49 -0000
@@ -7,7 +7,7 @@ COMMENT-contrib=PostgreSQL RDBMS contrib
COMMENT-plpython=Python procedural language for PostgreSQL
COMMENT-pg_upgrade=Support for upgrading PostgreSQL data from previous version
-VERSION= 10.5
+VERSION= 10.6
PREV_MAJOR= 9.6
DISTNAME= postgresql-${VERSION}
PKGNAME-main= postgresql-client-${VERSION}
@@ -16,11 +16,6 @@ PKGNAME-docs= postgresql-docs-${VERSION}
PKGNAME-contrib=postgresql-contrib-${VERSION}
PKGNAME-plpython=postgresql-plpython-${VERSION}
PKGNAME-pg_upgrade=postgresql-pg_upgrade-${VERSION}
-REVISION-main= 1
-REVISION-server= 4
-REVISION-contrib= 0
-REVISION-plpython= 0
-REVISION-pg_upgrade= 0
CATEGORIES= databases
SHARED_LIBS= ecpg 7.9 \
@@ -35,7 +30,7 @@ MAINTAINER= Pierre-Emmanuel Andre <pea@o
# BSD
PERMIT_PACKAGE_CDROM= Yes
-WANTLIB += c crypto m readline ssl termcap z
+WANTLIB += c crypto curses m readline ssl z
MASTER_SITES= https://ftp.postgresql.org/pub/source/v${VERSION}/ \
ftp://ftp.postgresql.org/pub/source/v${VERSION}/
@@ -93,18 +88,19 @@ WANTLIB-main = ${WANTLIB} xml2
LIB_DEPENDS-server= databases/postgresql=${VERSION} \
${LIB_DEPENDS-main}
-WANTLIB-server= ${WANTLIB-main} perl pq>=4
+WANTLIB-server= ${WANTLIB-main} perl
RUN_DEPENDS-contrib= databases/postgresql,-server=${VERSION}
LIB_DEPENDS-contrib= databases/postgresql=${VERSION} \
${LIB_DEPENDS-main}
-WANTLIB-contrib= ${WANTLIB-main} pq>=4 perl
+WANTLIB-contrib= ${WANTLIB-main} perl
RUN_DEPENDS-pg_upgrade= databases/postgresql,-server=${VERSION} \
databases/postgresql-previous>=${PREV_MAJOR}
LIB_DEPENDS-pg_upgrade= databases/postgresql=${VERSION} \
${LIB_DEPENDS-main}
-WANTLIB-pg_upgrade= ${WANTLIB-main} pq>=4
+
+WANTLIB-pg_upgrade = ${WANTLIB-main}
LIB_DEPENDS-plpython= ${MODPY_LIB_DEPENDS}
WANTLIB-plpython = c m pthread util \
Index: distinfo
===================================================================
RCS file: /cvs/ports/databases/postgresql/distinfo,v
retrieving revision 1.74
diff -u -p -u -p -r1.74 distinfo
--- distinfo 9 Aug 2018 15:32:36 -0000 1.74
+++ distinfo 8 Nov 2018 17:31:49 -0000
@@ -1,2 +1,2 @@
-SHA256 (postgresql-10.5.tar.gz) = E75wU7HYrU4klDsk2AFwV0/HAbSbPxTmil8b2kUs49E=
-SIZE (postgresql-10.5.tar.gz) = 26818092
+SHA256 (postgresql-10.6.tar.gz) = fMtwrJHZaOMvZCpPQKeIUkU1L6t+6FMO3OEn3qbmICs=
+SIZE (postgresql-10.6.tar.gz) = 26902911
Index: patches/patch-src_pl_plperl_GNUmakefile
===================================================================
RCS file: patches/patch-src_pl_plperl_GNUmakefile
diff -N patches/patch-src_pl_plperl_GNUmakefile
--- patches/patch-src_pl_plperl_GNUmakefile 14 Aug 2017 11:56:54 -0000 1.2
+++ /dev/null 1 Jan 1970 00:00:00 -0000
@@ -1,14 +0,0 @@
-$OpenBSD: patch-src_pl_plperl_GNUmakefile,v 1.2 2017/08/14 11:56:54 pea Exp $
-
-Index: src/pl/plperl/GNUmakefile
---- src/pl/plperl/GNUmakefile.orig
-+++ src/pl/plperl/GNUmakefile
-@@ -16,7 +16,7 @@ endif
- # probably because it sometimes contains some header files with names
- # that clash with some of ours, or with some that we include, notably on
- # Windows.
--override CPPFLAGS := -I. -I$(srcdir) $(CPPFLAGS) $(perl_embed_ccflags) -I$(perl_archlibexp)/CORE
-+override CPPFLAGS := -I. -I$(srcdir) $(CPPFLAGS) $(perl_embed_ccflags) -I$(perl_archlibexp)/CORE -DNO_LOCALE_NUMERIC -DNO_LOCALE_COLLATE -DBIG_TIME
-
- rpathdir = $(perl_archlibexp)/CORE
-
Index: pkg/PLIST-contrib
===================================================================
RCS file: /cvs/ports/databases/postgresql/pkg/PLIST-contrib,v
retrieving revision 1.18
diff -u -p -u -p -r1.18 PLIST-contrib
--- pkg/PLIST-contrib 17 May 2018 18:42:42 -0000 1.18
+++ pkg/PLIST-contrib 8 Nov 2018 17:31:49 -0000
@@ -188,6 +188,7 @@ share/postgresql/extension/pg_stat_state
share/postgresql/extension/pg_stat_statements--1.2--1.3.sql
share/postgresql/extension/pg_stat_statements--1.3--1.4.sql
share/postgresql/extension/pg_stat_statements--1.4--1.5.sql
+share/postgresql/extension/pg_stat_statements--1.5--1.6.sql
share/postgresql/extension/pg_stat_statements--1.4.sql
share/postgresql/extension/pg_stat_statements--unpackaged--1.0.sql
share/postgresql/extension/pg_stat_statements.control
Index: pkg/PLIST-docs
===================================================================
RCS file: /cvs/ports/databases/postgresql/pkg/PLIST-docs,v
retrieving revision 1.86
diff -u -p -u -p -r1.86 PLIST-docs
--- pkg/PLIST-docs 9 Aug 2018 15:32:36 -0000 1.86
+++ pkg/PLIST-docs 8 Nov 2018 17:31:49 -0000
@@ -657,6 +657,7 @@ share/doc/postgresql/html/release-10-2.h
share/doc/postgresql/html/release-10-3.html
share/doc/postgresql/html/release-10-4.html
share/doc/postgresql/html/release-10-5.html
+share/doc/postgresql/html/release-10-6.html
share/doc/postgresql/html/release-10.html
share/doc/postgresql/html/release-6-0.html
share/doc/postgresql/html/release-6-1-1.html
@@ -956,6 +957,7 @@ share/doc/postgresql/html/release-9-3-21
share/doc/postgresql/html/release-9-3-22.html
share/doc/postgresql/html/release-9-3-23.html
share/doc/postgresql/html/release-9-3-24.html
+share/doc/postgresql/html/release-9-3-25.html
share/doc/postgresql/html/release-9-3-3.html
share/doc/postgresql/html/release-9-3-4.html
share/doc/postgresql/html/release-9-3-5.html
@@ -976,6 +978,7 @@ share/doc/postgresql/html/release-9-4-17
share/doc/postgresql/html/release-9-4-18.html
share/doc/postgresql/html/release-9-4-19.html
share/doc/postgresql/html/release-9-4-2.html
+share/doc/postgresql/html/release-9-4-20.html
share/doc/postgresql/html/release-9-4-3.html
share/doc/postgresql/html/release-9-4-4.html
share/doc/postgresql/html/release-9-4-5.html
@@ -990,6 +993,7 @@ share/doc/postgresql/html/release-9-5-11
share/doc/postgresql/html/release-9-5-12.html
share/doc/postgresql/html/release-9-5-13.html
share/doc/postgresql/html/release-9-5-14.html
+share/doc/postgresql/html/release-9-5-15.html
share/doc/postgresql/html/release-9-5-2.html
share/doc/postgresql/html/release-9-5-3.html
share/doc/postgresql/html/release-9-5-4.html
@@ -1001,6 +1005,7 @@ share/doc/postgresql/html/release-9-5-9.
share/doc/postgresql/html/release-9-5.html
share/doc/postgresql/html/release-9-6-1.html
share/doc/postgresql/html/release-9-6-10.html
+share/doc/postgresql/html/release-9-6-11.html
share/doc/postgresql/html/release-9-6-2.html
share/doc/postgresql/html/release-9-6-3.html
share/doc/postgresql/html/release-9-6-4.html
