For those of you want to get a head start at testing your apps/libraries
with 9.3, or want to try out all of the awesome new features in 9.3 (see
http://www.postgresql.org/about/news/1463/), here you go.
Note that this diff also enables plpython support, which hopefully
can be committed at the same time. That part hasn't changed since the
diff I sent out at p2k12.
No problems in my testing on i386, packages fine on amd64. Obviously no
plans to commit this.
Thanks,
Jeremy
Index: Makefile
===================================================================
RCS file: /cvs/ports/databases/postgresql/Makefile,v
retrieving revision 1.173
diff -u -p -r1.173 Makefile
--- Makefile 4 Apr 2013 14:45:46 -0000 1.173
+++ Makefile 16 May 2013 22:09:37 -0000
@@ -4,19 +4,21 @@ COMMENT-main= PostgreSQL RDBMS (client)
COMMENT-server= PostgreSQL RDBMS (server)
COMMENT-docs= PostgreSQL RDBMS documentation
COMMENT-contrib=PostgreSQL RDBMS contributions
+COMMENT-plpython=Python procedural language for PostgreSQL
-VERSION= 9.2.4
+VERSION= 9.3beta1
DISTNAME= postgresql-${VERSION}
PKGNAME-main= postgresql-client-${VERSION}
PKGNAME-server= postgresql-server-${VERSION}
PKGNAME-docs= postgresql-docs-${VERSION}
PKGNAME-contrib=postgresql-contrib-${VERSION}
+PKGNAME-plpython=postgresql-plpython-${VERSION}
CATEGORIES= databases
-SHARED_LIBS= ecpg 7.4 \
- ecpg_compat 4.4 \
- pgtypes 4.3 \
- pq 5.5
+SHARED_LIBS= ecpg 7.5 \
+ ecpg_compat 4.5 \
+ pgtypes 4.4 \
+ pq 5.6
HOMEPAGE= http://www.postgresql.org/
@@ -31,7 +33,7 @@ MASTER_SITES= http://ftp.postgresql.org/
ftp://ftp.postgresql.org/pub/source/v${VERSION}/ \
ftp://ftp5.us.postgresql.org/pub/PostgreSQL/source/v${VERSION}/
-MULTI_PACKAGES= -docs -main -server -contrib
+MULTI_PACKAGES= -docs -main -server -contrib -plpython
# The -client SUBPACKAGE should build and run fine on static arches,
# but the server requires loadable library support. Until we figure
@@ -47,9 +49,14 @@ USE_GMAKE= Yes
USE_GROFF = Yes
CONFIGURE_STYLE=gnu
+MODULES= lang/python
+MODPY_RUNDEP= No
+
INCLUDES= ${LOCALBASE}/include /usr/include/kerberosV
+CONFIGURE_ENV= ac_cv_path_PYTHON=${MODPY_BIN}
CONFIGURE_ARGS= --disable-rpath --with-openssl=/usr \
--with-perl \
+ --with-python \
--enable-integer-datetimes \
--includedir="${PREFIX}/include/postgresql" \
--datadir="${PREFIX}/share/postgresql" \
@@ -90,6 +97,10 @@ LIB_DEPENDS-contrib= databases/postgresq
devel/uuid
WANTLIB-contrib = ${WANTLIB-main} pq>=4 uuid
+LIB_DEPENDS-plpython= ${MODPY_LIB_DEPENDS}
+WANTLIB-plpython = c m pthread util ${MODPY_WANTLIB}
+RUN_DEPENDS-plpython= databases/postgresql,-server=${VERSION}
+
WANTLIB-docs=
PKG_ARCH-docs= *
@@ -118,6 +129,11 @@ NO_TEST= Yes
DOCS= ${WRKSRC}/COPYRIGHT ${WRKSRC}/HISTORY \
${WRKSRC}/INSTALL ${WRKSRC}/README \
${WRKSRC}/doc/TODO
+
+# Work around Makefile issue where it attempts to rebuild
+# the documentation even if it is not necessary.
+pre-build:
+ touch ${WRKSRC}/doc/src/sgml/*-stamp
post-install:
${INSTALL_DATA_DIR} ${PREFIX}/share/doc/postgresql
Index: distinfo
===================================================================
RCS file: /cvs/ports/databases/postgresql/distinfo,v
retrieving revision 1.48
diff -u -p -r1.48 distinfo
--- distinfo 4 Apr 2013 14:45:46 -0000 1.48
+++ distinfo 16 May 2013 22:07:56 -0000
@@ -1,2 +1,2 @@
-SHA256 (postgresql-9.2.4.tar.gz) = 8IQO3Px3gMRAeXQJIc+bUbN64oNVgO30eOjwOEEWai8=
-SIZE (postgresql-9.2.4.tar.gz) = 21539369
+SHA256 (postgresql-9.3beta1.tar.gz) =
bpJERKLppSNXW536s0yWkI18UqBkLF4jYl3TavEnfxU=
+SIZE (postgresql-9.3beta1.tar.gz) = 22346836
Index: patches/patch-configure
===================================================================
RCS file: patches/patch-configure
diff -N patches/patch-configure
--- /dev/null 1 Jan 1970 00:00:00 -0000
+++ patches/patch-configure 16 May 2013 22:17:14 -0000
@@ -0,0 +1,21 @@
+$OpenBSD$
+
+Remove configure check, since the pl/python does work if you
+LD_PRELOAD libpthread when starting PostgreSQL.
+
+--- configure.orig Mon May 6 13:57:06 2013
++++ configure Thu May 16 15:08:07 2013
+@@ -7622,13 +7622,6 @@ pythreads=`${PYTHON} -c "import sys; print(int('thread
+ if test "$pythreads" = "1"; then
+ { $as_echo "$as_me:$LINENO: result: yes" >&5
+ $as_echo "yes" >&6; }
+- case $host_os in
+- openbsd*)
+- { { $as_echo "$as_me:$LINENO: error: threaded Python not supported on
this platform" >&5
+-$as_echo "$as_me: error: threaded Python not supported on this platform" >&2;}
+- { (exit 1); exit 1; }; }
+- ;;
+- esac
+ else
+ { $as_echo "$as_me:$LINENO: result: no" >&5
+ $as_echo "no" >&6; }
Index: patches/patch-src_Makefile_shlib
===================================================================
RCS file: /cvs/ports/databases/postgresql/patches/patch-src_Makefile_shlib,v
retrieving revision 1.8
diff -u -p -r1.8 patch-src_Makefile_shlib
--- patches/patch-src_Makefile_shlib 24 Sep 2012 19:57:02 -0000 1.8
+++ patches/patch-src_Makefile_shlib 16 May 2013 22:17:14 -0000
@@ -1,7 +1,7 @@
$OpenBSD: patch-src_Makefile_shlib,v 1.8 2012/09/24 19:57:02 pea Exp $
---- src/Makefile.shlib.orig Fri May 11 00:35:09 2012
-+++ src/Makefile.shlib Tue May 15 10:23:01 2012
-@@ -149,7 +149,7 @@ ifeq ($(PORTNAME), openbsd)
+--- src/Makefile.shlib.orig Mon May 6 13:57:06 2013
++++ src/Makefile.shlib Thu May 16 15:08:07 2013
+@@ -146,7 +146,7 @@ ifeq ($(PORTNAME), openbsd)
ifdef ELF_SYSTEM
LINK.shared = $(COMPILER) -shared
ifdef soname
Index: patches/patch-src_interfaces_ecpg_compatlib_Makefile
===================================================================
RCS file:
/cvs/ports/databases/postgresql/patches/patch-src_interfaces_ecpg_compatlib_Makefile,v
retrieving revision 1.7
diff -u -p -r1.7 patch-src_interfaces_ecpg_compatlib_Makefile
--- patches/patch-src_interfaces_ecpg_compatlib_Makefile 24 Sep 2012
19:57:02 -0000 1.7
+++ patches/patch-src_interfaces_ecpg_compatlib_Makefile 16 May 2013
22:17:14 -0000
@@ -1,12 +1,12 @@
$OpenBSD: patch-src_interfaces_ecpg_compatlib_Makefile,v 1.7 2012/09/24
19:57:02 pea Exp $
---- src/interfaces/ecpg/compatlib/Makefile.orig Fri May 11 00:35:09 2012
-+++ src/interfaces/ecpg/compatlib/Makefile Tue May 15 10:24:33 2012
+--- src/interfaces/ecpg/compatlib/Makefile.orig Mon May 6 13:57:06 2013
++++ src/interfaces/ecpg/compatlib/Makefile Thu May 16 15:15:48 2013
@@ -14,8 +14,8 @@ top_builddir = ../../../..
include $(top_builddir)/src/Makefile.global
NAME= ecpg_compat
-SO_MAJOR_VERSION= 3
--SO_MINOR_VERSION= 4
+-SO_MINOR_VERSION= 5
+SO_MAJOR_VERSION= ${LIBecpg_compat_MAJOR}
+SO_MINOR_VERSION= ${LIBecpg_compat_MINOR}
Index: patches/patch-src_interfaces_ecpg_ecpglib_Makefile
===================================================================
RCS file:
/cvs/ports/databases/postgresql/patches/patch-src_interfaces_ecpg_ecpglib_Makefile,v
retrieving revision 1.7
diff -u -p -r1.7 patch-src_interfaces_ecpg_ecpglib_Makefile
--- patches/patch-src_interfaces_ecpg_ecpglib_Makefile 24 Sep 2012 19:57:02
-0000 1.7
+++ patches/patch-src_interfaces_ecpg_ecpglib_Makefile 16 May 2013 22:17:14
-0000
@@ -1,12 +1,12 @@
$OpenBSD: patch-src_interfaces_ecpg_ecpglib_Makefile,v 1.7 2012/09/24 19:57:02
pea Exp $
---- src/interfaces/ecpg/ecpglib/Makefile.orig Fri May 11 00:35:09 2012
-+++ src/interfaces/ecpg/ecpglib/Makefile Tue May 15 10:25:56 2012
+--- src/interfaces/ecpg/ecpglib/Makefile.orig Mon May 6 13:57:06 2013
++++ src/interfaces/ecpg/ecpglib/Makefile Thu May 16 15:16:21 2013
@@ -14,8 +14,8 @@ top_builddir = ../../../..
include $(top_builddir)/src/Makefile.global
NAME= ecpg
-SO_MAJOR_VERSION= 6
--SO_MINOR_VERSION= 4
+-SO_MINOR_VERSION= 5
+SO_MAJOR_VERSION= ${LIBecpg_MAJOR}
+SO_MINOR_VERSION= ${LIBecpg_MINOR}
Index: patches/patch-src_interfaces_ecpg_pgtypeslib_Makefile
===================================================================
RCS file:
/cvs/ports/databases/postgresql/patches/patch-src_interfaces_ecpg_pgtypeslib_Makefile,v
retrieving revision 1.7
diff -u -p -r1.7 patch-src_interfaces_ecpg_pgtypeslib_Makefile
--- patches/patch-src_interfaces_ecpg_pgtypeslib_Makefile 24 Sep 2012
19:57:02 -0000 1.7
+++ patches/patch-src_interfaces_ecpg_pgtypeslib_Makefile 16 May 2013
22:17:14 -0000
@@ -1,14 +1,15 @@
$OpenBSD: patch-src_interfaces_ecpg_pgtypeslib_Makefile,v 1.7 2012/09/24
19:57:02 pea Exp $
---- src/interfaces/ecpg/pgtypeslib/Makefile.orig Fri May 11 00:35:09 2012
-+++ src/interfaces/ecpg/pgtypeslib/Makefile Tue May 15 10:26:32 2012
-@@ -14,8 +14,8 @@ top_builddir = ../../../..
+--- src/interfaces/ecpg/pgtypeslib/Makefile.orig Mon May 6 13:57:06 2013
++++ src/interfaces/ecpg/pgtypeslib/Makefile Thu May 16 15:17:02 2013
+@@ -14,8 +14,9 @@ top_builddir = ../../../..
include $(top_builddir)/src/Makefile.global
NAME= pgtypes
-SO_MAJOR_VERSION= 3
--SO_MINOR_VERSION= 3
+-SO_MINOR_VERSION= 4
+SO_MAJOR_VERSION= ${LIBpgtypes_MAJOR}
+SO_MINOR_VERSION= ${LIBpgtypes_MINOR}
++
override CPPFLAGS := -I../include -I$(top_srcdir)/src/interfaces/ecpg/include
\
-I$(top_srcdir)/src/include/utils -I$(libpq_srcdir) $(CPPFLAGS)
Index: patches/patch-src_interfaces_libpq_Makefile
===================================================================
RCS file:
/cvs/ports/databases/postgresql/patches/patch-src_interfaces_libpq_Makefile,v
retrieving revision 1.9
diff -u -p -r1.9 patch-src_interfaces_libpq_Makefile
--- patches/patch-src_interfaces_libpq_Makefile 24 Sep 2012 19:57:02 -0000
1.9
+++ patches/patch-src_interfaces_libpq_Makefile 16 May 2013 22:17:14 -0000
@@ -1,12 +1,12 @@
$OpenBSD: patch-src_interfaces_libpq_Makefile,v 1.9 2012/09/24 19:57:02 pea
Exp $
---- src/interfaces/libpq/Makefile.orig Fri May 11 00:35:09 2012
-+++ src/interfaces/libpq/Makefile Tue May 15 10:27:11 2012
+--- src/interfaces/libpq/Makefile.orig Mon May 6 13:57:06 2013
++++ src/interfaces/libpq/Makefile Thu May 16 15:10:02 2013
@@ -16,8 +16,8 @@ include $(top_builddir)/src/Makefile.global
# shared library parameters
NAME= pq
-SO_MAJOR_VERSION= 5
--SO_MINOR_VERSION= 5
+-SO_MINOR_VERSION= 6
+SO_MAJOR_VERSION= ${LIBpq_MAJOR}
+SO_MINOR_VERSION= ${LIBpq_MINOR}
Index: pkg/DESCR-plpython
===================================================================
RCS file: pkg/DESCR-plpython
diff -N pkg/DESCR-plpython
--- /dev/null 1 Jan 1970 00:00:00 -0000
+++ pkg/DESCR-plpython 9 Oct 2012 17:47:01 -0000
@@ -0,0 +1,2 @@
+The PL/Python procedural language allows PostgreSQL functions to be
+written in the Python language.
Index: pkg/PLIST-contrib
===================================================================
RCS file: /cvs/ports/databases/postgresql/pkg/PLIST-contrib,v
retrieving revision 1.9
diff -u -p -r1.9 PLIST-contrib
--- pkg/PLIST-contrib 24 Sep 2012 19:57:02 -0000 1.9
+++ pkg/PLIST-contrib 16 May 2013 22:46:57 -0000
@@ -40,6 +40,7 @@ lib/postgresql/pgcrypto.so
lib/postgresql/pgrowlocks.so
lib/postgresql/pgstattuple.so
lib/postgresql/pgxml.so
+lib/postgresql/postgres_fdw.so
lib/postgresql/refint.so
lib/postgresql/seg.so
lib/postgresql/sslinfo.so
@@ -48,6 +49,7 @@ lib/postgresql/tcn.so
lib/postgresql/timetravel.so
lib/postgresql/tsearch2.so
lib/postgresql/uuid-ossp.so
+lib/postgresql/worker_spi.so
@man man/man1/oid2name.1
@man man/man1/pg_archivecleanup.1
@man man/man1/pg_standby.1
@@ -76,7 +78,8 @@ share/postgresql/extension/citext.contro
share/postgresql/extension/cube--1.0.sql
share/postgresql/extension/cube--unpackaged--1.0.sql
share/postgresql/extension/cube.control
-share/postgresql/extension/dblink--1.0.sql
+share/postgresql/extension/dblink--1.0--1.1.sql
+share/postgresql/extension/dblink--1.1.sql
share/postgresql/extension/dblink--unpackaged--1.0.sql
share/postgresql/extension/dblink.control
share/postgresql/extension/dict_int--1.0.sql
@@ -118,7 +121,9 @@ share/postgresql/extension/ltree.control
share/postgresql/extension/moddatetime--1.0.sql
share/postgresql/extension/moddatetime--unpackaged--1.0.sql
share/postgresql/extension/moddatetime.control
+share/postgresql/extension/pageinspect--1.0--1.1.sql
share/postgresql/extension/pageinspect--1.0.sql
+share/postgresql/extension/pageinspect--1.1.sql
share/postgresql/extension/pageinspect--unpackaged--1.0.sql
share/postgresql/extension/pageinspect.control
share/postgresql/extension/pg_buffercache--1.0.sql
@@ -131,18 +136,23 @@ share/postgresql/extension/pg_stat_state
share/postgresql/extension/pg_stat_statements--1.1.sql
share/postgresql/extension/pg_stat_statements--unpackaged--1.0.sql
share/postgresql/extension/pg_stat_statements.control
-share/postgresql/extension/pg_trgm--1.0.sql
+share/postgresql/extension/pg_trgm--1.0--1.1.sql
+share/postgresql/extension/pg_trgm--1.1.sql
share/postgresql/extension/pg_trgm--unpackaged--1.0.sql
share/postgresql/extension/pg_trgm.control
share/postgresql/extension/pgcrypto--1.0.sql
share/postgresql/extension/pgcrypto--unpackaged--1.0.sql
share/postgresql/extension/pgcrypto.control
-share/postgresql/extension/pgrowlocks--1.0.sql
+share/postgresql/extension/pgrowlocks--1.0--1.1.sql
+share/postgresql/extension/pgrowlocks--1.1.sql
share/postgresql/extension/pgrowlocks--unpackaged--1.0.sql
share/postgresql/extension/pgrowlocks.control
-share/postgresql/extension/pgstattuple--1.0.sql
+share/postgresql/extension/pgstattuple--1.0--1.1.sql
+share/postgresql/extension/pgstattuple--1.1.sql
share/postgresql/extension/pgstattuple--unpackaged--1.0.sql
share/postgresql/extension/pgstattuple.control
+share/postgresql/extension/postgres_fdw--1.0.sql
+share/postgresql/extension/postgres_fdw.control
share/postgresql/extension/refint--1.0.sql
share/postgresql/extension/refint--unpackaged--1.0.sql
share/postgresql/extension/refint.control
Index: pkg/PLIST-docs
===================================================================
RCS file: /cvs/ports/databases/postgresql/pkg/PLIST-docs,v
retrieving revision 1.60
diff -u -p -r1.60 PLIST-docs
--- pkg/PLIST-docs 4 Apr 2013 14:45:46 -0000 1.60
+++ pkg/PLIST-docs 16 May 2013 22:44:16 -0000
@@ -27,6 +27,7 @@ share/doc/postgresql/html/app-ecpg.html
share/doc/postgresql/html/app-initdb.html
share/doc/postgresql/html/app-pg-ctl.html
share/doc/postgresql/html/app-pg-dumpall.html
+share/doc/postgresql/html/app-pg-isready.html
share/doc/postgresql/html/app-pgbasebackup.html
share/doc/postgresql/html/app-pgconfig.html
share/doc/postgresql/html/app-pgcontroldata.html
@@ -51,6 +52,7 @@ share/doc/postgresql/html/auto-explain.h
share/doc/postgresql/html/backup-dump.html
share/doc/postgresql/html/backup-file.html
share/doc/postgresql/html/backup.html
+share/doc/postgresql/html/bgworker.html
share/doc/postgresql/html/biblio.html
share/doc/postgresql/html/bki-commands.html
share/doc/postgresql/html/bki-example.html
@@ -80,6 +82,7 @@ share/doc/postgresql/html/catalog-pg-def
share/doc/postgresql/html/catalog-pg-depend.html
share/doc/postgresql/html/catalog-pg-description.html
share/doc/postgresql/html/catalog-pg-enum.html
+share/doc/postgresql/html/catalog-pg-event-trigger.html
share/doc/postgresql/html/catalog-pg-extension.html
share/doc/postgresql/html/catalog-pg-foreign-data-wrapper.html
share/doc/postgresql/html/catalog-pg-foreign-server.html
@@ -243,6 +246,9 @@ share/doc/postgresql/html/errcodes-appen
share/doc/postgresql/html/error-message-reporting.html
share/doc/postgresql/html/error-style-guide.html
share/doc/postgresql/html/event-log-registration.html
+share/doc/postgresql/html/event-trigger-definition.html
+share/doc/postgresql/html/event-trigger-matrix.html
+share/doc/postgresql/html/event-triggers.html
share/doc/postgresql/html/executor.html
share/doc/postgresql/html/explicit-joins.html
share/doc/postgresql/html/explicit-locking.html
@@ -274,6 +280,7 @@ share/doc/postgresql/html/functions-comp
share/doc/postgresql/html/functions-conditional.html
share/doc/postgresql/html/functions-datetime.html
share/doc/postgresql/html/functions-enum.html
+share/doc/postgresql/html/functions-event-triggers.html
share/doc/postgresql/html/functions-formatting.html
share/doc/postgresql/html/functions-geometry.html
share/doc/postgresql/html/functions-info.html
@@ -489,6 +496,7 @@ share/doc/postgresql/html/pgtestfsync.ht
share/doc/postgresql/html/pgtesttiming.html
share/doc/postgresql/html/pgtrgm.html
share/doc/postgresql/html/pgupgrade.html
+share/doc/postgresql/html/pgxlogdump.html
share/doc/postgresql/html/planner-optimizer.html
share/doc/postgresql/html/planner-stats-details.html
share/doc/postgresql/html/planner-stats.html
@@ -535,6 +543,7 @@ share/doc/postgresql/html/pltcl-trigger.
share/doc/postgresql/html/pltcl-unknown.html
share/doc/postgresql/html/pltcl.html
share/doc/postgresql/html/populate.html
+share/doc/postgresql/html/postgres-fdw.html
share/doc/postgresql/html/postgres-user.html
share/doc/postgresql/html/preface.html
share/doc/postgresql/html/preventing-server-spoofing.html
@@ -806,6 +815,7 @@ share/doc/postgresql/html/release-9-2-2.
share/doc/postgresql/html/release-9-2-3.html
share/doc/postgresql/html/release-9-2-4.html
share/doc/postgresql/html/release-9-2.html
+share/doc/postgresql/html/release-9-3.html
share/doc/postgresql/html/release.html
share/doc/postgresql/html/resources.html
share/doc/postgresql/html/role-attributes.html
@@ -815,6 +825,7 @@ share/doc/postgresql/html/routine-vacuum
share/doc/postgresql/html/row-estimation-examples.html
share/doc/postgresql/html/rowtypes.html
share/doc/postgresql/html/rule-system.html
+share/doc/postgresql/html/rules-materializedviews.html
share/doc/postgresql/html/rules-privileges.html
share/doc/postgresql/html/rules-status.html
share/doc/postgresql/html/rules-triggers.html
@@ -910,6 +921,7 @@ share/doc/postgresql/html/sql-alterconve
share/doc/postgresql/html/sql-alterdatabase.html
share/doc/postgresql/html/sql-alterdefaultprivileges.html
share/doc/postgresql/html/sql-alterdomain.html
+share/doc/postgresql/html/sql-altereventtrigger.html
share/doc/postgresql/html/sql-alterextension.html
share/doc/postgresql/html/sql-alterforeigndatawrapper.html
share/doc/postgresql/html/sql-alterforeigntable.html
@@ -918,10 +930,12 @@ share/doc/postgresql/html/sql-altergroup
share/doc/postgresql/html/sql-alterindex.html
share/doc/postgresql/html/sql-alterlanguage.html
share/doc/postgresql/html/sql-alterlargeobject.html
+share/doc/postgresql/html/sql-altermaterializedview.html
share/doc/postgresql/html/sql-alteropclass.html
share/doc/postgresql/html/sql-alteroperator.html
share/doc/postgresql/html/sql-alteropfamily.html
share/doc/postgresql/html/sql-alterrole.html
+share/doc/postgresql/html/sql-alterrule.html
share/doc/postgresql/html/sql-alterschema.html
share/doc/postgresql/html/sql-altersequence.html
share/doc/postgresql/html/sql-alterserver.html
@@ -952,6 +966,7 @@ share/doc/postgresql/html/sql-createcoll
share/doc/postgresql/html/sql-createconversion.html
share/doc/postgresql/html/sql-createdatabase.html
share/doc/postgresql/html/sql-createdomain.html
+share/doc/postgresql/html/sql-createeventtrigger.html
share/doc/postgresql/html/sql-createextension.html
share/doc/postgresql/html/sql-createforeigndatawrapper.html
share/doc/postgresql/html/sql-createforeigntable.html
@@ -959,6 +974,7 @@ share/doc/postgresql/html/sql-createfunc
share/doc/postgresql/html/sql-creategroup.html
share/doc/postgresql/html/sql-createindex.html
share/doc/postgresql/html/sql-createlanguage.html
+share/doc/postgresql/html/sql-creatematerializedview.html
share/doc/postgresql/html/sql-createopclass.html
share/doc/postgresql/html/sql-createoperator.html
share/doc/postgresql/html/sql-createopfamily.html
@@ -991,6 +1007,7 @@ share/doc/postgresql/html/sql-dropcollat
share/doc/postgresql/html/sql-dropconversion.html
share/doc/postgresql/html/sql-dropdatabase.html
share/doc/postgresql/html/sql-dropdomain.html
+share/doc/postgresql/html/sql-dropeventtrigger.html
share/doc/postgresql/html/sql-dropextension.html
share/doc/postgresql/html/sql-dropforeigndatawrapper.html
share/doc/postgresql/html/sql-dropforeigntable.html
@@ -998,6 +1015,7 @@ share/doc/postgresql/html/sql-dropfuncti
share/doc/postgresql/html/sql-dropgroup.html
share/doc/postgresql/html/sql-dropindex.html
share/doc/postgresql/html/sql-droplanguage.html
+share/doc/postgresql/html/sql-dropmaterializedview.html
share/doc/postgresql/html/sql-dropopclass.html
share/doc/postgresql/html/sql-dropoperator.html
share/doc/postgresql/html/sql-dropopfamily.html
@@ -1033,6 +1051,7 @@ share/doc/postgresql/html/sql-notify.htm
share/doc/postgresql/html/sql-prepare-transaction.html
share/doc/postgresql/html/sql-prepare.html
share/doc/postgresql/html/sql-reassign-owned.html
+share/doc/postgresql/html/sql-refreshmaterializedview.html
share/doc/postgresql/html/sql-reindex.html
share/doc/postgresql/html/sql-release-savepoint.html
share/doc/postgresql/html/sql-reset.html
@@ -1139,6 +1158,7 @@ share/doc/postgresql/html/view-pg-cursor
share/doc/postgresql/html/view-pg-group.html
share/doc/postgresql/html/view-pg-indexes.html
share/doc/postgresql/html/view-pg-locks.html
+share/doc/postgresql/html/view-pg-matviews.html
share/doc/postgresql/html/view-pg-prepared-statements.html
share/doc/postgresql/html/view-pg-prepared-xacts.html
share/doc/postgresql/html/view-pg-roles.html
Index: pkg/PLIST-main
===================================================================
RCS file: /cvs/ports/databases/postgresql/pkg/PLIST-main,v
retrieving revision 1.22
diff -u -p -r1.22 PLIST-main
--- pkg/PLIST-main 24 Sep 2012 19:57:02 -0000 1.22
+++ pkg/PLIST-main 16 May 2013 22:42:03 -0000
@@ -65,6 +65,7 @@ lib/libecpg_compat.a
@comment lib/libecpg_compat.so
@comment lib/libecpg_compat.so.4
@lib lib/libecpg_compat.so.${LIBecpg_compat_VERSION}
+lib/libpgcommon.a
lib/libpgport.a
lib/libpgtypes.a
@comment lib/libpgtypes.so
@@ -74,6 +75,11 @@ lib/libpq.a
@comment lib/libpq.so
@comment lib/libpq.so.5
@lib lib/libpq.so.${LIBpq_VERSION}
+lib/pkgconfig/
+lib/pkgconfig/libecpg.pc
+lib/pkgconfig/libecpg_compat.pc
+lib/pkgconfig/libpgtypes.pc
+lib/pkgconfig/libpq.pc
lib/postgresql/
lib/postgresql/pgxs/
lib/postgresql/pgxs/config/
@@ -100,8 +106,10 @@ lib/postgresql/pgxs/src/test/regress/
@man man/man1/pg_config.1
@man man/man1/pg_dump.1
@man man/man1/pg_dumpall.1
+@man man/man1/pg_isready.1
@man man/man1/pg_receivexlog.1
@man man/man1/pg_restore.1
+@man man/man1/pg_xlogdump.1
@man man/man1/psql.1
@man man/man1/reindexdb.1
@man man/man1/vacuumdb.1
@@ -175,6 +183,7 @@ lib/postgresql/pgxs/src/test/regress/
@man man/man7/ALTER_DATABASE.7
@man man/man7/ALTER_DEFAULT_PRIVILEGES.7
@man man/man7/ALTER_DOMAIN.7
+@man man/man7/ALTER_EVENT_TRIGGER.7
@man man/man7/ALTER_EXTENSION.7
@man man/man7/ALTER_FOREIGN_DATA_WRAPPER.7
@man man/man7/ALTER_FOREIGN_TABLE.7
@@ -183,10 +192,12 @@ lib/postgresql/pgxs/src/test/regress/
@man man/man7/ALTER_INDEX.7
@man man/man7/ALTER_LANGUAGE.7
@man man/man7/ALTER_LARGE_OBJECT.7
+@man man/man7/ALTER_MATERIALIZED_VIEW.7
@man man/man7/ALTER_OPERATOR.7
@man man/man7/ALTER_OPERATOR_CLASS.7
@man man/man7/ALTER_OPERATOR_FAMILY.7
@man man/man7/ALTER_ROLE.7
+@man man/man7/ALTER_RULE.7
@man man/man7/ALTER_SCHEMA.7
@man man/man7/ALTER_SEQUENCE.7
@man man/man7/ALTER_SERVER.7
@@ -216,6 +227,7 @@ lib/postgresql/pgxs/src/test/regress/
@man man/man7/CREATE_CONVERSION.7
@man man/man7/CREATE_DATABASE.7
@man man/man7/CREATE_DOMAIN.7
+@man man/man7/CREATE_EVENT_TRIGGER.7
@man man/man7/CREATE_EXTENSION.7
@man man/man7/CREATE_FOREIGN_DATA_WRAPPER.7
@man man/man7/CREATE_FOREIGN_TABLE.7
@@ -223,6 +235,7 @@ lib/postgresql/pgxs/src/test/regress/
@man man/man7/CREATE_GROUP.7
@man man/man7/CREATE_INDEX.7
@man man/man7/CREATE_LANGUAGE.7
+@man man/man7/CREATE_MATERIALIZED_VIEW.7
@man man/man7/CREATE_OPERATOR.7
@man man/man7/CREATE_OPERATOR_CLASS.7
@man man/man7/CREATE_OPERATOR_FAMILY.7
@@ -254,6 +267,7 @@ lib/postgresql/pgxs/src/test/regress/
@man man/man7/DROP_CONVERSION.7
@man man/man7/DROP_DATABASE.7
@man man/man7/DROP_DOMAIN.7
+@man man/man7/DROP_EVENT_TRIGGER.7
@man man/man7/DROP_EXTENSION.7
@man man/man7/DROP_FOREIGN_DATA_WRAPPER.7
@man man/man7/DROP_FOREIGN_TABLE.7
@@ -261,6 +275,7 @@ lib/postgresql/pgxs/src/test/regress/
@man man/man7/DROP_GROUP.7
@man man/man7/DROP_INDEX.7
@man man/man7/DROP_LANGUAGE.7
+@man man/man7/DROP_MATERIALIZED_VIEW.7
@man man/man7/DROP_OPERATOR.7
@man man/man7/DROP_OPERATOR_CLASS.7
@man man/man7/DROP_OPERATOR_FAMILY.7
@@ -295,6 +310,7 @@ lib/postgresql/pgxs/src/test/regress/
@man man/man7/PREPARE.7
@man man/man7/PREPARE_TRANSACTION.7
@man man/man7/REASSIGN_OWNED.7
+@man man/man7/REFRESH_MATERIALIZED_VIEW.7
@man man/man7/REINDEX.7
@man man/man7/RELEASE_SAVEPOINT.7
@man man/man7/RESET.7
Index: pkg/PLIST-plpython
===================================================================
RCS file: pkg/PLIST-plpython
diff -N pkg/PLIST-plpython
--- /dev/null 1 Jan 1970 00:00:00 -0000
+++ pkg/PLIST-plpython 16 May 2013 22:24:31 -0000
@@ -0,0 +1,8 @@
+@comment $OpenBSD$
+lib/postgresql/plpython2.so
+share/postgresql/extension/plpython2u--1.0.sql
+share/postgresql/extension/plpython2u--unpackaged--1.0.sql
+share/postgresql/extension/plpython2u.control
+share/postgresql/extension/plpythonu--1.0.sql
+share/postgresql/extension/plpythonu--unpackaged--1.0.sql
+share/postgresql/extension/plpythonu.control
Index: pkg/PLIST-server
===================================================================
RCS file: /cvs/ports/databases/postgresql/pkg/PLIST-server,v
retrieving revision 1.22
diff -u -p -r1.22 PLIST-server
--- pkg/PLIST-server 24 Sep 2012 19:57:02 -0000 1.22
+++ pkg/PLIST-server 16 May 2013 22:45:58 -0000
@@ -10,9 +10,33 @@
@bin bin/initdb
@bin bin/pg_controldata
@bin bin/pg_ctl
+@bin bin/pg_isready
@bin bin/pg_resetxlog
+@bin bin/pg_xlogdump
@bin bin/postgres
bin/postmaster
+@comment include/postgresql/server/port/irix.h
+@comment include/postgresql/server/port/win32/
+@comment include/postgresql/server/port/win32/arpa/
+@comment include/postgresql/server/port/win32/arpa/inet.h
+@comment include/postgresql/server/port/win32/dlfcn.h
+@comment include/postgresql/server/port/win32/grp.h
+@comment include/postgresql/server/port/win32/netdb.h
+@comment include/postgresql/server/port/win32/netinet/
+@comment include/postgresql/server/port/win32/netinet/in.h
+@comment include/postgresql/server/port/win32/pwd.h
+@comment include/postgresql/server/port/win32/sys/
+@comment include/postgresql/server/port/win32/sys/socket.h
+@comment include/postgresql/server/port/win32/sys/wait.h
+@comment include/postgresql/server/port/win32_msvc/
+@comment include/postgresql/server/port/win32_msvc/dirent.h
+@comment include/postgresql/server/port/win32_msvc/sys/
+@comment include/postgresql/server/port/win32_msvc/sys/file.h
+@comment include/postgresql/server/port/win32_msvc/sys/param.h
+@comment include/postgresql/server/port/win32_msvc/sys/time.h
+@comment include/postgresql/server/port/win32_msvc/unistd.h
+@comment include/postgresql/server/port/win32_msvc/utime.h
+include/postgresql/pg_config_ext.h
include/postgresql/server/
include/postgresql/server/access/
include/postgresql/server/access/attnum.h
@@ -25,8 +49,10 @@ include/postgresql/server/access/gist_pr
include/postgresql/server/access/gistscan.h
include/postgresql/server/access/hash.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
@@ -35,6 +61,7 @@ include/postgresql/server/access/relopti
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
@@ -42,6 +69,7 @@ include/postgresql/server/access/spgist.
include/postgresql/server/access/spgist_private.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/tupconvert.h
include/postgresql/server/access/tupdesc.h
@@ -53,8 +81,10 @@ 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_fn.h
include/postgresql/server/access/xlog_internal.h
include/postgresql/server/access/xlogdefs.h
+include/postgresql/server/access/xlogreader.h
include/postgresql/server/access/xlogutils.h
include/postgresql/server/bootstrap/
include/postgresql/server/bootstrap/bootstrap.h
@@ -92,6 +122,7 @@ include/postgresql/server/catalog/pg_def
include/postgresql/server/catalog/pg_depend.h
include/postgresql/server/catalog/pg_description.h
include/postgresql/server/catalog/pg_enum.h
+include/postgresql/server/catalog/pg_event_trigger.h
include/postgresql/server/catalog/pg_extension.h
include/postgresql/server/catalog/pg_foreign_data_wrapper.h
include/postgresql/server/catalog/pg_foreign_server.h
@@ -128,6 +159,7 @@ include/postgresql/server/catalog/pg_typ
include/postgresql/server/catalog/pg_user_mapping.h
include/postgresql/server/catalog/schemapg.h
include/postgresql/server/catalog/storage.h
+include/postgresql/server/catalog/storage_xlog.h
include/postgresql/server/catalog/toasting.h
include/postgresql/server/commands/
include/postgresql/server/commands/alter.h
@@ -141,9 +173,11 @@ include/postgresql/server/commands/creat
include/postgresql/server/commands/dbcommands.h
include/postgresql/server/commands/defrem.h
include/postgresql/server/commands/discard.h
+include/postgresql/server/commands/event_trigger.h
include/postgresql/server/commands/explain.h
include/postgresql/server/commands/extension.h
include/postgresql/server/commands/lockcmds.h
+include/postgresql/server/commands/matview.h
include/postgresql/server/commands/portalcmds.h
include/postgresql/server/commands/prepare.h
include/postgresql/server/commands/proclang.h
@@ -158,6 +192,9 @@ include/postgresql/server/commands/user.
include/postgresql/server/commands/vacuum.h
include/postgresql/server/commands/variable.h
include/postgresql/server/commands/view.h
+include/postgresql/server/common/
+include/postgresql/server/common/fe_memutils.h
+include/postgresql/server/common/relpath.h
include/postgresql/server/datatype/
include/postgresql/server/datatype/timestamp.h
include/postgresql/server/dynloader.h
@@ -213,7 +250,8 @@ include/postgresql/server/funcapi.h
include/postgresql/server/getaddrinfo.h
include/postgresql/server/getopt_long.h
include/postgresql/server/lib/
-include/postgresql/server/lib/dllist.h
+include/postgresql/server/lib/binaryheap.h
+include/postgresql/server/lib/ilist.h
include/postgresql/server/lib/stringinfo.h
include/postgresql/server/libpq/
include/postgresql/server/libpq/auth.h
@@ -299,20 +337,21 @@ include/postgresql/server/parser/parsetr
include/postgresql/server/parser/scanner.h
include/postgresql/server/parser/scansup.h
include/postgresql/server/pg_config.h
+include/postgresql/server/pg_config_ext.h
include/postgresql/server/pg_config_manual.h
include/postgresql/server/pg_config_os.h
include/postgresql/server/pg_trace.h
include/postgresql/server/pgstat.h
+include/postgresql/server/pgtar.h
include/postgresql/server/pgtime.h
include/postgresql/server/plpgsql.h
-include/postgresql/server/port/
include/postgresql/server/port.h
+include/postgresql/server/port/
include/postgresql/server/port/aix.h
include/postgresql/server/port/cygwin.h
include/postgresql/server/port/darwin.h
include/postgresql/server/port/freebsd.h
include/postgresql/server/port/hpux.h
-@comment include/postgresql/server/port/irix.h
include/postgresql/server/port/linux.h
include/postgresql/server/port/netbsd.h
include/postgresql/server/port/openbsd.h
@@ -320,27 +359,7 @@ include/postgresql/server/port/osf.h
include/postgresql/server/port/sco.h
include/postgresql/server/port/solaris.h
include/postgresql/server/port/unixware.h
-@comment include/postgresql/server/port/win32/
include/postgresql/server/port/win32.h
-@comment include/postgresql/server/port/win32/arpa/
-@comment include/postgresql/server/port/win32/arpa/inet.h
-@comment include/postgresql/server/port/win32/dlfcn.h
-@comment include/postgresql/server/port/win32/grp.h
-@comment include/postgresql/server/port/win32/netdb.h
-@comment include/postgresql/server/port/win32/netinet/
-@comment include/postgresql/server/port/win32/netinet/in.h
-@comment include/postgresql/server/port/win32/pwd.h
-@comment include/postgresql/server/port/win32/sys/
-@comment include/postgresql/server/port/win32/sys/socket.h
-@comment include/postgresql/server/port/win32/sys/wait.h
-@comment include/postgresql/server/port/win32_msvc/
-@comment include/postgresql/server/port/win32_msvc/dirent.h
-@comment include/postgresql/server/port/win32_msvc/sys/
-@comment include/postgresql/server/port/win32_msvc/sys/file.h
-@comment include/postgresql/server/port/win32_msvc/sys/param.h
-@comment include/postgresql/server/port/win32_msvc/sys/time.h
-@comment include/postgresql/server/port/win32_msvc/unistd.h
-@comment include/postgresql/server/port/win32_msvc/utime.h
include/postgresql/server/portability/
include/postgresql/server/portability/instr_time.h
include/postgresql/server/postgres.h
@@ -348,6 +367,7 @@ include/postgresql/server/postgres_ext.h
include/postgresql/server/postgres_fe.h
include/postgresql/server/postmaster/
include/postgresql/server/postmaster/autovacuum.h
+include/postgresql/server/postmaster/bgworker.h
include/postgresql/server/postmaster/bgwriter.h
include/postgresql/server/postmaster/fork_process.h
include/postgresql/server/postmaster/pgarch.h
@@ -359,11 +379,11 @@ include/postgresql/server/regex/
include/postgresql/server/regex/regcustom.h
include/postgresql/server/regex/regerrs.h
include/postgresql/server/regex/regex.h
+include/postgresql/server/regex/regexport.h
include/postgresql/server/regex/regguts.h
include/postgresql/server/replication/
include/postgresql/server/replication/basebackup.h
include/postgresql/server/replication/syncrep.h
-include/postgresql/server/replication/walprotocol.h
include/postgresql/server/replication/walreceiver.h
include/postgresql/server/replication/walsender.h
include/postgresql/server/replication/walsender_private.h
@@ -420,6 +440,7 @@ include/postgresql/server/storage/buf_in
include/postgresql/server/storage/buffile.h
include/postgresql/server/storage/bufmgr.h
include/postgresql/server/storage/bufpage.h
+include/postgresql/server/storage/checksum.h
include/postgresql/server/storage/copydir.h
include/postgresql/server/storage/fd.h
include/postgresql/server/storage/freespace.h
@@ -486,6 +507,7 @@ include/postgresql/server/utils/dynahash
include/postgresql/server/utils/dynamic_loader.h
include/postgresql/server/utils/elog.h
include/postgresql/server/utils/errcodes.h
+include/postgresql/server/utils/evtcache.h
include/postgresql/server/utils/fmgroids.h
include/postgresql/server/utils/fmgrtab.h
include/postgresql/server/utils/formatting.h
@@ -498,6 +520,7 @@ include/postgresql/server/utils/inet.h
include/postgresql/server/utils/int8.h
include/postgresql/server/utils/inval.h
include/postgresql/server/utils/json.h
+include/postgresql/server/utils/jsonapi.h
include/postgresql/server/utils/logtape.h
include/postgresql/server/utils/lsyscache.h
include/postgresql/server/utils/memutils.h
@@ -520,12 +543,14 @@ include/postgresql/server/utils/relcache
include/postgresql/server/utils/relmapper.h
include/postgresql/server/utils/reltrigger.h
include/postgresql/server/utils/resowner.h
+include/postgresql/server/utils/resowner_private.h
include/postgresql/server/utils/selfuncs.h
include/postgresql/server/utils/snapmgr.h
include/postgresql/server/utils/snapshot.h
include/postgresql/server/utils/sortsupport.h
include/postgresql/server/utils/spccache.h
include/postgresql/server/utils/syscache.h
+include/postgresql/server/utils/timeout.h
include/postgresql/server/utils/timestamp.h
include/postgresql/server/utils/tqual.h
include/postgresql/server/utils/tuplesort.h
Index: pkg/README-plpython
===================================================================
RCS file: pkg/README-plpython
diff -N pkg/README-plpython
--- /dev/null 1 Jan 1970 00:00:00 -0000
+++ pkg/README-plpython 9 Oct 2012 17:47:01 -0000
@@ -0,0 +1,9 @@
+pl/python requires pthreads in order to work. OpenBSD does not allow
+shared objects that link to pthreads to be opened via dlopen if the
+executable program does not link to pthreads. So to use pl/python, you
+must ensure that PostgreSQL links to libpthread. The easiest way to do
+this is adding the following login class to login.conf:
+
+postgresql:\
+ :setenv=LD_PRELOAD=libpthread.so:\
+ :tc=daemon:
Index: pkg/README-server
===================================================================
RCS file: /cvs/ports/databases/postgresql/pkg/README-server,v
retrieving revision 1.13
diff -u -p -r1.13 README-server
--- pkg/README-server 22 Nov 2012 10:52:38 -0000 1.13
+++ pkg/README-server 16 May 2013 23:08:50 -0000
@@ -77,19 +77,11 @@ following in /etc/sysctl.conf will be re
kern.seminfo.semmns=1024
To serve a large number of connections (>250), you may need higher
-values for the above, and may also need to increase the maximum shared
-memory segment size. On i386 try:
+values for the above.
- kern.shminfo.shmmax=50331648 # this is 48MB.
- # default on i386 is 32MB
- # other archs will vary
-
-These numbers should be tuned depending on system use. You will also
-need to tune the max_connect value in the postgresql.conf file to
-increase the number of connections to the backend. See "Managing
-Kernel Resources" in the "Server Setup and Operation" chapter of
-the manual (however at the time of writing the OpenBSD section is
-out-dated; a custom kernel has not been required).
+You may also want to tune the max_connect value in the
+postgresql.conf file to increase the number of connections to the
+backend.
By default, the _postgresql user, and so the postmaster and backend
processes run in the login(1) class of "daemon". On a busy server,
