pkgsrc-Changes-HG archive

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

[pkgsrc/trunk]: pkgsrc/databases postgresql10: added version 10.0



details:   https://anonhg.NetBSD.org/pkgsrc/rev/30a8306f3203
branches:  trunk
changeset: 370773:30a8306f3203
user:      adam <adam%pkgsrc.org@localhost>
date:      Mon Oct 23 20:33:49 2017 +0000

description:
postgresql10: added version 10.0

Major enhancements in PostgreSQL 10 include:

Logical replication using publish/subscribe
Declarative table partitioning
Improved query parallelism
Significant general performance improvements
Stronger password authentication based on SCRAM-SHA-256
Improved monitoring and control
The above items are explained in more detail in the sections below.

diffstat:

 databases/Makefile                                                             |    10 +-
 databases/postgresql10-client/DESCR                                            |     9 +
 databases/postgresql10-client/Makefile                                         |    91 +
 databases/postgresql10-client/PLIST                                            |   942 +++++
 databases/postgresql10-client/buildlink3.mk                                    |    21 +
 databases/postgresql10-contrib/DESCR                                           |     4 +
 databases/postgresql10-contrib/Makefile                                        |    79 +
 databases/postgresql10-contrib/PLIST                                           |   233 +
 databases/postgresql10-docs/DESCR                                              |     9 +
 databases/postgresql10-docs/Makefile                                           |    21 +
 databases/postgresql10-docs/PLIST                                              |  1665 ++++++++++
 databases/postgresql10-plperl/DESCR                                            |     5 +
 databases/postgresql10-plperl/MESSAGE                                          |     7 +
 databases/postgresql10-plperl/Makefile                                         |    24 +
 databases/postgresql10-plperl/PLIST                                            |    23 +
 databases/postgresql10-plpython/DESCR                                          |     9 +
 databases/postgresql10-plpython/MESSAGE                                        |    17 +
 databases/postgresql10-plpython/Makefile                                       |    18 +
 databases/postgresql10-plpython/PLIST                                          |    33 +
 databases/postgresql10-pltcl/DESCR                                             |     4 +
 databases/postgresql10-pltcl/MESSAGE                                           |     7 +
 databases/postgresql10-pltcl/Makefile                                          |    20 +
 databases/postgresql10-pltcl/PLIST                                             |    16 +
 databases/postgresql10-server/DEINSTALL                                        |    20 +
 databases/postgresql10-server/DESCR                                            |     9 +
 databases/postgresql10-server/MESSAGE                                          |    18 +
 databases/postgresql10-server/Makefile                                         |    76 +
 databases/postgresql10-server/PLIST                                            |   701 ++++
 databases/postgresql10-server/files/pgsql.sh                                   |   130 +
 databases/postgresql10-server/files/smf/manifest.xml                           |    37 +
 databases/postgresql10-server/files/smf/postgresql.sh                          |    57 +
 databases/postgresql10/DESCR                                                   |     9 +
 databases/postgresql10/Makefile                                                |    14 +
 databases/postgresql10/Makefile.common                                         |   135 +
 databases/postgresql10/PLIST                                                   |     2 +
 databases/postgresql10/distinfo                                                |    19 +
 databases/postgresql10/files/GNUmakefile.libpq                                 |    20 +
 databases/postgresql10/files/dynloader-ltdl.h                                  |    17 +
 databases/postgresql10/options.mk                                              |    39 +
 databases/postgresql10/patches/patch-config_missing                            |    13 +
 databases/postgresql10/patches/patch-config_perl.m4                            |    15 +
 databases/postgresql10/patches/patch-configure                                 |    34 +
 databases/postgresql10/patches/patch-contrib_dblink_dblink.c                   |    13 +
 databases/postgresql10/patches/patch-src_Makefile.global.in                    |    28 +
 databases/postgresql10/patches/patch-src_Makefile.shlib                        |    61 +
 databases/postgresql10/patches/patch-src_backend_Makefile                      |    24 +
 databases/postgresql10/patches/patch-src_backend_utils_adt_datetime.c          |    14 +
 databases/postgresql10/patches/patch-src_interfaces_ecpg_pgtypeslib_interval.c |    15 +
 databases/postgresql10/patches/patch-src_interfaces_libpq_Makefile             |    13 +
 databases/postgresql10/patches/patch-src_makefiles_Makefile.solaris            |    10 +
 databases/postgresql10/patches/patch-src_pl_plperl_GNUmakefile                 |    21 +
 databases/postgresql10/patches/patch-src_pl_plperl_plperl.h                    |    27 +
 52 files changed, 4857 insertions(+), 1 deletions(-)

diffs (truncated from 5076 to 300 lines):

diff -r 4e998d910d23 -r 30a8306f3203 databases/Makefile
--- a/databases/Makefile        Mon Oct 23 15:49:37 2017 +0000
+++ b/databases/Makefile        Mon Oct 23 20:33:49 2017 +0000
@@ -1,4 +1,4 @@
-# $NetBSD: Makefile,v 1.548 2017/09/26 16:26:41 minskim Exp $
+# $NetBSD: Makefile,v 1.549 2017/10/23 20:33:49 adam Exp $
 
 COMMENT=       Databases
 
@@ -282,6 +282,14 @@
 SUBDIR+=       postgresql-pgbench
 SUBDIR+=       postgresql-pgroonga
 SUBDIR+=       postgresql-postgis2
+SUBDIR+=       postgresql10
+SUBDIR+=       postgresql10-client
+SUBDIR+=       postgresql10-contrib
+SUBDIR+=       postgresql10-docs
+SUBDIR+=       postgresql10-plperl
+SUBDIR+=       postgresql10-plpython
+SUBDIR+=       postgresql10-pltcl
+SUBDIR+=       postgresql10-server
 SUBDIR+=       postgresql92
 SUBDIR+=       postgresql92-client
 SUBDIR+=       postgresql92-contrib
diff -r 4e998d910d23 -r 30a8306f3203 databases/postgresql10-client/DESCR
--- /dev/null   Thu Jan 01 00:00:00 1970 +0000
+++ b/databases/postgresql10-client/DESCR       Mon Oct 23 20:33:49 2017 +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 4e998d910d23 -r 30a8306f3203 databases/postgresql10-client/Makefile
--- /dev/null   Thu Jan 01 00:00:00 1970 +0000
+++ b/databases/postgresql10-client/Makefile    Mon Oct 23 20:33:49 2017 +0000
@@ -0,0 +1,91 @@
+# $NetBSD: Makefile,v 1.1 2017/10/23 20:33:49 adam Exp $
+
+PKGNAME=       ${DISTNAME:C/-/10-client-/}
+COMMENT=       PostgreSQL database client programs
+
+.include "../../databases/postgresql10/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/interfaces
+INSTALL_DIRS+= src/bin
+INSTALL_DIRS+= src/port
+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 4e998d910d23 -r 30a8306f3203 databases/postgresql10-client/PLIST
--- /dev/null   Thu Jan 01 00:00:00 1970 +0000
+++ b/databases/postgresql10-client/PLIST       Mon Oct 23 20:33:49 2017 +0000
@@ -0,0 +1,942 @@
+@comment $NetBSD: PLIST,v 1.1 2017/10/23 20:33:49 adam Exp $
+bin/clusterdb
+bin/createdb
+bin/createuser
+bin/dropdb
+bin/dropuser
+bin/ecpg
+bin/initdb
+bin/pg_archivecleanup
+bin/pg_basebackup
+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_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/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/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/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/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_am.h
+include/postgresql/server/catalog/pg_amop.h
+include/postgresql/server/catalog/pg_amproc.h
+include/postgresql/server/catalog/pg_attrdef.h
+include/postgresql/server/catalog/pg_attribute.h
+include/postgresql/server/catalog/pg_auth_members.h
+include/postgresql/server/catalog/pg_authid.h
+include/postgresql/server/catalog/pg_cast.h
+include/postgresql/server/catalog/pg_class.h
+include/postgresql/server/catalog/pg_collation.h
+include/postgresql/server/catalog/pg_collation_fn.h
+include/postgresql/server/catalog/pg_constraint.h
+include/postgresql/server/catalog/pg_constraint_fn.h
+include/postgresql/server/catalog/pg_control.h
+include/postgresql/server/catalog/pg_conversion.h
+include/postgresql/server/catalog/pg_conversion_fn.h
+include/postgresql/server/catalog/pg_database.h
+include/postgresql/server/catalog/pg_db_role_setting.h
+include/postgresql/server/catalog/pg_default_acl.h
+include/postgresql/server/catalog/pg_depend.h
+include/postgresql/server/catalog/pg_description.h
+include/postgresql/server/catalog/pg_enum.h



Home | Main Index | Thread Index | Old Index