pkgsrc-Changes-HG archive

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

[pkgsrc/trunk]: pkgsrc/databases postgresql15: added version 15.0



details:   https://anonhg.NetBSD.org/pkgsrc/rev/b3e993c6db07
branches:  trunk
changeset: 386993:b3e993c6db07
user:      adam <adam%pkgsrc.org@localhost>
date:      Wed Oct 19 13:16:45 2022 +0000

description:
postgresql15: added version 15.0

PostgreSQL 15 contains many new features and enhancements, including:

Support for the SQL MERGE command.

Selective publication of tables' contents within logical replication publications, through the ability to specify column lists and row filter conditions.

More options for compression, including support for Zstandard (zstd) compression. This includes support for performing compression on the server side during pg_basebackup.

Support for structured server log output using the JSON format.

Performance improvements, particularly for in-memory and on-disk sorting.

diffstat:

 databases/Makefile                                                  |    10 +-
 databases/postgresql15-client/DESCR                                 |     9 +
 databases/postgresql15-client/Makefile                              |    93 +
 databases/postgresql15-client/PLIST                                 |  1179 ++++++++
 databases/postgresql15-client/buildlink3.mk                         |    33 +
 databases/postgresql15-contrib/DESCR                                |     4 +
 databases/postgresql15-contrib/Makefile                             |    66 +
 databases/postgresql15-contrib/PLIST                                |   400 ++
 databases/postgresql15-docs/DESCR                                   |     9 +
 databases/postgresql15-docs/Makefile                                |    21 +
 databases/postgresql15-docs/PLIST                                   |  1449 ++++++++++
 databases/postgresql15-plperl/DESCR                                 |     5 +
 databases/postgresql15-plperl/Makefile                              |    24 +
 databases/postgresql15-plperl/PLIST                                 |    26 +
 databases/postgresql15-plpython/DESCR                               |     9 +
 databases/postgresql15-plpython/Makefile                            |    19 +
 databases/postgresql15-plpython/PLIST                               |    47 +
 databases/postgresql15-pltcl/DESCR                                  |     4 +
 databases/postgresql15-pltcl/Makefile                               |    21 +
 databases/postgresql15-pltcl/PLIST                                  |    23 +
 databases/postgresql15-server/DEINSTALL                             |    20 +
 databases/postgresql15-server/DESCR                                 |     9 +
 databases/postgresql15-server/Makefile                              |    77 +
 databases/postgresql15-server/PLIST                                 |  1401 +++++++++
 databases/postgresql15-server/files/pgsql.sh                        |   129 +
 databases/postgresql15-server/files/smf/manifest.xml                |    37 +
 databases/postgresql15-server/files/smf/postgresql.sh               |    57 +
 databases/postgresql15/DESCR                                        |     9 +
 databases/postgresql15/Makefile                                     |    14 +
 databases/postgresql15/Makefile.common                              |   144 +
 databases/postgresql15/PLIST                                        |     2 +
 databases/postgresql15/distinfo                                     |    16 +
 databases/postgresql15/options.mk                                   |    80 +
 databases/postgresql15/patches/patch-config_missing                 |    13 +
 databases/postgresql15/patches/patch-config_perl.m4                 |    15 +
 databases/postgresql15/patches/patch-configure                      |    44 +
 databases/postgresql15/patches/patch-contrib_dblink_dblink.c        |    13 +
 databases/postgresql15/patches/patch-src_Makefile.global.in         |    18 +
 databases/postgresql15/patches/patch-src_Makefile.shlib             |    64 +
 databases/postgresql15/patches/patch-src_backend_Makefile           |    25 +
 databases/postgresql15/patches/patch-src_interfaces_libpq_Makefile  |    13 +
 databases/postgresql15/patches/patch-src_makefiles_Makefile.solaris |    10 +
 databases/postgresql15/patches/patch-src_pl_plperl_GNUmakefile      |    21 +
 databases/postgresql15/patches/patch-src_pl_plperl_plperl.h         |    27 +
 44 files changed, 5708 insertions(+), 1 deletions(-)

diffs (truncated from 5895 to 300 lines):

diff -r 69f42f26bc34 -r b3e993c6db07 databases/Makefile
--- a/databases/Makefile        Wed Oct 19 13:15:36 2022 +0000
+++ b/databases/Makefile        Wed Oct 19 13:16:45 2022 +0000
@@ -1,4 +1,4 @@
-# $NetBSD: Makefile,v 1.666 2022/09/11 17:58:46 wiz Exp $
+# $NetBSD: Makefile,v 1.667 2022/10/19 13:16:45 adam Exp $
 
 COMMENT=       Databases
 
@@ -345,6 +345,14 @@
 SUBDIR+=       postgresql14-plpython
 SUBDIR+=       postgresql14-pltcl
 SUBDIR+=       postgresql14-server
+SUBDIR+=       postgresql15
+SUBDIR+=       postgresql15-client
+SUBDIR+=       postgresql15-contrib
+SUBDIR+=       postgresql15-docs
+SUBDIR+=       postgresql15-plperl
+SUBDIR+=       postgresql15-plpython
+SUBDIR+=       postgresql15-pltcl
+SUBDIR+=       postgresql15-server
 SUBDIR+=       prometheus
 SUBDIR+=       promscale
 SUBDIR+=       pxtools
diff -r 69f42f26bc34 -r b3e993c6db07 databases/postgresql15-client/DESCR
--- /dev/null   Thu Jan 01 00:00:00 1970 +0000
+++ b/databases/postgresql15-client/DESCR       Wed Oct 19 13:16:45 2022 +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 69f42f26bc34 -r b3e993c6db07 databases/postgresql15-client/Makefile
--- /dev/null   Thu Jan 01 00:00:00 1970 +0000
+++ b/databases/postgresql15-client/Makefile    Wed Oct 19 13:16:45 2022 +0000
@@ -0,0 +1,93 @@
+# $NetBSD: Makefile,v 1.1 2022/10/19 13:16:45 adam Exp $
+
+PKGNAME=       ${DISTNAME:S/-/15-client-/}
+COMMENT=       PostgreSQL database client programs
+
+.include "../../databases/postgresql15/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" && ${OPSYS_VERSION} < 040000) || \
+    ${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 69f42f26bc34 -r b3e993c6db07 databases/postgresql15-client/PLIST
--- /dev/null   Thu Jan 01 00:00:00 1970 +0000
+++ b/databases/postgresql15-client/PLIST       Wed Oct 19 13:16:45 2022 +0000
@@ -0,0 +1,1179 @@
+@comment $NetBSD: PLIST,v 1.1 2022/10/19 13:16:45 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/fe-auth-sasl.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/xlogprefetcher.h
+include/postgresql/server/access/xlogreader.h
+include/postgresql/server/access/xlogrecord.h
+include/postgresql/server/access/xlogrecovery.h
+include/postgresql/server/access/xlogstats.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



Home | Main Index | Thread Index | Old Index