pkgsrc-Changes-HG archive

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index][Old Index]

[pkgsrc/trunk]: pkgsrc postgresql12: added version 12.0



details:   https://anonhg.NetBSD.org/pkgsrc/rev/9b1c5b6bde49
branches:  trunk
changeset: 402342:9b1c5b6bde49
user:      adam <adam%pkgsrc.org@localhost>
date:      Mon Oct 07 19:21:48 2019 +0000

description:
postgresql12: added version 12.0

Release 12:

General performance improvements, including:
* Optimizations to space utilization and read/write performance for B-tree indexes
* Partitioning performance enhancements, including improved query performance on tables with thousands of partitions, improved insertion performance with INSERT and COPY, and the ability to execute 
ALTER TABLE ATTACH PARTITION without blocking queries
* Automatic (but overridable) inlining of common table expressions (CTEs)
* Reduction of WAL overhead for creation of GiST, GIN, and SP-GiST indexes
* Support for covering GiST indexes, via the INCLUDE clause
* Multi-column most-common-value (MCV) statistics can be defined via CREATE STATISTICS, to support better plans for queries that test several non-uniformly-distributed columns

Enhancements to administrative functionality, including:
* REINDEX CONCURRENTLY can rebuild an index without blocking writes to its table
* pg_checksums can enable/disable page checksums (used for detecting data corruption) in an offline cluster
* Progress reporting statistics for CREATE INDEX, REINDEX, CLUSTER, VACUUM FULL, and pg_checksums

Support for the SQL/JSON path language

Stored generated columns

Nondeterministic ICU collations, enabling case-insensitive and accent-insensitive grouping and ordering

New authentication features, including:
* Encryption of TCP/IP connections when using GSSAPI authentication
* Discovery of LDAP servers using DNS SRV records
* Multi-factor authentication, using the clientcert=verify-full option combined with an additional authentication method in pg_hba.conf

diffstat:

 databases/Makefile                                                  |    10 +-
 databases/postgresql12-client/DESCR                                 |     9 +
 databases/postgresql12-client/Makefile                              |    91 +
 databases/postgresql12-client/PLIST                                 |  1062 +++++++
 databases/postgresql12-client/buildlink3.mk                         |    21 +
 databases/postgresql12-contrib/DESCR                                |     4 +
 databases/postgresql12-contrib/Makefile                             |    78 +
 databases/postgresql12-contrib/PLIST                                |   410 ++
 databases/postgresql12-docs/DESCR                                   |     9 +
 databases/postgresql12-docs/Makefile                                |    21 +
 databases/postgresql12-docs/PLIST                                   |  1390 ++++++++++
 databases/postgresql12-plperl/DESCR                                 |     5 +
 databases/postgresql12-plperl/MESSAGE                               |     7 +
 databases/postgresql12-plperl/Makefile                              |    24 +
 databases/postgresql12-plperl/PLIST                                 |    26 +
 databases/postgresql12-plpython/DESCR                               |     9 +
 databases/postgresql12-plpython/MESSAGE                             |    17 +
 databases/postgresql12-plpython/Makefile                            |    18 +
 databases/postgresql12-plpython/PLIST                               |    51 +
 databases/postgresql12-pltcl/DESCR                                  |     4 +
 databases/postgresql12-pltcl/MESSAGE                                |     7 +
 databases/postgresql12-pltcl/Makefile                               |    20 +
 databases/postgresql12-pltcl/PLIST                                  |    22 +
 databases/postgresql12-server/DEINSTALL                             |    20 +
 databases/postgresql12-server/DESCR                                 |     9 +
 databases/postgresql12-server/Makefile                              |    77 +
 databases/postgresql12-server/PLIST                                 |  1358 +++++++++
 databases/postgresql12-server/files/pgsql.sh                        |   132 +
 databases/postgresql12-server/files/smf/manifest.xml                |    37 +
 databases/postgresql12-server/files/smf/postgresql.sh               |    57 +
 databases/postgresql12/DESCR                                        |     9 +
 databases/postgresql12/Makefile                                     |    14 +
 databases/postgresql12/Makefile.common                              |   119 +
 databases/postgresql12/PLIST                                        |     2 +
 databases/postgresql12/distinfo                                     |    17 +
 databases/postgresql12/options.mk                                   |    57 +
 databases/postgresql12/patches/patch-config_missing                 |    13 +
 databases/postgresql12/patches/patch-config_perl.m4                 |    15 +
 databases/postgresql12/patches/patch-configure                      |    34 +
 databases/postgresql12/patches/patch-contrib_dblink_dblink.c        |    13 +
 databases/postgresql12/patches/patch-src_Makefile.global.in         |    28 +
 databases/postgresql12/patches/patch-src_Makefile.shlib             |    74 +
 databases/postgresql12/patches/patch-src_backend_Makefile           |    24 +
 databases/postgresql12/patches/patch-src_interfaces_libpq_Makefile  |    13 +
 databases/postgresql12/patches/patch-src_makefiles_Makefile.solaris |    10 +
 databases/postgresql12/patches/patch-src_pl_plperl_GNUmakefile      |    21 +
 databases/postgresql12/patches/patch-src_pl_plperl_plperl.h         |    27 +
 mk/pgsql.buildlink3.mk                                              |    15 +-
 48 files changed, 5506 insertions(+), 4 deletions(-)

diffs (truncated from 5743 to 300 lines):

diff -r ee067e34684a -r 9b1c5b6bde49 databases/Makefile
--- a/databases/Makefile        Mon Oct 07 18:41:01 2019 +0000
+++ b/databases/Makefile        Mon Oct 07 19:21:48 2019 +0000
@@ -1,4 +1,4 @@
-# $NetBSD: Makefile,v 1.583 2019/07/07 09:30:52 bsiegert Exp $
+# $NetBSD: Makefile,v 1.584 2019/10/07 19:21:48 adam Exp $
 
 COMMENT=       Databases
 
@@ -304,6 +304,14 @@
 SUBDIR+=       postgresql11-plpython
 SUBDIR+=       postgresql11-pltcl
 SUBDIR+=       postgresql11-server
+SUBDIR+=       postgresql12
+SUBDIR+=       postgresql12-client
+SUBDIR+=       postgresql12-contrib
+SUBDIR+=       postgresql12-docs
+SUBDIR+=       postgresql12-plperl
+SUBDIR+=       postgresql12-plpython
+SUBDIR+=       postgresql12-pltcl
+SUBDIR+=       postgresql12-server
 SUBDIR+=       postgresql94
 SUBDIR+=       postgresql94-client
 SUBDIR+=       postgresql94-contrib
diff -r ee067e34684a -r 9b1c5b6bde49 databases/postgresql12-client/DESCR
--- /dev/null   Thu Jan 01 00:00:00 1970 +0000
+++ b/databases/postgresql12-client/DESCR       Mon Oct 07 19:21:48 2019 +0000
@@ -0,0 +1,9 @@
+PostgreSQL is a robust, next-generation, Object-Relational DBMS (ORDBMS),
+derived from the Berkeley Postgres database management system.  While
+PostgreSQL retains the powerful object-relational data model, rich data types
+and easy extensibility of Postgres, it replaces the PostQuel query language
+with an extended subset of SQL.
+
+PostgreSQL is free and the complete source is available.
+
+This package contains the database client programs.
diff -r ee067e34684a -r 9b1c5b6bde49 databases/postgresql12-client/Makefile
--- /dev/null   Thu Jan 01 00:00:00 1970 +0000
+++ b/databases/postgresql12-client/Makefile    Mon Oct 07 19:21:48 2019 +0000
@@ -0,0 +1,91 @@
+# $NetBSD: Makefile,v 1.1 2019/10/07 19:21:48 adam Exp $
+
+PKGNAME=       ${DISTNAME:C/-/12-client-/}
+COMMENT=       PostgreSQL database client programs
+
+.include "../../databases/postgresql12/Makefile.common"
+
+USE_TOOLS+=            gzip tar
+CONFIGURE_ARGS+=       --with-openssl
+CONFIGURE_ARGS+=       --with-zlib
+
+# Override INSTALL script to avoid unprivileged user/group
+# leaking into the binary package
+CONFIGURE_ARGS+=       INSTALL=${INSTALL:Q}\ -c
+
+.include "../../mk/bsd.prefs.mk"
+
+.if ${OPSYS} == "Cygwin"
+INSTALLATION_DIRS+=    bin
+.endif
+
+# 1. The thread-safety test in ${WRSRC}/src/tools/thread does not pass on
+# NetBSD earlier than 4.0 or DragonFly.
+# 2. configure with --enable-thread-safety fails on OpenBSD.
+.if (${OPSYS} == "NetBSD" && !empty(OS_VERSION:M[0-3].*)) || \
+    ${OPSYS} == "DragonFly" || ${OPSYS} == "OpenBSD" || ${OPSYS} == "MirBSD"
+PGSQL_THREAD_SAFETY?=  no
+.endif
+PGSQL_THREAD_SAFETY?=  yes
+BUILD_DEFS+=           PGSQL_THREAD_SAFETY
+
+.if !empty(PGSQL_THREAD_SAFETY:M[yY][eE][sS])
+.  include "../../mk/pthread.buildlink3.mk"
+.  if (${PTHREAD_TYPE} == "native")
+CONFIGURE_ARGS+=       --enable-thread-safety
+.  endif
+.else
+CONFIGURE_ARGS+=       --disable-thread-safety
+.endif
+
+INSTALL_DIRS=  src/include
+INSTALL_DIRS+= src/common
+INSTALL_DIRS+= src/port
+INSTALL_DIRS+= src/interfaces
+INSTALL_DIRS+= src/bin
+BUILD_DIRS=    ${INSTALL_DIRS}
+# Without this, the Darwin build fails (related to -bundle_loader).
+BUILD_DIRS+=   src/backend
+
+.for f in pg_service.conf psqlrc
+CONF_FILES+=   share/postgresql/${f}.sample ${PKG_SYSCONFDIR}/${f}
+.endfor
+
+.include "../../devel/zlib/buildlink3.mk"
+.include "../../security/openssl/buildlink3.mk"
+
+SUBST_CLASSES+=                pgxs
+SUBST_STAGE.pgxs=      post-build
+SUBST_MESSAGE.pgxs=    Fixing workdir tools references in pgxs Makefile
+SUBST_FILES.pgxs=      src/Makefile.global
+SUBST_SED.pgxs=                -e 's,${TOOLS_CMD.bison},${TOOLS_PATH.bison},'
+SUBST_SED.pgxs+=       -e 's,${TOOLS_CMD.lex},${TOOLS_PATH.lex},'
+SUBST_SED.pgxs+=       -e 's,${TOOLS_CMD.mkdir},${TOOLS_PATH.mkdir},'
+SUBST_SED.pgxs+=       -e 's,${WRKDIR}/.wrapper/bin/ld,${LD},'
+SUBST_SED.pgxs+=       -e 's,${WRKDIR}/.wrapper,${PREFIX},'
+SUBST_SED.pgxs+=       -e 's,${WRKSRC},/dev/null,'
+
+INSTALLATION_DIRS+=    lib/postgresql/pgxs
+INSTALLATION_DIRS+=    lib/postgresql/pgxs/config
+INSTALLATION_DIRS+=    lib/postgresql/pgxs/src
+INSTALLATION_DIRS+=    lib/postgresql/pgxs/src/makefiles
+
+DEST_PGXS=     ${DESTDIR}${PREFIX}/lib/postgresql/pgxs
+PGXS_FILES=    config/install-sh
+PGXS_FILES+=   src/makefiles/pgxs.mk src/Makefile.global
+PGXS_FILES+=   src/Makefile.port src/Makefile.shlib
+PGXS_FILES+=   src/nls-global.mk
+
+# On Solaris, avoid conflicts between "${SSLBASE}/include/openssl/des.h"
+# and "/usr/include/crypt.h" -- we want the definitions in the former.
+.if ${OPSYS} == "SunOS"
+post-wrapper:
+       touch ${BUILDLINK_DIR}/include/crypt.h
+.endif
+
+post-install:
+.for file in ${PGXS_FILES}
+       ${INSTALL_DATA} ${WRKSRC}/${file} ${DEST_PGXS}/${file}
+.endfor
+
+.include "../../mk/bsd.pkg.mk"
diff -r ee067e34684a -r 9b1c5b6bde49 databases/postgresql12-client/PLIST
--- /dev/null   Thu Jan 01 00:00:00 1970 +0000
+++ b/databases/postgresql12-client/PLIST       Mon Oct 07 19:21:48 2019 +0000
@@ -0,0 +1,1062 @@
+@comment $NetBSD: PLIST,v 1.1 2019/10/07 19:21:48 adam Exp $
+bin/clusterdb
+bin/createdb
+bin/createuser
+bin/dropdb
+bin/dropuser
+bin/ecpg
+bin/initdb
+bin/pg_archivecleanup
+bin/pg_basebackup
+bin/pg_checksums
+bin/pg_config
+bin/pg_controldata
+bin/pg_ctl
+bin/pg_dump
+bin/pg_dumpall
+bin/pg_isready
+bin/pg_receivewal
+bin/pg_recvlogical
+bin/pg_resetwal
+bin/pg_restore
+bin/pg_rewind
+bin/pg_test_fsync
+bin/pg_test_timing
+bin/pg_upgrade
+bin/pg_waldump
+bin/pgbench
+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.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/amapi.h
+include/postgresql/server/access/amvalidate.h
+include/postgresql/server/access/attnum.h
+include/postgresql/server/access/brin.h
+include/postgresql/server/access/brin_internal.h
+include/postgresql/server/access/brin_page.h
+include/postgresql/server/access/brin_pageops.h
+include/postgresql/server/access/brin_revmap.h
+include/postgresql/server/access/brin_tuple.h
+include/postgresql/server/access/brin_xlog.h
+include/postgresql/server/access/bufmask.h
+include/postgresql/server/access/clog.h
+include/postgresql/server/access/commit_ts.h
+include/postgresql/server/access/genam.h
+include/postgresql/server/access/generic_xlog.h
+include/postgresql/server/access/gin.h
+include/postgresql/server/access/gin_private.h
+include/postgresql/server/access/ginblock.h
+include/postgresql/server/access/ginxlog.h
+include/postgresql/server/access/gist.h
+include/postgresql/server/access/gist_private.h
+include/postgresql/server/access/gistscan.h
+include/postgresql/server/access/gistxlog.h
+include/postgresql/server/access/hash.h
+include/postgresql/server/access/hash_xlog.h
+include/postgresql/server/access/heapam.h
+include/postgresql/server/access/heapam_xlog.h
+include/postgresql/server/access/hio.h
+include/postgresql/server/access/htup.h
+include/postgresql/server/access/htup_details.h
+include/postgresql/server/access/itup.h
+include/postgresql/server/access/multixact.h
+include/postgresql/server/access/nbtree.h
+include/postgresql/server/access/nbtxlog.h
+include/postgresql/server/access/parallel.h
+include/postgresql/server/access/printsimple.h
+include/postgresql/server/access/printtup.h
+include/postgresql/server/access/relation.h
+include/postgresql/server/access/reloptions.h
+include/postgresql/server/access/relscan.h
+include/postgresql/server/access/rewriteheap.h
+include/postgresql/server/access/rmgr.h
+include/postgresql/server/access/rmgrlist.h
+include/postgresql/server/access/sdir.h
+include/postgresql/server/access/session.h
+include/postgresql/server/access/skey.h
+include/postgresql/server/access/slru.h
+include/postgresql/server/access/spgist.h
+include/postgresql/server/access/spgist_private.h
+include/postgresql/server/access/spgxlog.h
+include/postgresql/server/access/stratnum.h
+include/postgresql/server/access/subtrans.h
+include/postgresql/server/access/sysattr.h
+include/postgresql/server/access/table.h
+include/postgresql/server/access/tableam.h
+include/postgresql/server/access/timeline.h
+include/postgresql/server/access/transam.h
+include/postgresql/server/access/tsmapi.h
+include/postgresql/server/access/tupconvert.h
+include/postgresql/server/access/tupdesc.h
+include/postgresql/server/access/tupdesc_details.h
+include/postgresql/server/access/tupmacs.h
+include/postgresql/server/access/tuptoaster.h
+include/postgresql/server/access/twophase.h
+include/postgresql/server/access/twophase_rmgr.h
+include/postgresql/server/access/valid.h
+include/postgresql/server/access/visibilitymap.h
+include/postgresql/server/access/xact.h
+include/postgresql/server/access/xlog.h
+include/postgresql/server/access/xlog_internal.h
+include/postgresql/server/access/xlogdefs.h
+include/postgresql/server/access/xloginsert.h
+include/postgresql/server/access/xlogreader.h
+include/postgresql/server/access/xlogrecord.h
+include/postgresql/server/access/xlogutils.h
+include/postgresql/server/bootstrap/bootstrap.h
+include/postgresql/server/c.h
+include/postgresql/server/catalog/binary_upgrade.h
+include/postgresql/server/catalog/catalog.h
+include/postgresql/server/catalog/catversion.h
+include/postgresql/server/catalog/dependency.h
+include/postgresql/server/catalog/genbki.h
+include/postgresql/server/catalog/heap.h
+include/postgresql/server/catalog/index.h
+include/postgresql/server/catalog/indexing.h
+include/postgresql/server/catalog/namespace.h
+include/postgresql/server/catalog/objectaccess.h
+include/postgresql/server/catalog/objectaddress.h
+include/postgresql/server/catalog/opfam_internal.h
+include/postgresql/server/catalog/partition.h
+include/postgresql/server/catalog/pg_aggregate.h
+include/postgresql/server/catalog/pg_aggregate_d.h
+include/postgresql/server/catalog/pg_am.h
+include/postgresql/server/catalog/pg_am_d.h
+include/postgresql/server/catalog/pg_amop.h
+include/postgresql/server/catalog/pg_amop_d.h
+include/postgresql/server/catalog/pg_amproc.h
+include/postgresql/server/catalog/pg_amproc_d.h
+include/postgresql/server/catalog/pg_attrdef.h
+include/postgresql/server/catalog/pg_attrdef_d.h
+include/postgresql/server/catalog/pg_attribute.h
+include/postgresql/server/catalog/pg_attribute_d.h
+include/postgresql/server/catalog/pg_auth_members.h
+include/postgresql/server/catalog/pg_auth_members_d.h
+include/postgresql/server/catalog/pg_authid.h
+include/postgresql/server/catalog/pg_authid_d.h



Home | Main Index | Thread Index | Old Index