pkgsrc-Changes-HG archive

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

[pkgsrc/trunk]: pkgsrc postgresql13: added version 13.0



details:   https://anonhg.NetBSD.org/pkgsrc/rev/604b6679f07c
branches:  trunk
changeset: 440764:604b6679f07c
user:      adam <adam%pkgsrc.org@localhost>
date:      Sun Oct 18 09:24:02 2020 +0000

description:
postgresql13: added version 13.0

PostgreSQL 13 contains many new features and enhancements, including:
* Space savings and performance gains from de-duplication of B-tree index entries
* Improved performance for queries that use aggregates or partitioned tables
* Better query planning when using extended statistics
* Parallelized vacuuming of indexes
* Incremental sorting

diffstat:

 databases/Makefile                                                  |    10 +-
 databases/postgresql13-client/DESCR                                 |     9 +
 databases/postgresql13-client/Makefile                              |    92 +
 databases/postgresql13-client/PLIST                                 |  1109 +++++++
 databases/postgresql13-client/buildlink3.mk                         |    21 +
 databases/postgresql13-contrib/DESCR                                |     4 +
 databases/postgresql13-contrib/Makefile                             |    79 +
 databases/postgresql13-contrib/PLIST                                |   386 ++
 databases/postgresql13-docs/DESCR                                   |     9 +
 databases/postgresql13-docs/Makefile                                |    21 +
 databases/postgresql13-docs/PLIST                                   |  1400 ++++++++++
 databases/postgresql13-plperl/DESCR                                 |     5 +
 databases/postgresql13-plperl/MESSAGE                               |     7 +
 databases/postgresql13-plperl/Makefile                              |    24 +
 databases/postgresql13-plperl/PLIST                                 |    25 +
 databases/postgresql13-plpython/DESCR                               |     9 +
 databases/postgresql13-plpython/MESSAGE                             |    17 +
 databases/postgresql13-plpython/Makefile                            |    19 +
 databases/postgresql13-plpython/PLIST                               |    50 +
 databases/postgresql13-pltcl/DESCR                                  |     4 +
 databases/postgresql13-pltcl/MESSAGE                                |     7 +
 databases/postgresql13-pltcl/Makefile                               |    21 +
 databases/postgresql13-pltcl/PLIST                                  |    20 +
 databases/postgresql13-server/DEINSTALL                             |    20 +
 databases/postgresql13-server/DESCR                                 |     9 +
 databases/postgresql13-server/Makefile                              |    77 +
 databases/postgresql13-server/PLIST                                 |  1370 +++++++++
 databases/postgresql13-server/files/pgsql.sh                        |   132 +
 databases/postgresql13-server/files/smf/manifest.xml                |    37 +
 databases/postgresql13-server/files/smf/postgresql.sh               |    57 +
 databases/postgresql13/DESCR                                        |     9 +
 databases/postgresql13/Makefile                                     |    14 +
 databases/postgresql13/Makefile.common                              |   117 +
 databases/postgresql13/PLIST                                        |     2 +
 databases/postgresql13/distinfo                                     |    17 +
 databases/postgresql13/options.mk                                   |    70 +
 databases/postgresql13/patches/patch-config_missing                 |    13 +
 databases/postgresql13/patches/patch-config_perl.m4                 |    15 +
 databases/postgresql13/patches/patch-configure                      |    34 +
 databases/postgresql13/patches/patch-contrib_dblink_dblink.c        |    13 +
 databases/postgresql13/patches/patch-src_Makefile.global.in         |    18 +
 databases/postgresql13/patches/patch-src_Makefile.shlib             |    64 +
 databases/postgresql13/patches/patch-src_backend_Makefile           |    24 +
 databases/postgresql13/patches/patch-src_interfaces_libpq_Makefile  |    13 +
 databases/postgresql13/patches/patch-src_makefiles_Makefile.solaris |    10 +
 databases/postgresql13/patches/patch-src_pl_plperl_GNUmakefile      |    21 +
 databases/postgresql13/patches/patch-src_pl_plperl_plperl.h         |    27 +
 mk/pgsql.buildlink3.mk                                              |    15 +-
 48 files changed, 5542 insertions(+), 4 deletions(-)

diffs (truncated from 5779 to 300 lines):

diff -r c8e315f61cb6 -r 604b6679f07c databases/Makefile
--- a/databases/Makefile        Sun Oct 18 08:28:20 2020 +0000
+++ b/databases/Makefile        Sun Oct 18 09:24:02 2020 +0000
@@ -1,4 +1,4 @@
-# $NetBSD: Makefile,v 1.616 2020/10/09 08:28:46 otis Exp $
+# $NetBSD: Makefile,v 1.617 2020/10/18 09:24:02 adam Exp $
 
 COMMENT=       Databases
 
@@ -318,6 +318,14 @@
 SUBDIR+=       postgresql12-plpython
 SUBDIR+=       postgresql12-pltcl
 SUBDIR+=       postgresql12-server
+SUBDIR+=       postgresql13
+SUBDIR+=       postgresql13-client
+SUBDIR+=       postgresql13-contrib
+SUBDIR+=       postgresql13-docs
+SUBDIR+=       postgresql13-plperl
+SUBDIR+=       postgresql13-plpython
+SUBDIR+=       postgresql13-pltcl
+SUBDIR+=       postgresql13-server
 SUBDIR+=       postgresql95
 SUBDIR+=       postgresql95-client
 SUBDIR+=       postgresql95-contrib
diff -r c8e315f61cb6 -r 604b6679f07c databases/postgresql13-client/DESCR
--- /dev/null   Thu Jan 01 00:00:00 1970 +0000
+++ b/databases/postgresql13-client/DESCR       Sun Oct 18 09:24:02 2020 +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 c8e315f61cb6 -r 604b6679f07c databases/postgresql13-client/Makefile
--- /dev/null   Thu Jan 01 00:00:00 1970 +0000
+++ b/databases/postgresql13-client/Makefile    Sun Oct 18 09:24:02 2020 +0000
@@ -0,0 +1,92 @@
+# $NetBSD: Makefile,v 1.1 2020/10/18 09:24:02 adam Exp $
+
+PKGNAME=       ${DISTNAME:S/-/13-client-/}
+COMMENT=       PostgreSQL database client programs
+
+.include "../../databases/postgresql13/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
+
+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 c8e315f61cb6 -r 604b6679f07c databases/postgresql13-client/PLIST
--- /dev/null   Thu Jan 01 00:00:00 1970 +0000
+++ b/databases/postgresql13-client/PLIST       Sun Oct 18 09:24:02 2020 +0000
@@ -0,0 +1,1109 @@
+@comment $NetBSD: PLIST,v 1.1 2020/10/18 09:24:02 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_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/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_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/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/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



Home | Main Index | Thread Index | Old Index