pkgsrc-Changes-HG archive
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index][Old Index]
[pkgsrc/trunk]: pkgsrc postgresql14: added version 14.0
details: https://anonhg.NetBSD.org/pkgsrc/rev/4d18e13eaac9
branches: trunk
changeset: 459500:4d18e13eaac9
user: adam <adam%pkgsrc.org@localhost>
date: Fri Oct 08 10:23:43 2021 +0000
description:
postgresql14: added version 14.0
PostgreSQL 14 contains many new features and enhancements, including:
Stored procedures can now return data via OUT parameters.
The SQL-standard SEARCH and CYCLE options for common table expressions have been implemented.
Subscripting can now be applied to any data type for which it is a useful notation, not only arrays. In this release, the jsonb and hstore types have gained subscripting operators.
Range types have been extended by adding multiranges, allowing representation of noncontiguous data ranges.
Numerous performance improvements have been made for parallel queries, heavily-concurrent workloads, partitioned tables, logical replication, and vacuuming.
B-tree index updates are managed more efficiently, reducing index bloat.
VACUUM automatically becomes more aggressive, and skips inessential cleanup, if the database starts to approach a transaction ID wraparound condition.
Extended statistics can now be collected on expressions, allowing better planning results for complex queries.
libpq now has the ability to pipeline multiple queries, which can boost throughput over high-latency connections.
diffstat:
databases/Makefile | 10 +-
databases/postgresql14-client/DESCR | 9 +
databases/postgresql14-client/Makefile | 93 +
databases/postgresql14-client/PLIST | 1162 ++++++++
databases/postgresql14-client/buildlink3.mk | 26 +
databases/postgresql14-contrib/DESCR | 4 +
databases/postgresql14-contrib/Makefile | 66 +
databases/postgresql14-contrib/PLIST | 397 ++
databases/postgresql14-docs/DESCR | 9 +
databases/postgresql14-docs/Makefile | 21 +
databases/postgresql14-docs/PLIST | 1431 ++++++++++
databases/postgresql14-plperl/DESCR | 5 +
databases/postgresql14-plperl/Makefile | 24 +
databases/postgresql14-plperl/PLIST | 25 +
databases/postgresql14-plpython/DESCR | 9 +
databases/postgresql14-plpython/Makefile | 19 +
databases/postgresql14-plpython/PLIST | 51 +
databases/postgresql14-pltcl/DESCR | 4 +
databases/postgresql14-pltcl/Makefile | 21 +
databases/postgresql14-pltcl/PLIST | 21 +
databases/postgresql14-server/DEINSTALL | 20 +
databases/postgresql14-server/DESCR | 9 +
databases/postgresql14-server/Makefile | 77 +
databases/postgresql14-server/PLIST | 1379 +++++++++
databases/postgresql14-server/files/pgsql.sh | 132 +
databases/postgresql14-server/files/smf/manifest.xml | 37 +
databases/postgresql14-server/files/smf/postgresql.sh | 57 +
databases/postgresql14/DESCR | 9 +
databases/postgresql14/Makefile | 14 +
databases/postgresql14/Makefile.common | 138 +
databases/postgresql14/PLIST | 2 +
databases/postgresql14/distinfo | 18 +
databases/postgresql14/options.mk | 71 +
databases/postgresql14/patches/patch-config_missing | 13 +
databases/postgresql14/patches/patch-config_perl.m4 | 15 +
databases/postgresql14/patches/patch-configure | 44 +
databases/postgresql14/patches/patch-contrib_dblink_dblink.c | 13 +
databases/postgresql14/patches/patch-contrib_uuid-ossp_Makefile | 15 +
databases/postgresql14/patches/patch-src_Makefile.global.in | 18 +
databases/postgresql14/patches/patch-src_Makefile.shlib | 64 +
databases/postgresql14/patches/patch-src_backend_Makefile | 25 +
databases/postgresql14/patches/patch-src_interfaces_libpq_Makefile | 13 +
databases/postgresql14/patches/patch-src_makefiles_Makefile.solaris | 10 +
databases/postgresql14/patches/patch-src_pl_plperl_GNUmakefile | 21 +
databases/postgresql14/patches/patch-src_pl_plperl_plperl.h | 27 +
mk/pgsql.buildlink3.mk | 15 +-
46 files changed, 5659 insertions(+), 4 deletions(-)
diffs (truncated from 5888 to 300 lines):
diff -r 9d0103305f44 -r 4d18e13eaac9 databases/Makefile
--- a/databases/Makefile Fri Oct 08 09:47:47 2021 +0000
+++ b/databases/Makefile Fri Oct 08 10:23:43 2021 +0000
@@ -1,4 +1,4 @@
-# $NetBSD: Makefile,v 1.640 2021/09/15 14:05:57 pin Exp $
+# $NetBSD: Makefile,v 1.641 2021/10/08 10:23:43 adam Exp $
COMMENT= Databases
@@ -331,6 +331,14 @@
SUBDIR+= postgresql13-plpython
SUBDIR+= postgresql13-pltcl
SUBDIR+= postgresql13-server
+SUBDIR+= postgresql14
+SUBDIR+= postgresql14-client
+SUBDIR+= postgresql14-contrib
+SUBDIR+= postgresql14-docs
+SUBDIR+= postgresql14-plperl
+SUBDIR+= postgresql14-plpython
+SUBDIR+= postgresql14-pltcl
+SUBDIR+= postgresql14-server
SUBDIR+= postgresql96
SUBDIR+= postgresql96-client
SUBDIR+= postgresql96-contrib
diff -r 9d0103305f44 -r 4d18e13eaac9 databases/postgresql14-client/DESCR
--- /dev/null Thu Jan 01 00:00:00 1970 +0000
+++ b/databases/postgresql14-client/DESCR Fri Oct 08 10:23:43 2021 +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 9d0103305f44 -r 4d18e13eaac9 databases/postgresql14-client/Makefile
--- /dev/null Thu Jan 01 00:00:00 1970 +0000
+++ b/databases/postgresql14-client/Makefile Fri Oct 08 10:23:43 2021 +0000
@@ -0,0 +1,93 @@
+# $NetBSD: Makefile,v 1.1 2021/10/08 10:23:43 adam Exp $
+
+PKGNAME= ${DISTNAME:S/-/14-client-/}
+COMMENT= PostgreSQL database client programs
+
+.include "../../databases/postgresql14/Makefile.common"
+
+USE_TOOLS+= gzip msgfmt tar
+TOOLS_BROKEN+= perl
+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
+
+BUILD_DIRS+= src/fe_utils
+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 9d0103305f44 -r 4d18e13eaac9 databases/postgresql14-client/PLIST
--- /dev/null Thu Jan 01 00:00:00 1970 +0000
+++ b/databases/postgresql14-client/PLIST Fri Oct 08 10:23:43 2021 +0000
@@ -0,0 +1,1162 @@
+@comment $NetBSD: PLIST,v 1.1 2021/10/08 10:23:43 adam Exp $
+bin/clusterdb
+bin/createdb
+bin/createuser
+bin/dropdb
+bin/dropuser
+bin/ecpg
+bin/initdb
+bin/pg_amcheck
+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_verifybackup
+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/attmap.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/detoast.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/heaptoast.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/syncscan.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/toast_compression.h
+include/postgresql/server/access/toast_helper.h
+include/postgresql/server/access/toast_internals.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/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/visibilitymapdefs.h
+include/postgresql/server/access/xact.h
+include/postgresql/server/access/xlog.h
+include/postgresql/server/access/xlog_internal.h
+include/postgresql/server/access/xlogarchive.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/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
Home |
Main Index |
Thread Index |
Old Index