From owner-svn-ports-all@freebsd.org Thu Oct 27 14:04:59 2016 Return-Path: Delivered-To: svn-ports-all@mailman.ysv.freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:1900:2254:206a::19:1]) by mailman.ysv.freebsd.org (Postfix) with ESMTP id 89A81C15EFA; Thu, 27 Oct 2016 14:04:59 +0000 (UTC) (envelope-from girgen@FreeBSD.org) Received: from repo.freebsd.org (repo.freebsd.org [IPv6:2610:1c1:1:6068::e6a:0]) (using TLSv1.2 with cipher ECDHE-RSA-AES256-GCM-SHA384 (256/256 bits)) (Client did not present a certificate) by mx1.freebsd.org (Postfix) with ESMTPS id 55B7EFC1; Thu, 27 Oct 2016 14:04:59 +0000 (UTC) (envelope-from girgen@FreeBSD.org) Received: from repo.freebsd.org ([127.0.1.37]) by repo.freebsd.org (8.15.2/8.15.2) with ESMTP id u9RE4w9V009535; Thu, 27 Oct 2016 14:04:58 GMT (envelope-from girgen@FreeBSD.org) Received: (from girgen@localhost) by repo.freebsd.org (8.15.2/8.15.2/Submit) id u9RE4utY009510; Thu, 27 Oct 2016 14:04:56 GMT (envelope-from girgen@FreeBSD.org) Message-Id: <201610271404.u9RE4utY009510@repo.freebsd.org> X-Authentication-Warning: repo.freebsd.org: girgen set sender to girgen@FreeBSD.org using -f From: Palle Girgensohn Date: Thu, 27 Oct 2016 14:04:56 +0000 (UTC) To: ports-committers@freebsd.org, svn-ports-all@freebsd.org, svn-ports-head@freebsd.org Subject: svn commit: r424765 - in head/databases: postgresql92-server postgresql92-server/files postgresql93-server postgresql93-server/files postgresql94-server postgresql94-server/files postgresql95-serve... X-SVN-Group: ports-head MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 8bit X-BeenThere: svn-ports-all@freebsd.org X-Mailman-Version: 2.1.23 Precedence: list List-Id: SVN commit messages for the ports tree List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Thu, 27 Oct 2016 14:04:59 -0000 Author: girgen Date: Thu Oct 27 14:04:55 2016 New Revision: 424765 URL: https://svnweb.freebsd.org/changeset/ports/424765 Log: Update PostgreSQL to latest versions. The PostgreSQL Global Development Group has released an update to all supported versions of our database system, including 9.6.1, 9.5.5, 9.4.10, 9.3.15, 9.2.19, and 9.1.24. This release fixes two issues that can cause data corruption, which are described in more detail below. It also patches a number of other bugs reported over the last three months. The project urges users to apply this update at the next possible downtime. Modified: head/databases/postgresql92-server/Makefile head/databases/postgresql92-server/distinfo head/databases/postgresql92-server/files/pkg-message-server.in head/databases/postgresql92-server/files/postgresql.in head/databases/postgresql92-server/pkg-plist-server head/databases/postgresql93-server/Makefile head/databases/postgresql93-server/distinfo head/databases/postgresql93-server/files/pkg-message-server.in head/databases/postgresql93-server/files/postgresql.in head/databases/postgresql93-server/pkg-plist-server head/databases/postgresql94-server/Makefile head/databases/postgresql94-server/distinfo head/databases/postgresql94-server/files/pkg-message-server.in head/databases/postgresql94-server/files/postgresql.in head/databases/postgresql94-server/pkg-plist-server head/databases/postgresql95-server/Makefile head/databases/postgresql95-server/distinfo head/databases/postgresql95-server/files/pkg-message-server.in head/databases/postgresql95-server/files/postgresql.in head/databases/postgresql95-server/pkg-plist-server head/databases/postgresql96-server/Makefile head/databases/postgresql96-server/distinfo head/databases/postgresql96-server/files/postgresql.in head/databases/postgresql96-server/pkg-plist-client head/databases/postgresql96-server/pkg-plist-server Modified: head/databases/postgresql92-server/Makefile ============================================================================== --- head/databases/postgresql92-server/Makefile Thu Oct 27 13:14:17 2016 (r424764) +++ head/databases/postgresql92-server/Makefile Thu Oct 27 14:04:55 2016 (r424765) @@ -2,14 +2,16 @@ # $FreeBSD$ PORTNAME?= postgresql -DISTVERSION?= 9.2.18 -PORTREVISION?= 1 +DISTVERSION?= 9.2.19 +PORTREVISION?= 0 CATEGORIES?= databases MASTER_SITES= PGSQL/source/v${DISTVERSION} PKGNAMESUFFIX?= ${PORTVERSION:R:S/.//}${COMPONENT} MAINTAINER?= pgsql@FreeBSD.org -COMMENT?= The most advanced open-source database available anywhere +COMMENT?= PostgreSQL is the most advanced open-source database available anywhere + +LICENSE= PostgreSQL CONFLICTS?= ${PORTNAME}[^${PORTVERSION:R:R}]?-client* \ ${PORTNAME}${COMPONENT}-[^${PORTVERSION:R:R}].* \ @@ -106,7 +108,6 @@ GSSAPI_DESC= Build with GSSAPI support OPTIMIZED_CFLAGS_DESC= Builds with compiler optimizations (-O3) DEBUG_DESC= Builds with debugging symbols - OPTIONS_DEFINE+= SSL SSL_DESC= Build with OpenSSL support @@ -244,9 +245,6 @@ do-install: ${MKDIR} ${STAGEDIR}${PREFIX}/etc/periodic/daily ;\ ${INSTALL_SCRIPT} ${WRKDIR}/502.pgsql \ ${STAGEDIR}${PREFIX}/etc/periodic/daily -. if ${PORTVERSION:M9.[2345].*} - ${MKDIR} ${STAGEDIR}${PREFIX}/${PG_USER} -. endif . endif # SERVER_ONLY . if defined(CLIENT_ONLY) @ cd ${WRKSRC}/src && ${SETENV} ${MAKE_ENV} ${MAKE_CMD} ${MAKE_ARGS} install-local Modified: head/databases/postgresql92-server/distinfo ============================================================================== --- head/databases/postgresql92-server/distinfo Thu Oct 27 13:14:17 2016 (r424764) +++ head/databases/postgresql92-server/distinfo Thu Oct 27 14:04:55 2016 (r424765) @@ -1,5 +1,5 @@ -TIMESTAMP = 1470919631 -SHA256 (postgresql/postgresql-9.2.18.tar.bz2) = d7aa37d586ae4d46d07a4fac417ff966e45a9dd99bac8b3cd149be8df9ea35f4 -SIZE (postgresql/postgresql-9.2.18.tar.bz2) = 16448429 +TIMESTAMP = 1477347738 +SHA256 (postgresql/postgresql-9.2.19.tar.bz2) = 1d29d73a4f590fcc348280f13ac2ff6a0f72c94908c54e3c20b7ab1560e8dbad +SIZE (postgresql/postgresql-9.2.19.tar.bz2) = 16466698 SHA256 (postgresql/pg-9218-icu-2016-08-10.diff.gz) = 2f9c831b3dff866f0b2f6f2a9ef771a4045486bc252a851aadc73c50d376319d SIZE (postgresql/pg-9218-icu-2016-08-10.diff.gz) = 5587 Modified: head/databases/postgresql92-server/files/pkg-message-server.in ============================================================================== --- head/databases/postgresql92-server/files/pkg-message-server.in Thu Oct 27 13:14:17 2016 (r424764) +++ head/databases/postgresql92-server/files/pkg-message-server.in Thu Oct 27 14:04:55 2016 (r424765) @@ -8,8 +8,8 @@ appropriately. The port is set up to use autovacuum for new databases, but you might also want to vacuum and perhaps backup your database regularly. There is a periodic script, %%PREFIX%%/etc/periodic/daily/502.pgsql, that -you may find useful. You can use it to backup and perfom vacuum on all -databases nightly. Per default, it perfoms `vacuum analyze'. See the +you may find useful. You can use it to backup and perform vacuum on all +databases nightly. Per default, it performs `vacuum analyze'. See the script for instructions. For autovacuum settings, please review ~pgsql/data/postgresql.conf. Modified: head/databases/postgresql92-server/files/postgresql.in ============================================================================== --- head/databases/postgresql92-server/files/postgresql.in Thu Oct 27 13:14:17 2016 (r424764) +++ head/databases/postgresql92-server/files/postgresql.in Thu Oct 27 14:04:55 2016 (r424765) @@ -58,8 +58,8 @@ if [ -n "$2" ]; then echo "You must define a data directory (postgresql_${profile}_data)" exit 1 fi - eval postgresql_enable="\${postgresql_${profile}_enable:-${postgresql_enable}} - eval postgresql_data="\${postgresql_${profile}_data:-${postgresql_data}} + eval postgresql_enable="\${postgresql_${profile}_enable:-${postgresql_enable}}" + eval postgresql_data="\${postgresql_${profile}_data:-${postgresql_data}}" eval postgresql_flags="\${postgresql_${profile}_flags:-${postgresql_flags}}" eval postgresql_initdb_flags="\${postgresql_${profile}_initdb_flags:-${postgresql_initdb_flags}}" fi @@ -108,7 +108,7 @@ postgresql_command() postgresql_initdb() { - su -l -c ${postgresql_class} ${postgresql_user} -c "exec %%PREFIX%%/bin/initdb ${postgresql_initdb_flags} -D ${postgresql_data}" + su -l -c ${postgresql_class} ${postgresql_user} -c "exec %%PREFIX%%/bin/initdb ${postgresql_initdb_flags} -D ${postgresql_data} -U ${postgresql_user}" } run_rc_command "$1" Modified: head/databases/postgresql92-server/pkg-plist-server ============================================================================== --- head/databases/postgresql92-server/pkg-plist-server Thu Oct 27 13:14:17 2016 (r424764) +++ head/databases/postgresql92-server/pkg-plist-server Thu Oct 27 14:04:55 2016 (r424765) @@ -464,6 +464,7 @@ lib/postgresql/utf8_and_win.so %%TZDATA%%%%DATADIR%%/timezone/Asia/Vientiane %%TZDATA%%%%DATADIR%%/timezone/Asia/Vladivostok %%TZDATA%%%%DATADIR%%/timezone/Asia/Yakutsk +%%TZDATA%%%%DATADIR%%/timezone/Asia/Yangon %%TZDATA%%%%DATADIR%%/timezone/Asia/Yekaterinburg %%TZDATA%%%%DATADIR%%/timezone/Asia/Yerevan %%TZDATA%%%%DATADIR%%/timezone/Atlantic/Azores @@ -761,4 +762,3 @@ lib/postgresql/utf8_and_win.so %%DATADIR%%/tsearch_data/ispell_sample.dict %%DATADIR%%/tsearch_data/synonym_sample.syn %%DATADIR%%/tsearch_data/thesaurus_sample.ths -@dir(%%PG_USER%%,%%PG_GROUP%%,) %%PG_USER%% Modified: head/databases/postgresql93-server/Makefile ============================================================================== --- head/databases/postgresql93-server/Makefile Thu Oct 27 13:14:17 2016 (r424764) +++ head/databases/postgresql93-server/Makefile Thu Oct 27 14:04:55 2016 (r424765) @@ -1,7 +1,7 @@ # Created by: Marc G. Fournier # $FreeBSD$ -DISTVERSION?= 9.3.14 +DISTVERSION?= 9.3.15 PKGNAMESUFFIX?= ${DISTVERSION:R:S/.//}${COMPONENT} MAINTAINER?= pgsql@FreeBSD.org Modified: head/databases/postgresql93-server/distinfo ============================================================================== --- head/databases/postgresql93-server/distinfo Thu Oct 27 13:14:17 2016 (r424764) +++ head/databases/postgresql93-server/distinfo Thu Oct 27 14:04:55 2016 (r424765) @@ -1,5 +1,5 @@ -TIMESTAMP = 1470919705 -SHA256 (postgresql/postgresql-9.3.14.tar.bz2) = 5c4322f1c42ba1ff4b28383069c56663b46160bb08e85d41fa2ab9a5009d039d -SIZE (postgresql/postgresql-9.3.14.tar.bz2) = 17042199 +TIMESTAMP = 1477347757 +SHA256 (postgresql/postgresql-9.3.15.tar.bz2) = a9fcba1446a93aa95e3e1b6535756f0472d10b0f267a0845f8b2b29f89de5c4f +SIZE (postgresql/postgresql-9.3.15.tar.bz2) = 17059932 SHA256 (postgresql/pg-9314-icu-2016-08-10.diff.gz) = 4be31ad9899d5caf9f57ad7ebfc0d14f0fcf58ad539c82fb353b016fb76c0c30 SIZE (postgresql/pg-9314-icu-2016-08-10.diff.gz) = 5583 Modified: head/databases/postgresql93-server/files/pkg-message-server.in ============================================================================== --- head/databases/postgresql93-server/files/pkg-message-server.in Thu Oct 27 13:14:17 2016 (r424764) +++ head/databases/postgresql93-server/files/pkg-message-server.in Thu Oct 27 14:04:55 2016 (r424765) @@ -8,8 +8,8 @@ appropriately. The port is set up to use autovacuum for new databases, but you might also want to vacuum and perhaps backup your database regularly. There is a periodic script, %%PREFIX%%/etc/periodic/daily/502.pgsql, that -you may find useful. You can use it to backup and perfom vacuum on all -databases nightly. Per default, it perfoms `vacuum analyze'. See the +you may find useful. You can use it to backup and perform vacuum on all +databases nightly. Per default, it performs `vacuum analyze'. See the script for instructions. For autovacuum settings, please review ~pgsql/data/postgresql.conf. Modified: head/databases/postgresql93-server/files/postgresql.in ============================================================================== --- head/databases/postgresql93-server/files/postgresql.in Thu Oct 27 13:14:17 2016 (r424764) +++ head/databases/postgresql93-server/files/postgresql.in Thu Oct 27 14:04:55 2016 (r424765) @@ -58,8 +58,8 @@ if [ -n "$2" ]; then echo "You must define a data directory (postgresql_${profile}_data)" exit 1 fi - eval postgresql_enable="\${postgresql_${profile}_enable:-${postgresql_enable}} - eval postgresql_data="\${postgresql_${profile}_data:-${postgresql_data}} + eval postgresql_enable="\${postgresql_${profile}_enable:-${postgresql_enable}}" + eval postgresql_data="\${postgresql_${profile}_data:-${postgresql_data}}" eval postgresql_flags="\${postgresql_${profile}_flags:-${postgresql_flags}}" eval postgresql_initdb_flags="\${postgresql_${profile}_initdb_flags:-${postgresql_initdb_flags}}" fi @@ -108,7 +108,7 @@ postgresql_command() postgresql_initdb() { - su -l -c ${postgresql_class} ${postgresql_user} -c "exec %%PREFIX%%/bin/initdb ${postgresql_initdb_flags} -D ${postgresql_data}" + su -l -c ${postgresql_class} ${postgresql_user} -c "exec %%PREFIX%%/bin/initdb ${postgresql_initdb_flags} -D ${postgresql_data} -U ${postgresql_user}" } run_rc_command "$1" Modified: head/databases/postgresql93-server/pkg-plist-server ============================================================================== --- head/databases/postgresql93-server/pkg-plist-server Thu Oct 27 13:14:17 2016 (r424764) +++ head/databases/postgresql93-server/pkg-plist-server Thu Oct 27 14:04:55 2016 (r424765) @@ -453,6 +453,7 @@ lib/libpgcommon.a %%TZDATA%%%%DATADIR%%/timezone/Asia/Vientiane %%TZDATA%%%%DATADIR%%/timezone/Asia/Vladivostok %%TZDATA%%%%DATADIR%%/timezone/Asia/Yakutsk +%%TZDATA%%%%DATADIR%%/timezone/Asia/Yangon %%TZDATA%%%%DATADIR%%/timezone/Asia/Yekaterinburg %%TZDATA%%%%DATADIR%%/timezone/Asia/Yerevan %%TZDATA%%%%DATADIR%%/timezone/Atlantic/Azores @@ -750,4 +751,3 @@ lib/libpgcommon.a %%DATADIR%%/tsearch_data/ispell_sample.dict %%DATADIR%%/tsearch_data/synonym_sample.syn %%DATADIR%%/tsearch_data/thesaurus_sample.ths -@dir(%%PG_USER%%,%%PG_GROUP%%,) %%PG_USER%% Modified: head/databases/postgresql94-server/Makefile ============================================================================== --- head/databases/postgresql94-server/Makefile Thu Oct 27 13:14:17 2016 (r424764) +++ head/databases/postgresql94-server/Makefile Thu Oct 27 14:04:55 2016 (r424765) @@ -1,7 +1,7 @@ # Created by: Marc G. Fournier # $FreeBSD$ -DISTVERSION?= 9.4.9 +DISTVERSION?= 9.4.10 MAINTAINER?= pgsql@FreeBSD.org @@ -12,6 +12,6 @@ INSTALL_DIRS?= src/common src/timezone s src/bin/pg_controldata src/bin/pg_resetxlog src/pl \ src/bin/pg_basebackup -ICU_PATCHFILE= pg-949-icu-2016-08-10.diff.gz +ICU_PATCHFILE= pg-949-icu-2016-10-02.diff.gz .include "${.CURDIR}/../postgresql92-server/Makefile" Modified: head/databases/postgresql94-server/distinfo ============================================================================== --- head/databases/postgresql94-server/distinfo Thu Oct 27 13:14:17 2016 (r424764) +++ head/databases/postgresql94-server/distinfo Thu Oct 27 14:04:55 2016 (r424765) @@ -1,5 +1,5 @@ -TIMESTAMP = 1470919711 -SHA256 (postgresql/postgresql-9.4.9.tar.bz2) = c120a62e90214c20d9160da3ca3fbaec97d5f1656f1dd033f60e7297b7a1e1c9 -SIZE (postgresql/postgresql-9.4.9.tar.bz2) = 17763281 -SHA256 (postgresql/pg-949-icu-2016-08-10.diff.gz) = 8e7f0470b5c04653aee850c58e690d1ca5f7cb3a2acb5d64c793a8412ee9ebfe -SIZE (postgresql/pg-949-icu-2016-08-10.diff.gz) = 5263 +TIMESTAMP = 1477347764 +SHA256 (postgresql/postgresql-9.4.10.tar.bz2) = 7061678bed1981c681ce54c76b98b6ec17743f090a9775104a45e7e1a8826ecf +SIZE (postgresql/postgresql-9.4.10.tar.bz2) = 17802812 +SHA256 (postgresql/pg-949-icu-2016-10-02.diff.gz) = 34612e685a79874db04bc6b66c700bfc6412042840c532eef0da7832d1f70d43 +SIZE (postgresql/pg-949-icu-2016-10-02.diff.gz) = 5289 Modified: head/databases/postgresql94-server/files/pkg-message-server.in ============================================================================== --- head/databases/postgresql94-server/files/pkg-message-server.in Thu Oct 27 13:14:17 2016 (r424764) +++ head/databases/postgresql94-server/files/pkg-message-server.in Thu Oct 27 14:04:55 2016 (r424765) @@ -8,8 +8,8 @@ appropriately. The port is set up to use autovacuum for new databases, but you might also want to vacuum and perhaps backup your database regularly. There is a periodic script, %%PREFIX%%/etc/periodic/daily/502.pgsql, that -you may find useful. You can use it to backup and perfom vacuum on all -databases nightly. Per default, it perfoms `vacuum analyze'. See the +you may find useful. You can use it to backup and perform vacuum on all +databases nightly. Per default, it performs `vacuum analyze'. See the script for instructions. For autovacuum settings, please review ~pgsql/data/postgresql.conf. Modified: head/databases/postgresql94-server/files/postgresql.in ============================================================================== --- head/databases/postgresql94-server/files/postgresql.in Thu Oct 27 13:14:17 2016 (r424764) +++ head/databases/postgresql94-server/files/postgresql.in Thu Oct 27 14:04:55 2016 (r424765) @@ -58,8 +58,8 @@ if [ -n "$2" ]; then echo "You must define a data directory (postgresql_${profile}_data)" exit 1 fi - eval postgresql_enable="\${postgresql_${profile}_enable:-${postgresql_enable}} - eval postgresql_data="\${postgresql_${profile}_data:-${postgresql_data}} + eval postgresql_enable="\${postgresql_${profile}_enable:-${postgresql_enable}}" + eval postgresql_data="\${postgresql_${profile}_data:-${postgresql_data}}" eval postgresql_flags="\${postgresql_${profile}_flags:-${postgresql_flags}}" eval postgresql_initdb_flags="\${postgresql_${profile}_initdb_flags:-${postgresql_initdb_flags}}" fi @@ -108,7 +108,7 @@ postgresql_command() postgresql_initdb() { - su -l -c ${postgresql_class} ${postgresql_user} -c "exec %%PREFIX%%/bin/initdb ${postgresql_initdb_flags} -D ${postgresql_data}" + su -l -c ${postgresql_class} ${postgresql_user} -c "exec %%PREFIX%%/bin/initdb ${postgresql_initdb_flags} -D ${postgresql_data} -U ${postgresql_user}" } run_rc_command "$1" Modified: head/databases/postgresql94-server/pkg-plist-server ============================================================================== --- head/databases/postgresql94-server/pkg-plist-server Thu Oct 27 13:14:17 2016 (r424764) +++ head/databases/postgresql94-server/pkg-plist-server Thu Oct 27 14:04:55 2016 (r424765) @@ -453,6 +453,7 @@ lib/libpgcommon.a %%TZDATA%%%%DATADIR%%/timezone/Asia/Ust-Nera %%TZDATA%%%%DATADIR%%/timezone/Asia/Vientiane %%TZDATA%%%%DATADIR%%/timezone/Asia/Vladivostok +%%TZDATA%%%%DATADIR%%/timezone/Asia/Yangon %%TZDATA%%%%DATADIR%%/timezone/Asia/Yakutsk %%TZDATA%%%%DATADIR%%/timezone/Asia/Yekaterinburg %%TZDATA%%%%DATADIR%%/timezone/Asia/Yerevan @@ -751,4 +752,3 @@ lib/libpgcommon.a %%DATADIR%%/tsearch_data/ispell_sample.dict %%DATADIR%%/tsearch_data/synonym_sample.syn %%DATADIR%%/tsearch_data/thesaurus_sample.ths -@dir(%%PG_USER%%,%%PG_GROUP%%,) %%PG_USER%% Modified: head/databases/postgresql95-server/Makefile ============================================================================== --- head/databases/postgresql95-server/Makefile Thu Oct 27 13:14:17 2016 (r424764) +++ head/databases/postgresql95-server/Makefile Thu Oct 27 14:04:55 2016 (r424765) @@ -1,7 +1,7 @@ # Created by: Marc G. Fournier # $FreeBSD$ -DISTVERSION?= 9.5.4 +DISTVERSION?= 9.5.5 MAINTAINER?= pgsql@FreeBSD.org Modified: head/databases/postgresql95-server/distinfo ============================================================================== --- head/databases/postgresql95-server/distinfo Thu Oct 27 13:14:17 2016 (r424764) +++ head/databases/postgresql95-server/distinfo Thu Oct 27 14:04:55 2016 (r424765) @@ -1,5 +1,5 @@ -TIMESTAMP = 1470919717 -SHA256 (postgresql/postgresql-9.5.4.tar.bz2) = cf5e571164ad66028ecd7dd8819e3765470d45bcd440d258b686be7e69c76ed0 -SIZE (postgresql/postgresql-9.5.4.tar.bz2) = 18496299 +TIMESTAMP = 1477347770 +SHA256 (postgresql/postgresql-9.5.5.tar.bz2) = 02c65290be74de6604c3fed87c9fd3e6b32e949f0ab8105a75bd7ed5aa71f394 +SIZE (postgresql/postgresql-9.5.5.tar.bz2) = 18525082 SHA256 (postgresql/pg-954-icu-2016-08-10.diff.gz) = 5fa083ec38087d6a0961642208f012e902221270708b919b92e9eedaa755e365 SIZE (postgresql/pg-954-icu-2016-08-10.diff.gz) = 5952 Modified: head/databases/postgresql95-server/files/pkg-message-server.in ============================================================================== --- head/databases/postgresql95-server/files/pkg-message-server.in Thu Oct 27 13:14:17 2016 (r424764) +++ head/databases/postgresql95-server/files/pkg-message-server.in Thu Oct 27 14:04:55 2016 (r424765) @@ -8,8 +8,8 @@ appropriately. The port is set up to use autovacuum for new databases, but you might also want to vacuum and perhaps backup your database regularly. There is a periodic script, %%PREFIX%%/etc/periodic/daily/502.pgsql, that -you may find useful. You can use it to backup and perfom vacuum on all -databases nightly. Per default, it perfoms `vacuum analyze'. See the +you may find useful. You can use it to backup and perform vacuum on all +databases nightly. Per default, it performs `vacuum analyze'. See the script for instructions. For autovacuum settings, please review ~pgsql/data/postgresql.conf. Modified: head/databases/postgresql95-server/files/postgresql.in ============================================================================== --- head/databases/postgresql95-server/files/postgresql.in Thu Oct 27 13:14:17 2016 (r424764) +++ head/databases/postgresql95-server/files/postgresql.in Thu Oct 27 14:04:55 2016 (r424765) @@ -58,8 +58,8 @@ if [ -n "$2" ]; then echo "You must define a data directory (postgresql_${profile}_data)" exit 1 fi - eval postgresql_enable="\${postgresql_${profile}_enable:-${postgresql_enable}} - eval postgresql_data="\${postgresql_${profile}_data:-${postgresql_data}} + eval postgresql_enable="\${postgresql_${profile}_enable:-${postgresql_enable}}" + eval postgresql_data="\${postgresql_${profile}_data:-${postgresql_data}}" eval postgresql_flags="\${postgresql_${profile}_flags:-${postgresql_flags}}" eval postgresql_initdb_flags="\${postgresql_${profile}_initdb_flags:-${postgresql_initdb_flags}}" fi @@ -108,7 +108,7 @@ postgresql_command() postgresql_initdb() { - su -l -c ${postgresql_class} ${postgresql_user} -c "exec %%PREFIX%%/bin/initdb ${postgresql_initdb_flags} -D ${postgresql_data}" + su -l -c ${postgresql_class} ${postgresql_user} -c "exec %%PREFIX%%/bin/initdb ${postgresql_initdb_flags} -D ${postgresql_data} -U ${postgresql_user}" } run_rc_command "$1" Modified: head/databases/postgresql95-server/pkg-plist-server ============================================================================== --- head/databases/postgresql95-server/pkg-plist-server Thu Oct 27 13:14:17 2016 (r424764) +++ head/databases/postgresql95-server/pkg-plist-server Thu Oct 27 14:04:55 2016 (r424765) @@ -475,6 +475,7 @@ lib/libpgcommon.a %%TZDATA%%%%DATADIR%%/timezone/Asia/Vientiane %%TZDATA%%%%DATADIR%%/timezone/Asia/Vladivostok %%TZDATA%%%%DATADIR%%/timezone/Asia/Yakutsk +%%TZDATA%%%%DATADIR%%/timezone/Asia/Yangon %%TZDATA%%%%DATADIR%%/timezone/Asia/Yekaterinburg %%TZDATA%%%%DATADIR%%/timezone/Asia/Yerevan %%TZDATA%%%%DATADIR%%/timezone/Atlantic/Azores @@ -772,4 +773,3 @@ lib/libpgcommon.a %%DATADIR%%/tsearch_data/ispell_sample.dict %%DATADIR%%/tsearch_data/synonym_sample.syn %%DATADIR%%/tsearch_data/thesaurus_sample.ths -@dir(%%PG_USER%%,%%PG_GROUP%%,) %%PG_USER%% Modified: head/databases/postgresql96-server/Makefile ============================================================================== --- head/databases/postgresql96-server/Makefile Thu Oct 27 13:14:17 2016 (r424764) +++ head/databases/postgresql96-server/Makefile Thu Oct 27 14:04:55 2016 (r424765) @@ -1,7 +1,7 @@ # Created by: Marc G. Fournier # $FreeBSD$ -DISTVERSION?= 9.6.0 +DISTVERSION?= 9.6.1 MAINTAINER?= pgsql@FreeBSD.org @@ -19,7 +19,7 @@ PG_USER?= postgres PG_GROUP?= postgres PG_UID?= 770 -ICU_PATCHFILE= pg-96b4-icu-2016-08-10.diff.gz +ICU_PATCHFILE= pg-96b4-icu-2016-10-02.diff.gz OPTIONS_DEFAULT+=ICU .include "${.CURDIR}/../postgresql92-server/Makefile" Modified: head/databases/postgresql96-server/distinfo ============================================================================== --- head/databases/postgresql96-server/distinfo Thu Oct 27 13:14:17 2016 (r424764) +++ head/databases/postgresql96-server/distinfo Thu Oct 27 14:04:55 2016 (r424765) @@ -1,5 +1,5 @@ -TIMESTAMP = 1472754782 -SHA256 (postgresql/postgresql-9.6.0.tar.bz2) = 3b5fe9634b80a4511aac1832a087586a7caa8c3413619562bdda009a015863ce -SIZE (postgresql/postgresql-9.6.0.tar.bz2) = 19157472 -SHA256 (postgresql/pg-96b4-icu-2016-08-10.diff.gz) = ca9d57715d425dfcbc530f01c65c746000a1ee64838452b69a97730b39900317 -SIZE (postgresql/pg-96b4-icu-2016-08-10.diff.gz) = 5971 +TIMESTAMP = 1477347775 +SHA256 (postgresql/postgresql-9.6.1.tar.bz2) = e5101e0a49141fc12a7018c6dad594694d3a3325f5ab71e93e0e51bd94e51fcd +SIZE (postgresql/postgresql-9.6.1.tar.bz2) = 19260568 +SHA256 (postgresql/pg-96b4-icu-2016-10-02.diff.gz) = 85f81baa0fc8f692bcf802c8645196d9e3afdef4f760cef712d940b87655486e +SIZE (postgresql/pg-96b4-icu-2016-10-02.diff.gz) = 5998 Modified: head/databases/postgresql96-server/files/postgresql.in ============================================================================== --- head/databases/postgresql96-server/files/postgresql.in Thu Oct 27 13:14:17 2016 (r424764) +++ head/databases/postgresql96-server/files/postgresql.in Thu Oct 27 14:04:55 2016 (r424765) @@ -58,8 +58,8 @@ if [ -n "$2" ]; then echo "You must define a data directory (postgresql_${profile}_data)" exit 1 fi - eval postgresql_enable="\${postgresql_${profile}_enable:-${postgresql_enable}} - eval postgresql_data="\${postgresql_${profile}_data:-${postgresql_data}} + eval postgresql_enable="\${postgresql_${profile}_enable:-${postgresql_enable}}" + eval postgresql_data="\${postgresql_${profile}_data:-${postgresql_data}}" eval postgresql_flags="\${postgresql_${profile}_flags:-${postgresql_flags}}" eval postgresql_initdb_flags="\${postgresql_${profile}_initdb_flags:-${postgresql_initdb_flags}}" fi Modified: head/databases/postgresql96-server/pkg-plist-client ============================================================================== --- head/databases/postgresql96-server/pkg-plist-client Thu Oct 27 13:14:17 2016 (r424764) +++ head/databases/postgresql96-server/pkg-plist-client Thu Oct 27 14:04:55 2016 (r424765) @@ -990,6 +990,7 @@ man/man7/WITH.7.gz %%NLS%%share/locale/ko/LC_MESSAGES/pg_config-9.6.mo %%NLS%%share/locale/ko/LC_MESSAGES/pg_dump-9.6.mo %%NLS%%share/locale/ko/LC_MESSAGES/pgscripts-9.6.mo +%%NLS%%share/locale/ko/LC_MESSAGES/psql-9.6.mo %%NLS%%share/locale/nb/LC_MESSAGES/pg_config-9.6.mo %%NLS%%share/locale/pl/LC_MESSAGES/ecpg-9.6.mo %%NLS%%share/locale/pl/LC_MESSAGES/ecpglib6-9.6.mo Modified: head/databases/postgresql96-server/pkg-plist-server ============================================================================== --- head/databases/postgresql96-server/pkg-plist-server Thu Oct 27 13:14:17 2016 (r424764) +++ head/databases/postgresql96-server/pkg-plist-server Thu Oct 27 14:04:55 2016 (r424765) @@ -477,6 +477,7 @@ lib/libpgcommon.a %%TZDATA%%%%DATADIR%%/timezone/Asia/Vientiane %%TZDATA%%%%DATADIR%%/timezone/Asia/Vladivostok %%TZDATA%%%%DATADIR%%/timezone/Asia/Yakutsk +%%TZDATA%%%%DATADIR%%/timezone/Asia/Yangon %%TZDATA%%%%DATADIR%%/timezone/Asia/Yekaterinburg %%TZDATA%%%%DATADIR%%/timezone/Asia/Yerevan %%TZDATA%%%%DATADIR%%/timezone/Atlantic/Azores