Date: Sat, 13 Feb 2016 22:42:04 +0000 (UTC) From: Palle Girgensohn <girgen@FreeBSD.org> To: ports-committers@freebsd.org, svn-ports-all@freebsd.org, svn-ports-head@freebsd.org Subject: svn commit: r408835 - in head/databases: postgresql90-server/files postgresql91-server postgresql91-server/files postgresql92-server postgresql92-server/files postgresql93-server postgresql93-serve... Message-ID: <201602132242.u1DMg4j4092391@repo.freebsd.org>
next in thread | raw e-mail | index | archive | help
Author: girgen Date: Sat Feb 13 22:42:04 2016 New Revision: 408835 URL: https://svnweb.freebsd.org/changeset/ports/408835 Log: Update PostgreSQL to latest versions. Security Fixes for Regular Expressions, PL/Java This release closes security hole CVE-2016-0773, an issue with regular expression (regex) parsing. Prior code allowed users to pass in expressions which included out-of-range Unicode characters, triggering a backend crash. This issue is critical for PostgreSQL systems with untrusted users or which generate regexes based on user input. The update also fixes CVE-2016-0766, a privilege escalation issue for users of PL/Java. Certain custom configuration settings (GUCS) for PL/Java will now be modifiable only by the database superuser URL: http://www.postgresql.org/about/news/1644/ Security: CVE-2016-0773, CVE-2016-0766 Modified: head/databases/postgresql90-server/files/502.pgsql.in head/databases/postgresql91-server/Makefile head/databases/postgresql91-server/distinfo head/databases/postgresql91-server/files/502.pgsql.in head/databases/postgresql91-server/pkg-plist-client head/databases/postgresql92-server/Makefile head/databases/postgresql92-server/distinfo head/databases/postgresql92-server/files/502.pgsql.in head/databases/postgresql92-server/pkg-plist-client head/databases/postgresql93-server/Makefile head/databases/postgresql93-server/distinfo head/databases/postgresql93-server/files/502.pgsql.in head/databases/postgresql93-server/pkg-plist-client head/databases/postgresql94-server/Makefile head/databases/postgresql94-server/distinfo head/databases/postgresql94-server/files/502.pgsql.in head/databases/postgresql94-server/pkg-plist-client head/databases/postgresql95-server/Makefile head/databases/postgresql95-server/distinfo head/databases/postgresql95-server/files/502.pgsql.in head/databases/postgresql95-server/pkg-plist-client head/databases/postgresql95-server/pkg-plist-server Modified: head/databases/postgresql90-server/files/502.pgsql.in ============================================================================== --- head/databases/postgresql90-server/files/502.pgsql.in Sat Feb 13 22:35:55 2016 (r408834) +++ head/databases/postgresql90-server/files/502.pgsql.in Sat Feb 13 22:42:04 2016 (r408835) @@ -1,6 +1,6 @@ #!/bin/sh # -# $FreeBSD: /tmp/pcvs/ports/databases/postgresql90-server/files/502.pgsql.in,v 1.2 2011-04-20 15:30:33 girgen Exp $ +# $FreeBSD$ # # Maintenance shell script to vacuum and backup database # Put this in /usr/local/etc/periodic/daily, and it will be run @@ -19,12 +19,6 @@ # daily_pgsql_backup_enable="foo bar db1 db2" # only do backup of a limited selection of databases # daily_pgsql_vacuum_enable="YES" # do vacuum -daily_pgsql_vacuum_args="-z" -daily_pgsql_pgdump_args="-b -F c" -# backupdir is relative to ~pgsql home directory unless it begins with a slash: -daily_pgsql_backupdir="~%%PG_USER%%/backups" -daily_pgsql_savedays="7" - # If there is a global system configuration file, suck it in. # if [ -r /etc/defaults/periodic.conf ] @@ -33,6 +27,15 @@ then source_periodic_confs fi +: ${daily_pgsql_user:="%%PG_USER%%"} +: ${daily_pgsql_port:=5432} +: ${daily_pgsql_vacuum_args:="-U ${daily_pgsql_user} -p ${daily_pgsql_port} -qaz"} +: ${daily_pgsql_pgdump_args:="-U ${daily_pgsql_user} -p ${daily_pgsql_port} -bF c"} +: ${daily_pgsql_pgdumpall_globals_args:="-U ${daily_pgsql_user} -p ${daily_pgsql_port}"} +# backupdir is relative to ~pgsql home directory unless it begins with a slash: +: ${daily_pgsql_backupdir:="~${daily_pgsql_user}/backups"} +: ${daily_pgsql_savedays:="7"} + # allow '~´ in dir name eval backupdir=${daily_pgsql_backupdir} @@ -44,7 +47,7 @@ pgsql_backup() { # but this might not be where you want the backups... if [ ! -d ${backupdir} ] ; then echo Creating ${backupdir} - mkdir -m 700 ${backupdir}; chown %%PG_USER%% ${backupdir} + mkdir -m 700 ${backupdir}; chown ${daily_pgsql_user} ${backupdir} fi echo @@ -55,13 +58,14 @@ pgsql_backup() { rc=$? now=`date "+%Y-%m-%dT%H:%M:%S"` file=${daily_pgsql_backupdir}/pgglobals_${now} - su -l %%PG_USER%% -c "umask 077; pg_dumpall -g -U %%PG_USER%% | gzip -9 > ${file}.gz" + su -l ${daily_pgsql_user} -c \ + "umask 077; pg_dumpall -g ${daily_pgsql_pgdumpall_globals_args} | gzip -9 > ${file}.gz" db=$1 while shift; do echo -n " $db" file=${backupdir}/pgdump_${db}_${now} - su -l %%PG_USER%% -c "umask 077; pg_dump ${daily_pgsql_pgdump_args} -U %%PG_USER%% -f ${file} ${db}" + su -l ${daily_pgsql_user} -c "umask 077; pg_dump ${daily_pgsql_pgdump_args} -f ${file} ${db}" [ $? -gt 0 ] && rc=3 db=$1 done @@ -79,7 +83,7 @@ pgsql_backup() { case "$daily_pgsql_backup_enable" in [Yy][Ee][Ss]) - dbnames=`su -l %%PG_USER%% -c "umask 077; psql -q -t -A -d template1 -U %%PG_USER%% -c SELECT\ datname\ FROM\ pg_database\ WHERE\ datname!=\'template0\'"` + dbnames=`su -l ${daily_pgsql_user} -c "umask 077; psql -U ${daily_pgsql_user} -p ${daily_pgsql_port} -q -t -A -d template1 -c SELECT\ datname\ FROM\ pg_database\ WHERE\ datname!=\'template0\'"` pgsql_backup $dbnames ;; @@ -99,7 +103,7 @@ case "$daily_pgsql_vacuum_enable" in echo echo "PostgreSQL vacuum" - su -l %%PG_USER%% -c "vacuumdb -a -q -U %%PG_USER%% ${daily_pgsql_vacuum_args}" + su -l ${daily_pgsql_user} -c "vacuumdb ${daily_pgsql_vacuum_args}" if [ $? -gt 0 ] then echo Modified: head/databases/postgresql91-server/Makefile ============================================================================== --- head/databases/postgresql91-server/Makefile Sat Feb 13 22:35:55 2016 (r408834) +++ head/databases/postgresql91-server/Makefile Sat Feb 13 22:42:04 2016 (r408835) @@ -2,7 +2,7 @@ # $FreeBSD$ PORTNAME?= postgresql -DISTVERSION?= 9.1.19 +DISTVERSION?= 9.1.20 CATEGORIES?= databases MASTER_SITES= PGSQL/source/v${DISTVERSION} PKGNAMESUFFIX?= ${DISTVERSION:R:S/.//}${COMPONENT} @@ -68,7 +68,6 @@ SUB_FILES+= 502.pgsql OPTIONS_DEFINE+=LIBEDIT LIBEDIT_DESC= Use non-GPL libedit instead of readline USES+= perl5 -PORTREVISION?= 1 .else MAKE_ENV= PATH=${PREFIX}/bin:${PATH} CONFIGURE_ENV+= PATH=${PREFIX}/bin:${PATH} Modified: head/databases/postgresql91-server/distinfo ============================================================================== --- head/databases/postgresql91-server/distinfo Sat Feb 13 22:35:55 2016 (r408834) +++ head/databases/postgresql91-server/distinfo Sat Feb 13 22:42:04 2016 (r408835) @@ -1,4 +1,4 @@ -SHA256 (postgresql/postgresql-9.1.19.tar.bz2) = cbd5057451147dd63a1e764176a4e17a7795773be1e4266ea9faa951064c0ec6 -SIZE (postgresql/postgresql-9.1.19.tar.bz2) = 15843978 +SHA256 (postgresql/postgresql-9.1.20.tar.bz2) = 6d1e6c4334c265a85f0f96407b7a9aafff0f26cb62db2d8d03a32ba0c2872937 +SIZE (postgresql/postgresql-9.1.20.tar.bz2) = 15844360 SHA256 (postgresql/pg-929-icu-2015-04-18.diff.gz) = 9aff1ba25fbe5892a3868bff516df685531c85901c360548e38bf2e5fa0e14ab SIZE (postgresql/pg-929-icu-2015-04-18.diff.gz) = 4469 Modified: head/databases/postgresql91-server/files/502.pgsql.in ============================================================================== --- head/databases/postgresql91-server/files/502.pgsql.in Sat Feb 13 22:35:55 2016 (r408834) +++ head/databases/postgresql91-server/files/502.pgsql.in Sat Feb 13 22:42:04 2016 (r408835) @@ -1,6 +1,6 @@ #!/bin/sh # -# $FreeBSD: /tmp/pcvs/ports/databases/postgresql91-server/files/502.pgsql.in,v 1.4 2011-10-18 09:03:32 girgen Exp $ +# $FreeBSD$ # # Maintenance shell script to vacuum and backup database # Put this in /usr/local/etc/periodic/daily, and it will be run @@ -19,14 +19,6 @@ # daily_pgsql_backup_enable="foo bar db1 db2" # only do backup of a limited selection of databases # daily_pgsql_vacuum_enable="YES" # do vacuum -daily_pgsql_user=%%PG_USER%% -daily_pgsql_vacuum_args="-U ${daily_pgsql_user} -qaz" -daily_pgsql_pgdump_args="-U ${daily_pgsql_user} -bF c" -daily_pgsql_pgdumpall_globals_args="-U ${daily_pgsql_user}" -# backupdir is relative to ~pgsql home directory unless it begins with a slash: -daily_pgsql_backupdir="~${daily_pgsql_user}/backups" -daily_pgsql_savedays="7" - # If there is a global system configuration file, suck it in. # if [ -r /etc/defaults/periodic.conf ] @@ -35,6 +27,15 @@ then source_periodic_confs fi +: ${daily_pgsql_user:="%%PG_USER%%"} +: ${daily_pgsql_port:=5432} +: ${daily_pgsql_vacuum_args:="-U ${daily_pgsql_user} -p ${daily_pgsql_port} -qaz"} +: ${daily_pgsql_pgdump_args:="-U ${daily_pgsql_user} -p ${daily_pgsql_port} -bF c"} +: ${daily_pgsql_pgdumpall_globals_args:="-U ${daily_pgsql_user} -p ${daily_pgsql_port}"} +# backupdir is relative to ~pgsql home directory unless it begins with a slash: +: ${daily_pgsql_backupdir:="~${daily_pgsql_user}/backups"} +: ${daily_pgsql_savedays:="7"} + # allow '~´ in dir name eval backupdir=${daily_pgsql_backupdir} @@ -82,7 +83,7 @@ pgsql_backup() { case "$daily_pgsql_backup_enable" in [Yy][Ee][Ss]) - dbnames=`su -l %%PG_USER%% -c "umask 077; psql -q -t -A -d template1 -U %%PG_USER%% -c SELECT\ datname\ FROM\ pg_database\ WHERE\ datname!=\'template0\'"` + dbnames=`su -l ${daily_pgsql_user} -c "umask 077; psql -U ${daily_pgsql_user} -p ${daily_pgsql_port} -q -t -A -d template1 -c SELECT\ datname\ FROM\ pg_database\ WHERE\ datname!=\'template0\'"` pgsql_backup $dbnames ;; Modified: head/databases/postgresql91-server/pkg-plist-client ============================================================================== --- head/databases/postgresql91-server/pkg-plist-client Sat Feb 13 22:35:55 2016 (r408834) +++ head/databases/postgresql91-server/pkg-plist-client Sat Feb 13 22:42:04 2016 (r408835) @@ -14,7 +14,31 @@ bin/psql bin/reindexdb bin/vacuumdb include/ecpg_config.h +include/ecpg_informix.h +include/ecpgerrno.h +include/ecpglib.h +include/ecpgtype.h include/libpq-events.h +include/libpq-fe.h +include/libpq/libpq-fs.h +include/pg_config.h +include/pg_config_manual.h +include/pg_config_os.h +include/pgtypes_date.h +include/pgtypes_error.h +include/pgtypes_interval.h +include/pgtypes_numeric.h +include/pgtypes_timestamp.h +include/postgres_ext.h +include/postgresql/informix/esql/datetime.h +include/postgresql/informix/esql/decimal.h +include/postgresql/informix/esql/sqltypes.h +include/postgresql/internal/c.h +include/postgresql/internal/libpq-int.h +include/postgresql/internal/libpq/pqcomm.h +include/postgresql/internal/port.h +include/postgresql/internal/postgres_fe.h +include/postgresql/internal/pqexpbuffer.h include/postgresql/server/access/attnum.h include/postgresql/server/access/clog.h include/postgresql/server/access/genam.h @@ -218,7 +242,6 @@ include/postgresql/server/nodes/bitmapse include/postgresql/server/nodes/execnodes.h include/postgresql/server/nodes/makefuncs.h include/postgresql/server/nodes/memnodes.h -include/postgresql/server/nodes/replnodes.h include/postgresql/server/nodes/nodeFuncs.h include/postgresql/server/nodes/nodes.h include/postgresql/server/nodes/params.h @@ -229,6 +252,7 @@ include/postgresql/server/nodes/primnode include/postgresql/server/nodes/print.h include/postgresql/server/nodes/readfuncs.h include/postgresql/server/nodes/relation.h +include/postgresql/server/nodes/replnodes.h include/postgresql/server/nodes/tidbitmap.h include/postgresql/server/nodes/value.h include/postgresql/server/optimizer/clauses.h @@ -283,6 +307,7 @@ include/postgresql/server/pg_config_manu include/postgresql/server/pg_config_os.h include/postgresql/server/pg_trace.h include/postgresql/server/pgstat.h +include/postgresql/server/pgtar.h include/postgresql/server/pgtime.h include/postgresql/server/port.h include/postgresql/server/port/aix.h @@ -495,35 +520,11 @@ include/postgresql/server/utils/uuid.h include/postgresql/server/utils/varbit.h include/postgresql/server/utils/xml.h include/postgresql/server/windowapi.h +include/sql3types.h +include/sqlca.h include/sqlda-compat.h include/sqlda-native.h include/sqlda.h -include/libpq/libpq-fs.h -include/postgresql/internal/libpq/pqcomm.h -include/postgresql/informix/esql/datetime.h -include/postgresql/informix/esql/decimal.h -include/postgresql/informix/esql/sqltypes.h -include/postgresql/internal/c.h -include/postgresql/internal/libpq-int.h -include/postgresql/internal/postgres_fe.h -include/postgresql/internal/port.h -include/postgresql/internal/pqexpbuffer.h -include/ecpg_informix.h -include/ecpgerrno.h -include/ecpglib.h -include/ecpgtype.h -include/libpq-fe.h -include/pg_config.h -include/pg_config_manual.h -include/pg_config_os.h -include/pgtypes_date.h -include/pgtypes_error.h -include/pgtypes_interval.h -include/pgtypes_numeric.h -include/pgtypes_timestamp.h -include/postgres_ext.h -include/sql3types.h -include/sqlca.h lib/libecpg.a lib/libecpg.so lib/libecpg.so.6 @@ -538,10 +539,11 @@ lib/libpq.a lib/libpq.so lib/libpq.so.5 lib/postgresql/pgxs/config/install-sh -lib/postgresql/pgxs/src/makefiles/pgxs.mk +lib/postgresql/pgxs/config/missing lib/postgresql/pgxs/src/Makefile.global lib/postgresql/pgxs/src/Makefile.port lib/postgresql/pgxs/src/Makefile.shlib +lib/postgresql/pgxs/src/makefiles/pgxs.mk lib/postgresql/pgxs/src/nls-global.mk man/man1/clusterdb.1.gz man/man1/createdb.1.gz Modified: head/databases/postgresql92-server/Makefile ============================================================================== --- head/databases/postgresql92-server/Makefile Sat Feb 13 22:35:55 2016 (r408834) +++ head/databases/postgresql92-server/Makefile Sat Feb 13 22:42:04 2016 (r408835) @@ -2,7 +2,7 @@ # $FreeBSD$ PORTNAME?= postgresql -DISTVERSION?= 9.2.14 +DISTVERSION?= 9.2.15 CATEGORIES?= databases MASTER_SITES= PGSQL/source/v${DISTVERSION} PKGNAMESUFFIX?= ${DISTVERSION:R:S/.//}${COMPONENT} @@ -68,7 +68,6 @@ SUB_FILES+= 502.pgsql OPTIONS_DEFINE+=LIBEDIT LIBEDIT_DESC= Use non-GPL libedit instead of readline USES+= perl5 -PORTREVISION?= 1 .else MAKE_ENV= PATH=${PREFIX}/bin:${PATH} CONFIGURE_ENV+= PATH=${PREFIX}/bin:${PATH} Modified: head/databases/postgresql92-server/distinfo ============================================================================== --- head/databases/postgresql92-server/distinfo Sat Feb 13 22:35:55 2016 (r408834) +++ head/databases/postgresql92-server/distinfo Sat Feb 13 22:42:04 2016 (r408835) @@ -1,4 +1,4 @@ -SHA256 (postgresql/postgresql-9.2.14.tar.bz2) = 54c20b3f320a48c38487f2711e98b2fa3f9ce4305905a294ad0449e8b4fb292e -SIZE (postgresql/postgresql-9.2.14.tar.bz2) = 16451398 +SHA256 (postgresql/postgresql-9.2.15.tar.bz2) = 7ced4807589899e83c64dd0803cf1f9782b6a20077ab545c66e868ef26543e60 +SIZE (postgresql/postgresql-9.2.15.tar.bz2) = 16480973 SHA256 (postgresql/pg-929-icu-2015-04-18.diff.gz) = 9aff1ba25fbe5892a3868bff516df685531c85901c360548e38bf2e5fa0e14ab SIZE (postgresql/pg-929-icu-2015-04-18.diff.gz) = 4469 Modified: head/databases/postgresql92-server/files/502.pgsql.in ============================================================================== --- head/databases/postgresql92-server/files/502.pgsql.in Sat Feb 13 22:35:55 2016 (r408834) +++ head/databases/postgresql92-server/files/502.pgsql.in Sat Feb 13 22:42:04 2016 (r408835) @@ -1,6 +1,6 @@ #!/bin/sh # -# $FreeBSD: /tmp/pcvs/ports/databases/postgresql92-server/files/502.pgsql.in,v 1.4 2011-10-18 09:03:32 girgen Exp $ +# $FreeBSD$ # # Maintenance shell script to vacuum and backup database # Put this in /usr/local/etc/periodic/daily, and it will be run @@ -19,14 +19,6 @@ # daily_pgsql_backup_enable="foo bar db1 db2" # only do backup of a limited selection of databases # daily_pgsql_vacuum_enable="YES" # do vacuum -daily_pgsql_user=%%PG_USER%% -daily_pgsql_vacuum_args="-U ${daily_pgsql_user} -qaz" -daily_pgsql_pgdump_args="-U ${daily_pgsql_user} -bF c" -daily_pgsql_pgdumpall_globals_args="-U ${daily_pgsql_user}" -# backupdir is relative to ~pgsql home directory unless it begins with a slash: -daily_pgsql_backupdir="~${daily_pgsql_user}/backups" -daily_pgsql_savedays="7" - # If there is a global system configuration file, suck it in. # if [ -r /etc/defaults/periodic.conf ] @@ -35,6 +27,15 @@ then source_periodic_confs fi +: ${daily_pgsql_user:="%%PG_USER%%"} +: ${daily_pgsql_port:=5432} +: ${daily_pgsql_vacuum_args:="-U ${daily_pgsql_user} -p ${daily_pgsql_port} -qaz"} +: ${daily_pgsql_pgdump_args:="-U ${daily_pgsql_user} -p ${daily_pgsql_port} -bF c"} +: ${daily_pgsql_pgdumpall_globals_args:="-U ${daily_pgsql_user} -p ${daily_pgsql_port}"} +# backupdir is relative to ~pgsql home directory unless it begins with a slash: +: ${daily_pgsql_backupdir:="~${daily_pgsql_user}/backups"} +: ${daily_pgsql_savedays:="7"} + # allow '~´ in dir name eval backupdir=${daily_pgsql_backupdir} @@ -82,7 +83,7 @@ pgsql_backup() { case "$daily_pgsql_backup_enable" in [Yy][Ee][Ss]) - dbnames=`su -l %%PG_USER%% -c "umask 077; psql -q -t -A -d template1 -U %%PG_USER%% -c SELECT\ datname\ FROM\ pg_database\ WHERE\ datname!=\'template0\'"` + dbnames=`su -l ${daily_pgsql_user} -c "umask 077; psql -U ${daily_pgsql_user} -p ${daily_pgsql_port} -q -t -A -d template1 -c SELECT\ datname\ FROM\ pg_database\ WHERE\ datname!=\'template0\'"` pgsql_backup $dbnames ;; Modified: head/databases/postgresql92-server/pkg-plist-client ============================================================================== --- head/databases/postgresql92-server/pkg-plist-client Sat Feb 13 22:35:55 2016 (r408834) +++ head/databases/postgresql92-server/pkg-plist-client Sat Feb 13 22:42:04 2016 (r408835) @@ -14,7 +14,31 @@ bin/psql bin/reindexdb bin/vacuumdb include/ecpg_config.h +include/ecpg_informix.h +include/ecpgerrno.h +include/ecpglib.h +include/ecpgtype.h include/libpq-events.h +include/libpq-fe.h +include/libpq/libpq-fs.h +include/pg_config.h +include/pg_config_manual.h +include/pg_config_os.h +include/pgtypes_date.h +include/pgtypes_error.h +include/pgtypes_interval.h +include/pgtypes_numeric.h +include/pgtypes_timestamp.h +include/postgres_ext.h +include/postgresql/informix/esql/datetime.h +include/postgresql/informix/esql/decimal.h +include/postgresql/informix/esql/sqltypes.h +include/postgresql/internal/c.h +include/postgresql/internal/libpq-int.h +include/postgresql/internal/libpq/pqcomm.h +include/postgresql/internal/port.h +include/postgresql/internal/postgres_fe.h +include/postgresql/internal/pqexpbuffer.h include/postgresql/server/access/attnum.h include/postgresql/server/access/clog.h include/postgresql/server/access/genam.h @@ -290,6 +314,7 @@ include/postgresql/server/pg_config_manu include/postgresql/server/pg_config_os.h include/postgresql/server/pg_trace.h include/postgresql/server/pgstat.h +include/postgresql/server/pgtar.h include/postgresql/server/pgtime.h include/postgresql/server/port.h include/postgresql/server/port/aix.h @@ -503,35 +528,11 @@ include/postgresql/server/utils/uuid.h include/postgresql/server/utils/varbit.h include/postgresql/server/utils/xml.h include/postgresql/server/windowapi.h +include/sql3types.h +include/sqlca.h include/sqlda-compat.h include/sqlda-native.h include/sqlda.h -include/libpq/libpq-fs.h -include/postgresql/internal/libpq/pqcomm.h -include/postgresql/informix/esql/datetime.h -include/postgresql/informix/esql/decimal.h -include/postgresql/informix/esql/sqltypes.h -include/postgresql/internal/c.h -include/postgresql/internal/libpq-int.h -include/postgresql/internal/postgres_fe.h -include/postgresql/internal/port.h -include/postgresql/internal/pqexpbuffer.h -include/ecpg_informix.h -include/ecpgerrno.h -include/ecpglib.h -include/ecpgtype.h -include/libpq-fe.h -include/pg_config.h -include/pg_config_manual.h -include/pg_config_os.h -include/pgtypes_date.h -include/pgtypes_error.h -include/pgtypes_interval.h -include/pgtypes_numeric.h -include/pgtypes_timestamp.h -include/postgres_ext.h -include/sql3types.h -include/sqlca.h lib/libecpg.a lib/libecpg.so lib/libecpg.so.6 @@ -546,10 +547,11 @@ lib/libpq.a lib/libpq.so lib/libpq.so.5 lib/postgresql/pgxs/config/install-sh -lib/postgresql/pgxs/src/makefiles/pgxs.mk +lib/postgresql/pgxs/config/missing lib/postgresql/pgxs/src/Makefile.global lib/postgresql/pgxs/src/Makefile.port lib/postgresql/pgxs/src/Makefile.shlib +lib/postgresql/pgxs/src/makefiles/pgxs.mk lib/postgresql/pgxs/src/nls-global.mk man/man1/clusterdb.1.gz man/man1/createdb.1.gz Modified: head/databases/postgresql93-server/Makefile ============================================================================== --- head/databases/postgresql93-server/Makefile Sat Feb 13 22:35:55 2016 (r408834) +++ head/databases/postgresql93-server/Makefile Sat Feb 13 22:42:04 2016 (r408835) @@ -1,7 +1,7 @@ # Created by: Marc G. Fournier <scrappy@FreeBSD.org> # $FreeBSD$ -DISTVERSION?= 9.3.10 +DISTVERSION?= 9.3.11 PKGNAMESUFFIX?= ${DISTVERSION:R:S/.//}${COMPONENT} MAINTAINER?= pgsql@FreeBSD.org Modified: head/databases/postgresql93-server/distinfo ============================================================================== --- head/databases/postgresql93-server/distinfo Sat Feb 13 22:35:55 2016 (r408834) +++ head/databases/postgresql93-server/distinfo Sat Feb 13 22:42:04 2016 (r408835) @@ -1,4 +1,4 @@ -SHA256 (postgresql/postgresql-9.3.10.tar.bz2) = e5444f0f76aff98a251400b7c28bc361d65e3d72d8d6cb9bb5d8361a69541531 -SIZE (postgresql/postgresql-9.3.10.tar.bz2) = 16995860 +SHA256 (postgresql/postgresql-9.3.11.tar.bz2) = 3d222a90c941d3a6c02c7c749fc9eb54ff20a1166570459d09c5476743496a21 +SIZE (postgresql/postgresql-9.3.11.tar.bz2) = 17047707 SHA256 (postgresql/pg-929-icu-2015-04-18.diff.gz) = 9aff1ba25fbe5892a3868bff516df685531c85901c360548e38bf2e5fa0e14ab SIZE (postgresql/pg-929-icu-2015-04-18.diff.gz) = 4469 Modified: head/databases/postgresql93-server/files/502.pgsql.in ============================================================================== --- head/databases/postgresql93-server/files/502.pgsql.in Sat Feb 13 22:35:55 2016 (r408834) +++ head/databases/postgresql93-server/files/502.pgsql.in Sat Feb 13 22:42:04 2016 (r408835) @@ -1,6 +1,6 @@ #!/bin/sh # -# $FreeBSD: /tmp/pcvs/ports/databases/postgresql92-server/files/502.pgsql.in,v 1.4 2011-10-18 09:03:32 girgen Exp $ +# $FreeBSD$ # # Maintenance shell script to vacuum and backup database # Put this in /usr/local/etc/periodic/daily, and it will be run @@ -19,14 +19,6 @@ # daily_pgsql_backup_enable="foo bar db1 db2" # only do backup of a limited selection of databases # daily_pgsql_vacuum_enable="YES" # do vacuum -daily_pgsql_user=%%PG_USER%% -daily_pgsql_vacuum_args="-U ${daily_pgsql_user} -qaz" -daily_pgsql_pgdump_args="-U ${daily_pgsql_user} -bF c" -daily_pgsql_pgdumpall_globals_args="-U ${daily_pgsql_user}" -# backupdir is relative to ~pgsql home directory unless it begins with a slash: -daily_pgsql_backupdir="~${daily_pgsql_user}/backups" -daily_pgsql_savedays="7" - # If there is a global system configuration file, suck it in. # if [ -r /etc/defaults/periodic.conf ] @@ -35,6 +27,15 @@ then source_periodic_confs fi +: ${daily_pgsql_user:="%%PG_USER%%"} +: ${daily_pgsql_port:=5432} +: ${daily_pgsql_vacuum_args:="-U ${daily_pgsql_user} -p ${daily_pgsql_port} -qaz"} +: ${daily_pgsql_pgdump_args:="-U ${daily_pgsql_user} -p ${daily_pgsql_port} -bF c"} +: ${daily_pgsql_pgdumpall_globals_args:="-U ${daily_pgsql_user} -p ${daily_pgsql_port}"} +# backupdir is relative to ~pgsql home directory unless it begins with a slash: +: ${daily_pgsql_backupdir:="~${daily_pgsql_user}/backups"} +: ${daily_pgsql_savedays:="7"} + # allow '~´ in dir name eval backupdir=${daily_pgsql_backupdir} @@ -82,7 +83,7 @@ pgsql_backup() { case "$daily_pgsql_backup_enable" in [Yy][Ee][Ss]) - dbnames=`su -l %%PG_USER%% -c "umask 077; psql -q -t -A -d template1 -U %%PG_USER%% -c SELECT\ datname\ FROM\ pg_database\ WHERE\ datname!=\'template0\'"` + dbnames=`su -l ${daily_pgsql_user} -c "umask 077; psql -U ${daily_pgsql_user} -p ${daily_pgsql_port} -q -t -A -d template1 -c SELECT\ datname\ FROM\ pg_database\ WHERE\ datname!=\'template0\'"` pgsql_backup $dbnames ;; Modified: head/databases/postgresql93-server/pkg-plist-client ============================================================================== --- head/databases/postgresql93-server/pkg-plist-client Sat Feb 13 22:35:55 2016 (r408834) +++ head/databases/postgresql93-server/pkg-plist-client Sat Feb 13 22:42:04 2016 (r408835) @@ -15,8 +15,32 @@ bin/psql bin/reindexdb bin/vacuumdb include/ecpg_config.h +include/ecpg_informix.h +include/ecpgerrno.h +include/ecpglib.h +include/ecpgtype.h include/libpq-events.h +include/libpq-fe.h +include/libpq/libpq-fs.h +include/pg_config.h include/pg_config_ext.h +include/pg_config_manual.h +include/pg_config_os.h +include/pgtypes_date.h +include/pgtypes_error.h +include/pgtypes_interval.h +include/pgtypes_numeric.h +include/pgtypes_timestamp.h +include/postgres_ext.h +include/postgresql/informix/esql/datetime.h +include/postgresql/informix/esql/decimal.h +include/postgresql/informix/esql/sqltypes.h +include/postgresql/internal/c.h +include/postgresql/internal/libpq-int.h +include/postgresql/internal/libpq/pqcomm.h +include/postgresql/internal/port.h +include/postgresql/internal/postgres_fe.h +include/postgresql/internal/pqexpbuffer.h include/postgresql/server/access/attnum.h include/postgresql/server/access/clog.h include/postgresql/server/access/genam.h @@ -528,35 +552,11 @@ include/postgresql/server/utils/uuid.h include/postgresql/server/utils/varbit.h include/postgresql/server/utils/xml.h include/postgresql/server/windowapi.h +include/sql3types.h +include/sqlca.h include/sqlda-compat.h include/sqlda-native.h include/sqlda.h -include/libpq/libpq-fs.h -include/postgresql/internal/libpq/pqcomm.h -include/postgresql/informix/esql/datetime.h -include/postgresql/informix/esql/decimal.h -include/postgresql/informix/esql/sqltypes.h -include/postgresql/internal/c.h -include/postgresql/internal/libpq-int.h -include/postgresql/internal/postgres_fe.h -include/postgresql/internal/port.h -include/postgresql/internal/pqexpbuffer.h -include/ecpg_informix.h -include/ecpgerrno.h -include/ecpglib.h -include/ecpgtype.h -include/libpq-fe.h -include/pg_config.h -include/pg_config_manual.h -include/pg_config_os.h -include/pgtypes_date.h -include/pgtypes_error.h -include/pgtypes_interval.h -include/pgtypes_numeric.h -include/pgtypes_timestamp.h -include/postgres_ext.h -include/sql3types.h -include/sqlca.h lib/libecpg.a lib/libecpg.so lib/libecpg.so.6 @@ -570,16 +570,17 @@ lib/libpgtypes.so.3 lib/libpq.a lib/libpq.so lib/libpq.so.5 -libdata/pkgconfig/libecpg.pc -libdata/pkgconfig/libecpg_compat.pc -libdata/pkgconfig/libpgtypes.pc -libdata/pkgconfig/libpq.pc lib/postgresql/pgxs/config/install-sh -lib/postgresql/pgxs/src/makefiles/pgxs.mk +lib/postgresql/pgxs/config/missing lib/postgresql/pgxs/src/Makefile.global lib/postgresql/pgxs/src/Makefile.port lib/postgresql/pgxs/src/Makefile.shlib +lib/postgresql/pgxs/src/makefiles/pgxs.mk lib/postgresql/pgxs/src/nls-global.mk +libdata/pkgconfig/libecpg.pc +libdata/pkgconfig/libecpg_compat.pc +libdata/pkgconfig/libpgtypes.pc +libdata/pkgconfig/libpq.pc man/man1/clusterdb.1.gz man/man1/createdb.1.gz man/man1/createlang.1.gz Modified: head/databases/postgresql94-server/Makefile ============================================================================== --- head/databases/postgresql94-server/Makefile Sat Feb 13 22:35:55 2016 (r408834) +++ head/databases/postgresql94-server/Makefile Sat Feb 13 22:42:04 2016 (r408835) @@ -1,7 +1,7 @@ # Created by: Marc G. Fournier <scrappy@FreeBSD.org> # $FreeBSD$ -DISTVERSION?= 9.4.5 +DISTVERSION?= 9.4.6 MAINTAINER?= pgsql@FreeBSD.org Modified: head/databases/postgresql94-server/distinfo ============================================================================== --- head/databases/postgresql94-server/distinfo Sat Feb 13 22:35:55 2016 (r408834) +++ head/databases/postgresql94-server/distinfo Sat Feb 13 22:42:04 2016 (r408835) @@ -1,4 +1,4 @@ -SHA256 (postgresql/postgresql-9.4.5.tar.bz2) = b87c50c66b6ea42a9712b5f6284794fabad0616e6ae420cf0f10523be6d94a39 -SIZE (postgresql/postgresql-9.4.5.tar.bz2) = 17660960 +SHA256 (postgresql/postgresql-9.4.6.tar.bz2) = cbce1f4d01a6142c5d8bebe125623c5198ec04f363da7dd3d3b3a4100b4140a6 +SIZE (postgresql/postgresql-9.4.6.tar.bz2) = 17734946 SHA256 (postgresql/pg-941-icu-2015-04-18.diff.gz) = 30c1366539fd0833db37a98b32bd22e8da4538e58f8dbc2ad2f63dc54835609b SIZE (postgresql/pg-941-icu-2015-04-18.diff.gz) = 4279 Modified: head/databases/postgresql94-server/files/502.pgsql.in ============================================================================== --- head/databases/postgresql94-server/files/502.pgsql.in Sat Feb 13 22:35:55 2016 (r408834) +++ head/databases/postgresql94-server/files/502.pgsql.in Sat Feb 13 22:42:04 2016 (r408835) @@ -1,6 +1,6 @@ #!/bin/sh # -# $FreeBSD: /tmp/pcvs/ports/databases/postgresql92-server/files/502.pgsql.in,v 1.4 2011-10-18 09:03:32 girgen Exp $ +# $FreeBSD$ # # Maintenance shell script to vacuum and backup database # Put this in /usr/local/etc/periodic/daily, and it will be run @@ -19,14 +19,6 @@ # daily_pgsql_backup_enable="foo bar db1 db2" # only do backup of a limited selection of databases # daily_pgsql_vacuum_enable="YES" # do vacuum -daily_pgsql_user=%%PG_USER%% -daily_pgsql_vacuum_args="-U ${daily_pgsql_user} -qaz" -daily_pgsql_pgdump_args="-U ${daily_pgsql_user} -bF c" -daily_pgsql_pgdumpall_globals_args="-U ${daily_pgsql_user}" -# backupdir is relative to ~pgsql home directory unless it begins with a slash: -daily_pgsql_backupdir="~${daily_pgsql_user}/backups" -daily_pgsql_savedays="7" - # If there is a global system configuration file, suck it in. # if [ -r /etc/defaults/periodic.conf ] @@ -35,6 +27,15 @@ then source_periodic_confs fi +: ${daily_pgsql_user:="%%PG_USER%%"} +: ${daily_pgsql_port:=5432} +: ${daily_pgsql_vacuum_args:="-U ${daily_pgsql_user} -p ${daily_pgsql_port} -qaz"} +: ${daily_pgsql_pgdump_args:="-U ${daily_pgsql_user} -p ${daily_pgsql_port} -bF c"} +: ${daily_pgsql_pgdumpall_globals_args:="-U ${daily_pgsql_user} -p ${daily_pgsql_port}"} +# backupdir is relative to ~pgsql home directory unless it begins with a slash: +: ${daily_pgsql_backupdir:="~${daily_pgsql_user}/backups"} +: ${daily_pgsql_savedays:="7"} + # allow '~´ in dir name eval backupdir=${daily_pgsql_backupdir} @@ -82,7 +83,7 @@ pgsql_backup() { case "$daily_pgsql_backup_enable" in [Yy][Ee][Ss]) - dbnames=`su -l %%PG_USER%% -c "umask 077; psql -q -t -A -d template1 -U %%PG_USER%% -c SELECT\ datname\ FROM\ pg_database\ WHERE\ datname!=\'template0\'"` + dbnames=`su -l ${daily_pgsql_user} -c "umask 077; psql -U ${daily_pgsql_user} -p ${daily_pgsql_port} -q -t -A -d template1 -c SELECT\ datname\ FROM\ pg_database\ WHERE\ datname!=\'template0\'"` pgsql_backup $dbnames ;; Modified: head/databases/postgresql94-server/pkg-plist-client ============================================================================== --- head/databases/postgresql94-server/pkg-plist-client Sat Feb 13 22:35:55 2016 (r408834) +++ head/databases/postgresql94-server/pkg-plist-client Sat Feb 13 22:42:04 2016 (r408835) @@ -591,6 +591,7 @@ lib/libpq.a lib/libpq.so lib/libpq.so.5 lib/postgresql/pgxs/config/install-sh +lib/postgresql/pgxs/config/missing lib/postgresql/pgxs/src/Makefile.global lib/postgresql/pgxs/src/Makefile.port lib/postgresql/pgxs/src/Makefile.shlib Modified: head/databases/postgresql95-server/Makefile ============================================================================== --- head/databases/postgresql95-server/Makefile Sat Feb 13 22:35:55 2016 (r408834) +++ head/databases/postgresql95-server/Makefile Sat Feb 13 22:42:04 2016 (r408835) @@ -1,8 +1,7 @@ # Created by: Marc G. Fournier <scrappy@FreeBSD.org> # $FreeBSD$ -DISTVERSION?= 9.5.0 -PORTREVISION?= 2 +DISTVERSION?= 9.5.1 MAINTAINER?= pgsql@FreeBSD.org Modified: head/databases/postgresql95-server/distinfo ============================================================================== --- head/databases/postgresql95-server/distinfo Sat Feb 13 22:35:55 2016 (r408834) +++ head/databases/postgresql95-server/distinfo Sat Feb 13 22:42:04 2016 (r408835) @@ -1,2 +1,2 @@ -SHA256 (postgresql/postgresql-9.5.0.tar.bz2) = f1c0d3a1a8aa8c92738cab0153fbfffcc4d4158b3fee84f7aa6bfea8283978bc -SIZE (postgresql/postgresql-9.5.0.tar.bz2) = 18378311 +SHA256 (postgresql/postgresql-9.5.1.tar.bz2) = 6b309d8506a39773a752ff074f47656e5424576ea090b04a24fe1725958c5bd2 +SIZE (postgresql/postgresql-9.5.1.tar.bz2) = 18441638 Modified: head/databases/postgresql95-server/files/502.pgsql.in ============================================================================== --- head/databases/postgresql95-server/files/502.pgsql.in Sat Feb 13 22:35:55 2016 (r408834) +++ head/databases/postgresql95-server/files/502.pgsql.in Sat Feb 13 22:42:04 2016 (r408835) @@ -1,6 +1,6 @@ #!/bin/sh # -# $FreeBSD: /tmp/pcvs/ports/databases/postgresql92-server/files/502.pgsql.in,v 1.4 2011-10-18 09:03:32 girgen Exp $ +# $FreeBSD$ # # Maintenance shell script to vacuum and backup database # Put this in /usr/local/etc/periodic/daily, and it will be run Modified: head/databases/postgresql95-server/pkg-plist-client ============================================================================== --- head/databases/postgresql95-server/pkg-plist-client Sat Feb 13 22:35:55 2016 (r408834) +++ head/databases/postgresql95-server/pkg-plist-client Sat Feb 13 22:42:04 2016 (r408835) @@ -960,7 +960,11 @@ man/man7/WITH.7.gz %%NLS%%share/locale/ja/LC_MESSAGES/pgscripts-9.5.mo %%NLS%%share/locale/ja/LC_MESSAGES/psql-9.5.mo %%NLS%%share/locale/ko/LC_MESSAGES/ecpg-9.5.mo +%%NLS%%share/locale/ko/LC_MESSAGES/ecpglib6-9.5.mo +%%NLS%%share/locale/ko/LC_MESSAGES/libpq5-9.5.mo %%NLS%%share/locale/ko/LC_MESSAGES/pg_config-9.5.mo +%%NLS%%share/locale/ko/LC_MESSAGES/pg_dump-9.5.mo +%%NLS%%share/locale/ko/LC_MESSAGES/pgscripts-9.5.mo %%NLS%%share/locale/ko/LC_MESSAGES/psql-9.5.mo %%NLS%%share/locale/nb/LC_MESSAGES/pg_config-9.5.mo %%NLS%%share/locale/pl/LC_MESSAGES/ecpg-9.5.mo Modified: head/databases/postgresql95-server/pkg-plist-server ============================================================================== --- head/databases/postgresql95-server/pkg-plist-server Sat Feb 13 22:35:55 2016 (r408834) +++ head/databases/postgresql95-server/pkg-plist-server Sat Feb 13 22:42:04 2016 (r408835) @@ -59,6 +59,7 @@ lib/libpgcommon.a %%DATADIR%%/extension/plpgsql--1.0.sql %%DATADIR%%/extension/plpgsql--unpackaged--1.0.sql %%DATADIR%%/extension/plpgsql.control +%%DATADIR%%/postgres.shdescription %%NLS%%share/locale/cs/LC_MESSAGES/initdb-9.5.mo %%NLS%%share/locale/cs/LC_MESSAGES/pg_controldata-9.5.mo %%NLS%%share/locale/cs/LC_MESSAGES/pg_ctl-9.5.mo @@ -69,6 +70,7 @@ lib/libpgcommon.a %%NLS%%share/locale/de/LC_MESSAGES/pg_controldata-9.5.mo %%NLS%%share/locale/de/LC_MESSAGES/pg_ctl-9.5.mo %%NLS%%share/locale/de/LC_MESSAGES/pg_resetxlog-9.5.mo +%%NLS%%share/locale/de/LC_MESSAGES/pg_rewind-9.5.mo %%NLS%%share/locale/de/LC_MESSAGES/plpgsql-9.5.mo %%NLS%%share/locale/de/LC_MESSAGES/postgres-9.5.mo %%NLS%%share/locale/es/LC_MESSAGES/initdb-9.5.mo @@ -76,6 +78,7 @@ lib/libpgcommon.a %%NLS%%share/locale/es/LC_MESSAGES/pg_controldata-9.5.mo %%NLS%%share/locale/es/LC_MESSAGES/pg_ctl-9.5.mo %%NLS%%share/locale/es/LC_MESSAGES/pg_resetxlog-9.5.mo +%%NLS%%share/locale/es/LC_MESSAGES/pg_rewind-9.5.mo %%NLS%%share/locale/es/LC_MESSAGES/plpgsql-9.5.mo %%NLS%%share/locale/es/LC_MESSAGES/postgres-9.5.mo %%NLS%%share/locale/fr/LC_MESSAGES/initdb-9.5.mo @@ -91,6 +94,7 @@ lib/libpgcommon.a %%NLS%%share/locale/it/LC_MESSAGES/pg_controldata-9.5.mo %%NLS%%share/locale/it/LC_MESSAGES/pg_ctl-9.5.mo %%NLS%%share/locale/it/LC_MESSAGES/pg_resetxlog-9.5.mo +%%NLS%%share/locale/it/LC_MESSAGES/pg_rewind-9.5.mo %%NLS%%share/locale/it/LC_MESSAGES/plpgsql-9.5.mo %%NLS%%share/locale/it/LC_MESSAGES/postgres-9.5.mo %%NLS%%share/locale/ja/LC_MESSAGES/initdb-9.5.mo @@ -99,11 +103,19 @@ lib/libpgcommon.a %%NLS%%share/locale/ja/LC_MESSAGES/pg_resetxlog-9.5.mo %%NLS%%share/locale/ja/LC_MESSAGES/plpgsql-9.5.mo %%NLS%%share/locale/ja/LC_MESSAGES/postgres-9.5.mo +%%NLS%%share/locale/ko/LC_MESSAGES/initdb-9.5.mo +%%NLS%%share/locale/ko/LC_MESSAGES/pg_basebackup-9.5.mo +%%NLS%%share/locale/ko/LC_MESSAGES/pg_controldata-9.5.mo +%%NLS%%share/locale/ko/LC_MESSAGES/pg_ctl-9.5.mo +%%NLS%%share/locale/ko/LC_MESSAGES/pg_resetxlog-9.5.mo +%%NLS%%share/locale/ko/LC_MESSAGES/pg_rewind-9.5.mo +%%NLS%%share/locale/ko/LC_MESSAGES/pl%%PG_USER%%-9.5.mo %%NLS%%share/locale/pl/LC_MESSAGES/initdb-9.5.mo %%NLS%%share/locale/pl/LC_MESSAGES/pg_basebackup-9.5.mo %%NLS%%share/locale/pl/LC_MESSAGES/pg_controldata-9.5.mo %%NLS%%share/locale/pl/LC_MESSAGES/pg_ctl-9.5.mo %%NLS%%share/locale/pl/LC_MESSAGES/pg_resetxlog-9.5.mo +%%NLS%%share/locale/pl/LC_MESSAGES/pg_rewind-9.5.mo %%NLS%%share/locale/pl/LC_MESSAGES/plpgsql-9.5.mo %%NLS%%share/locale/pl/LC_MESSAGES/postgres-9.5.mo %%NLS%%share/locale/pt_BR/LC_MESSAGES/initdb-9.5.mo @@ -119,6 +131,7 @@ lib/libpgcommon.a %%NLS%%share/locale/ru/LC_MESSAGES/pg_controldata-9.5.mo %%NLS%%share/locale/ru/LC_MESSAGES/pg_ctl-9.5.mo %%NLS%%share/locale/ru/LC_MESSAGES/pg_resetxlog-9.5.mo +%%NLS%%share/locale/ru/LC_MESSAGES/pg_rewind-9.5.mo %%NLS%%share/locale/ru/LC_MESSAGES/plpgsql-9.5.mo %%NLS%%share/locale/ru/LC_MESSAGES/postgres-9.5.mo %%NLS%%share/locale/sv/LC_MESSAGES/initdb-9.5.mo @@ -130,10 +143,10 @@ lib/libpgcommon.a %%NLS%%share/locale/zh_CN/LC_MESSAGES/pg_controldata-9.5.mo %%NLS%%share/locale/zh_CN/LC_MESSAGES/pg_ctl-9.5.mo %%NLS%%share/locale/zh_CN/LC_MESSAGES/pg_resetxlog-9.5.mo +%%NLS%%share/locale/zh_CN/LC_MESSAGES/pg_rewind-9.5.mo %%NLS%%share/locale/zh_CN/LC_MESSAGES/plpgsql-9.5.mo %%NLS%%share/locale/zh_CN/LC_MESSAGES/postgres-9.5.mo %%NLS%%share/locale/zh_TW/LC_MESSAGES/plpgsql-9.5.mo -%%DATADIR%%/postgres.shdescription %%DATADIR%%/snowball_create.sql %%TZDATA%%%%DATADIR%%/timezone/Africa/Abidjan %%TZDATA%%%%DATADIR%%/timezone/Africa/Accra
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?201602132242.u1DMg4j4092391>