pkgsrc-Changes-HG archive
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index][Old Index]
[pkgsrc/trunk]: pkgsrc/databases The PostgreSQL Global Development Group has ...
details: https://anonhg.NetBSD.org/pkgsrc/rev/9181a2e08ac1
branches: trunk
changeset: 351608:9181a2e08ac1
user: adam <adam%pkgsrc.org@localhost>
date: Tue Aug 23 06:28:15 2016 +0000
description:
The PostgreSQL Global Development Group has released an update to all supported versions of our database system, including 9.5.4, 9.4.9, 9.3.14, 9.2.18 and 9.1.23. This release fixes two security
issues. It also patches a number of other bugs reported over the last three months. Users who rely on security isolation between database users should update as soon as possible. Other users should
plan to update at the next convenient downtime.
Security Issues
---------------
Two security holes have been closed by this release:
CVE-2016-5423: certain nested CASE expressions can cause the server to crash.
CVE-2016-5424: database and role names with embedded special characters can allow code injection during administrative operations like pg_dumpall.
The fix for the second issue also adds an option, -reuse-previous, to psql's \connect command. pg_dumpall will also refuse to handle database and role names containing line breaks after the update.
For more information on these issues and how they affect backwards-compatibility, see the Release Notes.
Bug Fixes and Improvements
--------------------------
This update also fixes a number of bugs reported in the last few months. Some of these issues affect only version 9.5, but many affect all supported versions:
Fix misbehaviors of IS NULL/IS NOT NULL with composite values
Fix three areas where INSERT ... ON CONFLICT failed to work properly with other SQL features.
Make INET and CIDR data types properly reject bad IPv6 values
Prevent crash in "point ## lseg" operator for NaN input
Avoid possible crash in pg_get_expr()
Fix several one-byte buffer over-reads in to_number()
Don't needlessly plan query if WITH NO DATA is specified
Avoid crash-unsafe state in expensive heap_update() paths
Fix hint bit update during WAL replay of row locking operations
Avoid unnecessary "could not serialize access" with FOR KEY SHARE
Avoid crash in postgres -C when the specified variable is a null string
Fix two issues with logical decoding and subtransactions
Ensure that backends see up-to-date statistics for shared catalogs
Prevent possible failure when vacuuming multixact IDs in an upgraded database
When a manual ANALYZE specifies columns, don't reset changes_since_analyze
Fix ANALYZE's overestimation of n_distinct for columns with nulls
Fix bug in b-tree mark/restore processing
Fix building of large (bigger than shared_buffers) hash indexes
Prevent infinite loop in GiST index build with NaN values
Fix possible crash during a nearest-neighbor indexscan
Fix "PANIC: failed to add BRIN tuple" error
Prevent possible crash during background worker shutdown
Many fixes for issues in parallel pg_dump and pg_restore
Make pg_basebackup accept -Z 0 as no compression
Make regression tests safe for Danish and Welsh locales
diffstat:
databases/postgresql91-docs/Makefile | 3 +-
databases/postgresql91-docs/PLIST | 3 +-
databases/postgresql91-plperl/Makefile | 3 +-
databases/postgresql91/Makefile | 3 +-
databases/postgresql91/Makefile.common | 4 +-
databases/postgresql91/distinfo | 14 +-
databases/postgresql91/patches/patch-src_timezone_localtime.c | 31 ----
databases/postgresql91/patches/patch-src_timezone_private.h | 15 --
databases/postgresql91/patches/patch-src_timezone_strftime.c | 13 -
databases/postgresql91/patches/patch-src_timezone_zic.c | 78 -----------
databases/postgresql92-docs/Makefile | 3 +-
databases/postgresql92-docs/PLIST | 4 +-
databases/postgresql92-plperl/Makefile | 3 +-
databases/postgresql92/Makefile | 3 +-
databases/postgresql92/Makefile.common | 4 +-
databases/postgresql92/distinfo | 14 +-
databases/postgresql92/patches/patch-src_timezone_localtime.c | 31 ----
databases/postgresql92/patches/patch-src_timezone_private.h | 15 --
databases/postgresql92/patches/patch-src_timezone_strftime.c | 13 -
databases/postgresql92/patches/patch-src_timezone_zic.c | 78 -----------
databases/postgresql93-client/Makefile | 3 +-
databases/postgresql93-docs/Makefile | 3 +-
databases/postgresql93-docs/PLIST | 5 +-
databases/postgresql93-plperl/Makefile | 3 +-
databases/postgresql93/Makefile | 3 +-
databases/postgresql93/Makefile.common | 4 +-
databases/postgresql93/distinfo | 14 +-
databases/postgresql93/patches/patch-src_timezone_localtime.c | 31 ----
databases/postgresql93/patches/patch-src_timezone_private.h | 15 --
databases/postgresql93/patches/patch-src_timezone_strftime.c | 13 -
databases/postgresql93/patches/patch-src_timezone_zic.c | 78 -----------
databases/postgresql94/Makefile | 3 +-
databases/postgresql95-docs/Makefile | 3 +-
databases/postgresql95-docs/PLIST | 7 +-
databases/postgresql95-plperl/Makefile | 3 +-
databases/postgresql95/Makefile | 3 +-
databases/postgresql95/Makefile.common | 4 +-
databases/postgresql95/distinfo | 14 +-
databases/postgresql95/patches/patch-src_timezone_localtime.c | 31 ----
databases/postgresql95/patches/patch-src_timezone_private.h | 15 --
databases/postgresql95/patches/patch-src_timezone_strftime.c | 13 -
databases/postgresql95/patches/patch-src_timezone_zic.c | 78 -----------
42 files changed, 57 insertions(+), 624 deletions(-)
diffs (truncated from 1077 to 300 lines):
diff -r b686a1281957 -r 9181a2e08ac1 databases/postgresql91-docs/Makefile
--- a/databases/postgresql91-docs/Makefile Tue Aug 23 05:10:48 2016 +0000
+++ b/databases/postgresql91-docs/Makefile Tue Aug 23 06:28:15 2016 +0000
@@ -1,7 +1,6 @@
-# $NetBSD: Makefile,v 1.13 2016/07/09 06:38:02 wiz Exp $
+# $NetBSD: Makefile,v 1.14 2016/08/23 06:28:15 adam Exp $
PKGNAME= ${DISTNAME:C/-/91-docs-/}
-PKGREVISION= 1
COMMENT= PostgreSQL database documentation
.include "../../databases/postgresql91/Makefile.common"
diff -r b686a1281957 -r 9181a2e08ac1 databases/postgresql91-docs/PLIST
--- a/databases/postgresql91-docs/PLIST Tue Aug 23 05:10:48 2016 +0000
+++ b/databases/postgresql91-docs/PLIST Tue Aug 23 06:28:15 2016 +0000
@@ -1,4 +1,4 @@
-@comment $NetBSD: PLIST,v 1.24 2016/05/23 14:27:34 adam Exp $
+@comment $NetBSD: PLIST,v 1.25 2016/08/23 06:28:15 adam Exp $
man/man1/clusterdb.1
man/man1/createdb.1
man/man1/createlang.1
@@ -1026,6 +1026,7 @@
share/doc/postgresql/html/release-9-1-2.html
share/doc/postgresql/html/release-9-1-21.html
share/doc/postgresql/html/release-9-1-22.html
+share/doc/postgresql/html/release-9-1-23.html
share/doc/postgresql/html/release-9-1-3.html
share/doc/postgresql/html/release-9-1-4.html
share/doc/postgresql/html/release-9-1-5.html
diff -r b686a1281957 -r 9181a2e08ac1 databases/postgresql91-plperl/Makefile
--- a/databases/postgresql91-plperl/Makefile Tue Aug 23 05:10:48 2016 +0000
+++ b/databases/postgresql91-plperl/Makefile Tue Aug 23 06:28:15 2016 +0000
@@ -1,7 +1,6 @@
-# $NetBSD: Makefile,v 1.20 2016/07/09 06:38:02 wiz Exp $
+# $NetBSD: Makefile,v 1.21 2016/08/23 06:28:15 adam Exp $
PKGNAME= ${DISTNAME:C/-/91-plperl-/}
-PKGREVISION= 1
COMMENT= PL/Perl procedural language for the PostgreSQL backend
DEPENDS+= postgresql91-server>=${PKGVERSION_NOREV}:../../databases/postgresql91-server
diff -r b686a1281957 -r 9181a2e08ac1 databases/postgresql91/Makefile
--- a/databases/postgresql91/Makefile Tue Aug 23 05:10:48 2016 +0000
+++ b/databases/postgresql91/Makefile Tue Aug 23 06:28:15 2016 +0000
@@ -1,7 +1,6 @@
-# $NetBSD: Makefile,v 1.14 2016/07/09 06:38:01 wiz Exp $
+# $NetBSD: Makefile,v 1.15 2016/08/23 06:28:15 adam Exp $
PKGNAME= ${DISTNAME:C/-/91-/}
-PKGREVISION= 1
COMMENT= Robust, next generation, object-relational DBMS
DEPENDS+= postgresql91-client>=${PKGVERSION_NOREV}:../../databases/postgresql91-client
diff -r b686a1281957 -r 9181a2e08ac1 databases/postgresql91/Makefile.common
--- a/databases/postgresql91/Makefile.common Tue Aug 23 05:10:48 2016 +0000
+++ b/databases/postgresql91/Makefile.common Tue Aug 23 06:28:15 2016 +0000
@@ -1,4 +1,4 @@
-# $NetBSD: Makefile.common,v 1.33 2016/06/19 21:09:54 fhajny Exp $
+# $NetBSD: Makefile.common,v 1.34 2016/08/23 06:28:15 adam Exp $
#
# This Makefile fragment is included by all PostgreSQL packages built from
# the main sources of the PostgreSQL distribution except jdbc-postgresql.
@@ -16,7 +16,7 @@
# used by databases/postgresql91-pltcl/Makefile
# used by databases/postgresql91-server/Makefile
-DISTNAME= postgresql-9.1.22
+DISTNAME= postgresql-9.1.23
CATEGORIES= databases
MASTER_SITES= ${MASTER_SITE_PGSQL:=source/v${PKGVERSION_NOREV}/}
EXTRACT_SUFX= .tar.bz2
diff -r b686a1281957 -r 9181a2e08ac1 databases/postgresql91/distinfo
--- a/databases/postgresql91/distinfo Tue Aug 23 05:10:48 2016 +0000
+++ b/databases/postgresql91/distinfo Tue Aug 23 06:28:15 2016 +0000
@@ -1,9 +1,9 @@
-$NetBSD: distinfo,v 1.29 2016/05/23 14:27:34 adam Exp $
+$NetBSD: distinfo,v 1.30 2016/08/23 06:28:15 adam Exp $
-SHA1 (postgresql-9.1.22.tar.bz2) = 563f6e00e89ddfd229235c4f29f3c37268291b2b
-RMD160 (postgresql-9.1.22.tar.bz2) = 0a0c2f3fa9ba3faf09d047968de31cc6ceaa9e6d
-SHA512 (postgresql-9.1.22.tar.bz2) = a2ed0a1f0d0920f6151d128a206c557b14832ab296dbf51c665309434a851b83eefd12a5a36c870ee0281371350b6b86ac6e81188c164c72407847cf9e70d691
-Size (postgresql-9.1.22.tar.bz2) = 15860904 bytes
+SHA1 (postgresql-9.1.23.tar.bz2) = 9b3c51c4b40d69e6d84c1a0ac464828b559f7362
+RMD160 (postgresql-9.1.23.tar.bz2) = 5ec47504950f42d7f6fa07059e5e5daa7caef1c3
+SHA512 (postgresql-9.1.23.tar.bz2) = 192f48ed8db510663c85c217afee8eff732d467fe10f600c9be834371ccb6a788acd380c582d80f0096a0b7d7ee0daa378d1fb8177281bf4e6e2fcc39fffdc67
+Size (postgresql-9.1.23.tar.bz2) = 15856178 bytes
SHA1 (patch-config_perl.m4) = c7e5aaff1c47d2e33df7692a412ef984c77ffcc0
SHA1 (patch-configure) = dab79533dac06a79a5aa8439d6b15830d8d2fba7
SHA1 (patch-contrib_dblink_Makefile) = 4960ad57d42465fae203870548e4c53f8a32ce04
@@ -15,7 +15,3 @@
SHA1 (patch-src_makefiles_Makefile.solaris) = 0168f5bc105ffc89d5db40907a08966d8465f5a0
SHA1 (patch-src_pl_plperl_GNUmakefile) = 2b7448d6dd8550e2ea61f40728a2780068b93d07
SHA1 (patch-src_pl_plperl_plperl.h) = bd663fa80a47f7b82ce689060750fa6e631fbc61
-SHA1 (patch-src_timezone_localtime.c) = a73769cf05223d2ee06249c9e69c85038c2cd936
-SHA1 (patch-src_timezone_private.h) = 85dac95e40efc16270885087f868aeb76e1b9214
-SHA1 (patch-src_timezone_strftime.c) = 25102dce1b9b22385353af23500636fb18e3bf64
-SHA1 (patch-src_timezone_zic.c) = 0d6f536f7593e362ec216eafa73c718ad6bed8fc
diff -r b686a1281957 -r 9181a2e08ac1 databases/postgresql91/patches/patch-src_timezone_localtime.c
--- a/databases/postgresql91/patches/patch-src_timezone_localtime.c Tue Aug 23 05:10:48 2016 +0000
+++ /dev/null Thu Jan 01 00:00:00 1970 +0000
@@ -1,31 +0,0 @@
-$NetBSD: patch-src_timezone_localtime.c,v 1.1.1.1 2011/09/15 08:27:39 adam Exp $
-
---- src/timezone/localtime.c.orig 2009-06-11 16:49:15.000000000 +0200
-+++ src/timezone/localtime.c
-@@ -80,20 +80,20 @@ static pg_time_t detzcode64(const char *
- static int differ_by_repeat(pg_time_t t1, pg_time_t t0);
- static const char *getzname(const char *strp);
- static const char *getqzname(const char *strp, int delim);
--static const char *getnum(const char *strp, int *nump, int min, int max);
-+static const char *getnum(const char *strp, int *nump, const int min, const int max);
- static const char *getsecs(const char *strp, long *secsp);
- static const char *getoffset(const char *strp, long *offsetp);
- static const char *getrule(const char *strp, struct rule * rulep);
- static void gmtload(struct state * sp);
--static struct pg_tm *gmtsub(const pg_time_t *timep, long offset,
-+static struct pg_tm *gmtsub(const pg_time_t *timep, const long offset,
- struct pg_tm * tmp);
--static struct pg_tm *localsub(const pg_time_t *timep, long offset,
-+static struct pg_tm *localsub(const pg_time_t *timep, const long offset,
- struct pg_tm * tmp, const pg_tz *tz);
- static int increment_overflow(int *number, int delta);
--static pg_time_t transtime(pg_time_t janfirst, int year,
-- const struct rule * rulep, long offset);
-+static pg_time_t transtime(pg_time_t janfirst, const int year,
-+ const struct rule * rulep, const long offset);
- static int typesequiv(const struct state * sp, int a, int b);
--static struct pg_tm *timesub(const pg_time_t *timep, long offset,
-+static struct pg_tm *timesub(const pg_time_t *timep, const long offset,
- const struct state * sp, struct pg_tm * tmp);
-
- /* GMT timezone */
diff -r b686a1281957 -r 9181a2e08ac1 databases/postgresql91/patches/patch-src_timezone_private.h
--- a/databases/postgresql91/patches/patch-src_timezone_private.h Tue Aug 23 05:10:48 2016 +0000
+++ /dev/null Thu Jan 01 00:00:00 1970 +0000
@@ -1,15 +0,0 @@
-$NetBSD: patch-src_timezone_private.h,v 1.1.1.1 2011/09/15 08:27:39 adam Exp $
-
---- src/timezone/private.h.orig 2009-06-11 16:49:15.000000000 +0200
-+++ src/timezone/private.h
-@@ -51,8 +51,8 @@ extern int unlink(const char *filename);
- extern char *icalloc(int nelem, int elsize);
- extern char *icatalloc(char *old, const char *new);
- extern char *icpyalloc(const char *string);
--extern char *imalloc(int n);
--extern void *irealloc(void *pointer, int size);
-+extern char *imalloc(const int n);
-+extern void *irealloc(void *pointer, const int size);
- extern void icfree(char *pointer);
- extern void ifree(char *pointer);
- extern const char *scheck(const char *string, const char *format);
diff -r b686a1281957 -r 9181a2e08ac1 databases/postgresql91/patches/patch-src_timezone_strftime.c
--- a/databases/postgresql91/patches/patch-src_timezone_strftime.c Tue Aug 23 05:10:48 2016 +0000
+++ /dev/null Thu Jan 01 00:00:00 1970 +0000
@@ -1,13 +0,0 @@
-$NetBSD: patch-src_timezone_strftime.c,v 1.1.1.1 2011/09/15 08:27:39 adam Exp $
-
---- src/timezone/strftime.c.orig 2009-06-11 16:49:15.000000000 +0200
-+++ src/timezone/strftime.c
-@@ -89,7 +89,7 @@ static const struct lc_time_T C_time_loc
- };
-
- static char *_add(const char *, char *, const char *);
--static char *_conv(int, const char *, char *, const char *);
-+static char *_conv(const int, const char *, char *, const char *);
- static char *_fmt(const char *, const struct pg_tm *, char *,
- const char *, int *);
- static char *_yconv(const int, const int, const int, const int,
diff -r b686a1281957 -r 9181a2e08ac1 databases/postgresql91/patches/patch-src_timezone_zic.c
--- a/databases/postgresql91/patches/patch-src_timezone_zic.c Tue Aug 23 05:10:48 2016 +0000
+++ /dev/null Thu Jan 01 00:00:00 1970 +0000
@@ -1,78 +0,0 @@
-$NetBSD: patch-src_timezone_zic.c,v 1.1.1.1 2011/09/15 08:27:39 adam Exp $
-
---- src/timezone/zic.c.orig 2010-03-16 07:17:04.000000000 +0000
-+++ src/timezone/zic.c
-@@ -120,51 +120,51 @@ struct zone
-
- extern int link(const char *fromname, const char *toname);
- static void addtt(const pg_time_t starttime, int type);
--static int addtype(long gmtoff, const char *abbr, int isdst,
-- int ttisstd, int ttisgmt);
--static void leapadd(const pg_time_t t, int positive, int rolling, int count);
-+static int addtype(const long gmtoff, const char *abbr, const int isdst,
-+ const int ttisstd, const int ttisgmt);
-+static void leapadd(const pg_time_t t, const int positive, const int rolling, int count);
- static void adjleap(void);
- static void associate(void);
- static int ciequal(const char *ap, const char *bp);
--static void convert(long val, char *buf);
-+static void convert(const long val, char *buf);
- static void dolink(const char *fromfile, const char *tofile);
- static void doabbr(char *abbr, const char *format,
-- const char *letters, int isdst, int doquotes);
--static void eat(const char *name, int num);
--static void eats(const char *name, int num,
-- const char *rname, int rnum);
--static long eitol(int i);
-+ const char *letters, const int isdst, int doquotes);
-+static void eat(const char *name, const int num);
-+static void eats(const char *name, const int num,
-+ const char *rname, const int rnum);
-+static long eitol(const int i);
- static void error(const char *message);
- static char **getfields(char *buf);
- static long gethms(const char *string, const char *errstrng,
-- int signable);
-+ const int signable);
- static void infile(const char *filename);
--static void inleap(char **fields, int nfields);
--static void inlink(char **fields, int nfields);
--static void inrule(char **fields, int nfields);
--static int inzcont(char **fields, int nfields);
--static int inzone(char **fields, int nfields);
--static int inzsub(char **fields, int nfields, int iscont);
-+static void inleap(char **fields, const int nfields);
-+static void inlink(char **fields, const int nfields);
-+static void inrule(char **fields, const int nfields);
-+static int inzcont(char **fields, const int nfields);
-+static int inzone(char **fields, const int nfields);
-+static int inzsub(char **fields, const int nfields, const int iscont);
- static int itsabbr(const char *abbr, const char *word);
- static int itsdir(const char *name);
- static int lowerit(int c);
- static char *memcheck(char *tocheck);
- static int mkdirs(char *filename);
- static void newabbr(const char *abbr);
--static long oadd(long t1, long t2);
--static void outzone(const struct zone * zp, int ntzones);
--static void puttzcode(long code, FILE *fp);
-+static long oadd(const long t1, const long t2);
-+static void outzone(const struct zone * zp, const int ntzones);
-+static void puttzcode(const long code, FILE *fp);
- static int rcomp(const void *leftp, const void *rightp);
--static pg_time_t rpytime(const struct rule * rp, int wantedy);
-+static pg_time_t rpytime(const struct rule * rp, const int wantedy);
- static void rulesub(struct rule * rp,
- const char *loyearp, const char *hiyearp,
- const char *typep, const char *monthp,
- const char *dayp, const char *timep);
- static void setboundaries(void);
--static pg_time_t tadd(const pg_time_t t1, long t2);
-+static pg_time_t tadd(const pg_time_t t1, const long t2);
- static void usage(FILE *stream, int status);
- static void writezone(const char *name, const char *string);
--static int yearistype(int year, const char *type);
-+static int yearistype(const int year, const char *type);
-
- static int charcnt;
- static int errors;
diff -r b686a1281957 -r 9181a2e08ac1 databases/postgresql92-docs/Makefile
--- a/databases/postgresql92-docs/Makefile Tue Aug 23 05:10:48 2016 +0000
+++ b/databases/postgresql92-docs/Makefile Tue Aug 23 06:28:15 2016 +0000
@@ -1,7 +1,6 @@
-# $NetBSD: Makefile,v 1.10 2016/07/09 06:38:02 wiz Exp $
+# $NetBSD: Makefile,v 1.11 2016/08/23 06:28:15 adam Exp $
PKGNAME= ${DISTNAME:C/-/92-docs-/}
-PKGREVISION= 1
COMMENT= PostgreSQL database documentation
.include "../../databases/postgresql92/Makefile.common"
diff -r b686a1281957 -r 9181a2e08ac1 databases/postgresql92-docs/PLIST
--- a/databases/postgresql92-docs/PLIST Tue Aug 23 05:10:48 2016 +0000
+++ b/databases/postgresql92-docs/PLIST Tue Aug 23 06:28:15 2016 +0000
@@ -1,4 +1,4 @@
-@comment $NetBSD: PLIST,v 1.17 2016/05/23 14:27:34 adam Exp $
+@comment $NetBSD: PLIST,v 1.18 2016/08/23 06:28:15 adam Exp $
man/man1/clusterdb.1
man/man1/createdb.1
man/man1/createlang.1
@@ -1055,6 +1055,7 @@
share/doc/postgresql/html/release-9-1-2.html
share/doc/postgresql/html/release-9-1-21.html
share/doc/postgresql/html/release-9-1-22.html
+share/doc/postgresql/html/release-9-1-23.html
share/doc/postgresql/html/release-9-1-3.html
share/doc/postgresql/html/release-9-1-4.html
share/doc/postgresql/html/release-9-1-5.html
@@ -1072,6 +1073,7 @@
share/doc/postgresql/html/release-9-2-15.html
share/doc/postgresql/html/release-9-2-16.html
share/doc/postgresql/html/release-9-2-17.html
+share/doc/postgresql/html/release-9-2-18.html
share/doc/postgresql/html/release-9-2-2.html
share/doc/postgresql/html/release-9-2-3.html
share/doc/postgresql/html/release-9-2-4.html
diff -r b686a1281957 -r 9181a2e08ac1 databases/postgresql92-plperl/Makefile
--- a/databases/postgresql92-plperl/Makefile Tue Aug 23 05:10:48 2016 +0000
+++ b/databases/postgresql92-plperl/Makefile Tue Aug 23 06:28:15 2016 +0000
@@ -1,7 +1,6 @@
-# $NetBSD: Makefile,v 1.14 2016/07/09 06:38:02 wiz Exp $
+# $NetBSD: Makefile,v 1.15 2016/08/23 06:28:15 adam Exp $
PKGNAME= ${DISTNAME:C/-/92-plperl-/}
-PKGREVISION= 1
COMMENT= PL/Perl procedural language for the PostgreSQL backend
DEPENDS+= postgresql92-server>=${PKGVERSION_NOREV}:../../databases/postgresql92-server
diff -r b686a1281957 -r 9181a2e08ac1 databases/postgresql92/Makefile
Home |
Main Index |
Thread Index |
Old Index