On Fri, Sep 03, 2010 at 11:44:52PM +0200, Pierre-Emmanuel André wrote:
> On Fri, Jul 16, 2010 at 06:50:12PM +0200, Pierre-Emmanuel André wrote:
> > On Mon, Jun 07, 2010 at 01:43:54PM +0200, Pierre-Emmanuel André wrote:
> > > On Mon, May 03, 2010 at 12:19:49PM +0200, Pierre-Emmanuel André wrote:
> > > > Hi,
> > > >
> > > > I start a new thread for this future upgrade.
> > > > This firt shot is for the beta1.
> > > > One of the main feature for this release is Hot Standby
> > > > ( http://developer.postgresql.org/pgdocs/postgres/hot-standby.html )
> > > > Release note here:
> > > > http://developer.postgresql.org/pgdocs/postgres/release-9-0.html
> > > >
> > > > As usual you must dump/restore your data if you want to try this
> > > > update.
> > > >
> > >
> > > Second shot for beta2.
> > > As usual, tested on @amd64 (with gcc4).
> > >
> >
> > And now it's time for the beta3 !
> > If you want to know what's new in PostgreSQL 9.0, there is
> > a very good summary here:
> > http://wiki.postgresql.org/wiki/Illustrated_9_0
> >
>
> Time for rc1.
> Tested on macppc, sparc64 and amd64.
>
Latest diff for PostgreSQL:
+ update to 9.0.1
+ move README.OpenBSD to the new location
+ add a rc script
Tested on sparc64, macppc and amd64.
Regards,
--
Pierre-Emmanuel André <pea at raveland.org>
GPG key: 0x7AE329DC
Index: Makefile
===================================================================
RCS file: /cvs/ports/databases/postgresql/Makefile,v
retrieving revision 1.129
diff -u -p -r1.129 Makefile
--- Makefile 18 Oct 2010 17:06:08 -0000 1.129
+++ Makefile 3 Nov 2010 12:35:14 -0000
@@ -5,7 +5,7 @@ COMMENT-server= PostgreSQL RDBMS (server
COMMENT-docs= PostgreSQL RDBMS documentation
COMMENT-contrib=PostgreSQL RDBMS contributions
-VERSION= 8.4.5
+VERSION= 9.0.1
DISTNAME= postgresql-${VERSION}
PKGNAME-main= postgresql-client-${VERSION}
PKGNAME-server= postgresql-server-${VERSION}
@@ -13,10 +13,10 @@ PKGNAME-docs= postgresql-docs-${VERSION}
PKGNAME-contrib=postgresql-contrib-${VERSION}
CATEGORIES= databases
-SHARED_LIBS= ecpg 7.1 \
- ecpg_compat 4.1 \
+SHARED_LIBS= ecpg 7.2 \
+ ecpg_compat 4.2 \
pgtypes 4.1 \
- pq 5.2
+ pq 5.3
HOMEPAGE= http://www.postgresql.org/
@@ -52,7 +52,7 @@ CONFIGURE_STYLE=gnu
.include <bsd.own.mk>
-INCLUDES= ${LOCALBASE}/include
+INCLUDES= ${LOCALBASE}/include /usr/include/kerberosV
CONFIGURE_ARGS= --disable-rpath --with-openssl=/usr \
--with-perl \
--enable-integer-datetimes \
@@ -63,12 +63,9 @@ CONFIGURE_ARGS= --disable-rpath --with-o
--with-libraries="${LOCALBASE}/lib" \
--with-openssl \
--with-ossp-uuid \
- --with-libxml
-
-.if ${KERBEROS5} == "yes"
-CONFIGURE_ARGS+=--with-krb5
-INCLUDES+= /usr/include/kerberosV
-.endif
+ --with-libxml \
+ --disable-thread-safety \
+ --with-krb5
# There is no spinlock support for hppa yet. Until we have access to
# a system to get this working, disable them for now. There is
@@ -80,7 +77,7 @@ CONFIGURE_ARGS+=--disable-spinlocks
MODGNU_CONFIG_GUESS_DIRS= ${WRKSRC}/config
-INSTALL_TARGET= install
+INSTALL_TARGET= install-world
LIB_DEPENDS-main= xml2::textproc/libxml
@@ -131,11 +128,7 @@ post-build:
post-install:
${INSTALL_DATA_DIR} ${PREFIX}/share/doc/postgresql
${INSTALL_DATA} ${DOCS} ${PREFIX}/share/doc/postgresql
- @sed -e s#!!PREFIX!!#${TRUEPREFIX}#g ${FILESDIR}/README.OpenBSD > \
- ${WRKBUILD}/README.OpenBSD
- ${INSTALL_DATA} ${WRKBUILD}/README.OpenBSD \
- ${PREFIX}/share/doc/postgresql
cd ${WRKBUILD}/contrib && exec ${SETENV} ${MAKE_ENV} DESTDIR=${WRKINST}
\
- ${MAKE_PROGRAM} ${MAKE_FLAGS} ${INSTALL_TARGET}
+ ${MAKE_PROGRAM} ${MAKE_FLAGS} ${INSTALL_TARGET}
.include <bsd.port.mk>
Index: distinfo
===================================================================
RCS file: /cvs/ports/databases/postgresql/distinfo,v
retrieving revision 1.34
diff -u -p -r1.34 distinfo
--- distinfo 8 Oct 2010 06:50:23 -0000 1.34
+++ distinfo 3 Nov 2010 12:35:14 -0000
@@ -1,5 +1,5 @@
-MD5 (postgresql-8.4.5.tar.gz) = jd6jNJO/XPb16mIhK7B53w==
-RMD160 (postgresql-8.4.5.tar.gz) = kCrOHvTSy5HEdtp/n0zfTIze79k=
-SHA1 (postgresql-8.4.5.tar.gz) = F7g5RNiS8+WSxhUYTkHXICObpZY=
-SHA256 (postgresql-8.4.5.tar.gz) = wu64Wocct8P0lM4kfnKXWIVOn0oZP7Wq3g4HCejkZrM=
-SIZE (postgresql-8.4.5.tar.gz) = 17590296
+MD5 (postgresql-9.0.1.tar.gz) = UJPDIbxHry6pr6cmYF/xzg==
+RMD160 (postgresql-9.0.1.tar.gz) = J9BzRpcN20PtdxkKIIv2r34/c+M=
+SHA1 (postgresql-9.0.1.tar.gz) = ly5HunOEnJ/ItsRXN7NgcGeF8Io=
+SHA256 (postgresql-9.0.1.tar.gz) = 0Grw1gWuVkJzgQFSCNz/j/l6tBb6QB41WP/DafXsleM=
+SIZE (postgresql-9.0.1.tar.gz) = 17898437
Index: files/README.OpenBSD
===================================================================
RCS file: files/README.OpenBSD
diff -N files/README.OpenBSD
--- files/README.OpenBSD 7 Jun 2007 20:39:51 -0000 1.20
+++ /dev/null 1 Jan 1970 00:00:00 -0000
@@ -1,120 +0,0 @@
-Using PostgreSQL in an OpenBSD environment
-
-At least two different accounts are involved when working with PostgreSQL:
-One is an OpenBSD userid, '_postgresql', which is used as the userid of files
-that are part of PostgreSQL. The other, usually named 'postgres', is not an
-OpenBSD userid, i.e. you will not find it in /etc/passwd, but an account
-internal to the database system. The 'postgres' account is called the dba
-account (database administrator) and is created when a new database is
-initialized using the initdb command.
-
-If you are installing PostgreSQL for the first time, you have to create
-a default database first. In the following example we install a database
-in /var/postgresql/data with a dba account 'postgres' and md5 authentication.
-We will be prompted for a password to protect the dba account:
-
- # su - _postgresql
- $ mkdir /var/postgresql/data
- $ initdb -D /var/postgresql/data -U postgres -A md5 -W
-
-It is strongly advised that you do not work with the postgres dba account
-other than creating more users and/or databases or for administrative task.
-Use the PostgreSQL permission system to make sure that a database is only
-accessed by programs/users that have the right to do so.
-
-Please consult the PostgreSQL website for more information, especially when
-you are upgrading an existing database installation.
-
-Auto Start and Stop
-
-To start PostgreSQL at boot and shut it down when the system shuts down,
-add the following lines to /etc/rc.local and /etc/rc.shutdown, respectively:
-
-/etc/rc.local:
-
-if [ -x !!PREFIX!!/bin/pg_ctl ]; then
- echo -n ' postgresql'
- su -l _postgresql -c "nohup !!PREFIX!!/bin/pg_ctl start \
- -D /var/postgresql/data -l /var/postgresql/logfile \
- -o '-D /var/postgresql/data' >/dev/null"
-fi
-
-/etc/rc.shutdown:
-
-if [ -f /var/postgresql/data/postmaster.pid ]; then
- su -l _postgresql -c "!!PREFIX!!/bin/pg_ctl stop -m fast \
- -D /var/postgresql/data"
- rm -f /var/postgresql/data/postmaster.pid
-fi
-
-Network Connections and Tuning
-
-To allow connections over TCP (and other options) edit the file:
-
- /var/postgresql/data/postgresql.conf
-
-and also edit the pg_hba.conf (in the same directory) making the
-appropriate changes to allow connection from your network.
-
-The default sizes in the GENERIC kernel for SysV semaphores
-are not really large enough for a database with more than a
-handful of connections. A server running such a database should
-have at least the following in /etc/sysctl.conf:
-
- kern.seminfo.semmni=256
- kern.seminfo.semmns=2048
-
-To serve a large number of connections (>250), you may also need
-to increase the maximum shared memory segment size, on the i386
-try:
-
- 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 values 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,
-it may be advisable to put the _postgresql user and processes in
-their own login(1) class with tuned resources, such as more open
-file descriptors etc.
-
-For example, add this to the login.conf(5) file:
-
- postgresql:\
- :openfiles-cur=768:\
- :tc=daemon:
-
-Rebuild the login.conf.db file if necessary:
-
- # cap_mkdb /etc/login.conf
-
-Change the login class with either vipw(8) or chsh(8).
-
-For more than about 250 connections, these numbers should be
-increased. Please report any changes and experiences to the package
-maintainers so that we can update this file for future versions.
-
-Kerberos authentication
-
-By default the postgresql server requires it's own krb5.keytab file. It
-should be readable only by the _postgresql user. The default location of
-the file is '/etc/postgresql/krb5.keytab' but is tunable by setting the
-krb_server_keyfile line in postgresql.conf.
-
-To generate the keytab:
-
- # mkdir /etc/postgresql
- # ktutil -k /etc/postgresql/krb5.keytab get postgres/server.domain
- # chown _postgresql:_postgresql /etc/postgresql/krb5.keytab
-
-Clients/Frontends
-
-Many applications can use the PostgreSQL database right away. To faciliate
-administration of a PostgreSQL database, two clients are notable:
-
-www/phppgadmin A web based user interface that uses PHP5
-databases/pgadmin3 A graphical user interface that uses wxWidgets
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.4
diff -u -p -r1.4 patch-src_interfaces_ecpg_compatlib_Makefile
--- patches/patch-src_interfaces_ecpg_compatlib_Makefile 21 Jul 2009
19:43:45 -0000 1.4
+++ patches/patch-src_interfaces_ecpg_compatlib_Makefile 3 Nov 2010
12:35:14 -0000
@@ -1,12 +1,12 @@
$OpenBSD: patch-src_interfaces_ecpg_compatlib_Makefile,v 1.4 2009/07/21
19:43:45 pea Exp $
---- src/interfaces/ecpg/compatlib/Makefile.orig Thu Jan 1 18:24:02 2009
-+++ src/interfaces/ecpg/compatlib/Makefile Sun May 31 11:59:15 2009
+--- src/interfaces/ecpg/compatlib/Makefile.orig Fri Aug 14 15:28:22 2009
++++ src/interfaces/ecpg/compatlib/Makefile Mon Dec 28 11:10:32 2009
@@ -14,8 +14,8 @@ top_builddir = ../../../..
include $(top_builddir)/src/Makefile.global
NAME= ecpg_compat
-SO_MAJOR_VERSION= 3
--SO_MINOR_VERSION= 1
+-SO_MINOR_VERSION= 2
+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.4
diff -u -p -r1.4 patch-src_interfaces_ecpg_ecpglib_Makefile
--- patches/patch-src_interfaces_ecpg_ecpglib_Makefile 21 Jul 2009 19:43:45
-0000 1.4
+++ patches/patch-src_interfaces_ecpg_ecpglib_Makefile 3 Nov 2010 12:35:14
-0000
@@ -1,12 +1,12 @@
$OpenBSD: patch-src_interfaces_ecpg_ecpglib_Makefile,v 1.4 2009/07/21 19:43:45
pea Exp $
---- src/interfaces/ecpg/ecpglib/Makefile.orig Sat Feb 7 18:17:34 2009
-+++ src/interfaces/ecpg/ecpglib/Makefile Sun May 31 11:59:50 2009
+--- src/interfaces/ecpg/ecpglib/Makefile.orig Mon Jul 13 03:37:05 2009
++++ src/interfaces/ecpg/ecpglib/Makefile Mon Dec 28 11:11:04 2009
@@ -14,8 +14,8 @@ top_builddir = ../../../..
include $(top_builddir)/src/Makefile.global
NAME= ecpg
-SO_MAJOR_VERSION= 6
--SO_MINOR_VERSION= 1
+-SO_MINOR_VERSION= 2
+SO_MAJOR_VERSION= ${LIBecpg_MAJOR}
+SO_MINOR_VERSION= ${LIBecpg_MINOR}
Index: patches/patch-src_interfaces_libpq_Makefile
===================================================================
RCS file:
/cvs/ports/databases/postgresql/patches/patch-src_interfaces_libpq_Makefile,v
retrieving revision 1.6
diff -u -p -r1.6 patch-src_interfaces_libpq_Makefile
--- patches/patch-src_interfaces_libpq_Makefile 21 Jul 2009 19:43:45 -0000
1.6
+++ patches/patch-src_interfaces_libpq_Makefile 3 Nov 2010 12:35:14 -0000
@@ -1,12 +1,12 @@
$OpenBSD: patch-src_interfaces_libpq_Makefile,v 1.6 2009/07/21 19:43:45 pea
Exp $
---- src/interfaces/libpq/Makefile.orig Mon Jan 5 10:27:19 2009
-+++ src/interfaces/libpq/Makefile Sun May 31 12:00:52 2009
+--- src/interfaces/libpq/Makefile.orig Fri Aug 28 22:26:19 2009
++++ src/interfaces/libpq/Makefile Mon Dec 28 11:11:34 2009
@@ -16,8 +16,8 @@ include $(top_builddir)/src/Makefile.global
# shared library parameters
NAME= pq
-SO_MAJOR_VERSION= 5
--SO_MINOR_VERSION= 2
+-SO_MINOR_VERSION= 3
+SO_MAJOR_VERSION= ${LIBpq_MAJOR}
+SO_MINOR_VERSION= ${LIBpq_MINOR}
Index: pkg/MESSAGE-server
===================================================================
RCS file: pkg/MESSAGE-server
diff -N pkg/MESSAGE-server
--- pkg/MESSAGE-server 18 Jul 2008 06:57:30 -0000 1.7
+++ /dev/null 1 Jan 1970 00:00:00 -0000
@@ -1,4 +0,0 @@
-To use the postgresql server you have to create a database first.
-
-You find detailed instructions on how to install a database in the file
-${PREFIX}/share/doc/postgresql/README.OpenBSD.
Index: pkg/PLIST-contrib
===================================================================
RCS file: /cvs/ports/databases/postgresql/pkg/PLIST-contrib,v
retrieving revision 1.6
diff -u -p -r1.6 PLIST-contrib
--- pkg/PLIST-contrib 23 Mar 2010 10:24:45 -0000 1.6
+++ pkg/PLIST-contrib 3 Nov 2010 12:35:14 -0000
@@ -3,7 +3,9 @@
@conflict postgresql-server-<8.4.3
@pkgpath devel/uuid,-pgsql
@bin bin/oid2name
+...@bin bin/pg_archivecleanup
@bin bin/pg_standby
+...@bin bin/pg_upgrade
@bin bin/pgbench
@bin bin/vacuumlo
lib/postgresql/_int.so
@@ -28,6 +30,7 @@ lib/postgresql/pg_buffercache.so
lib/postgresql/pg_freespacemap.so
lib/postgresql/pg_stat_statements.so
lib/postgresql/pg_trgm.so
+lib/postgresql/pg_upgrade_support.so
lib/postgresql/pgcrypto.so
lib/postgresql/pgrowlocks.so
lib/postgresql/pgstattuple.so
@@ -76,6 +79,7 @@ share/postgresql/contrib/tablefunc.sql
share/postgresql/contrib/test_parser.sql
share/postgresql/contrib/timetravel.sql
share/postgresql/contrib/tsearch2.sql
+share/postgresql/contrib/unaccent.sql
share/postgresql/contrib/uninstall__int.sql
share/postgresql/contrib/uninstall_adminpack.sql
share/postgresql/contrib/uninstall_btree_gin.sql
@@ -107,5 +111,6 @@ share/postgresql/contrib/uninstall_sslin
share/postgresql/contrib/uninstall_tablefunc.sql
share/postgresql/contrib/uninstall_test_parser.sql
share/postgresql/contrib/uninstall_tsearch2.sql
+share/postgresql/contrib/uninstall_unaccent.sql
share/postgresql/contrib/uninstall_uuid-ossp.sql
share/postgresql/contrib/uuid-ossp.sql
Index: pkg/PLIST-docs
===================================================================
RCS file: /cvs/ports/databases/postgresql/pkg/PLIST-docs,v
retrieving revision 1.46
diff -u -p -r1.46 PLIST-docs
--- pkg/PLIST-docs 8 Oct 2010 06:50:23 -0000 1.46
+++ pkg/PLIST-docs 3 Nov 2010 12:35:14 -0000
@@ -1,4 +1,5 @@
@comment $OpenBSD: PLIST-docs,v 1.46 2010/10/08 06:50:23 pea Exp $
+share/doc/postgresql/
share/doc/postgresql/COPYRIGHT
share/doc/postgresql/HISTORY
share/doc/postgresql/INSTALL
@@ -40,6 +41,7 @@ share/doc/postgresql/html/app-reindexdb.
share/doc/postgresql/html/app-vacuumdb.html
share/doc/postgresql/html/appendixes.html
share/doc/postgresql/html/applevel-consistency.html
+share/doc/postgresql/html/archive-recovery-settings.html
share/doc/postgresql/html/arrays.html
share/doc/postgresql/html/auth-methods.html
share/doc/postgresql/html/auth-pg-hba-conf.html
@@ -71,6 +73,8 @@ share/doc/postgresql/html/catalog-pg-cla
share/doc/postgresql/html/catalog-pg-constraint.html
share/doc/postgresql/html/catalog-pg-conversion.html
share/doc/postgresql/html/catalog-pg-database.html
+share/doc/postgresql/html/catalog-pg-db-role-setting.html
+share/doc/postgresql/html/catalog-pg-default-acl.html
share/doc/postgresql/html/catalog-pg-depend.html
share/doc/postgresql/html/catalog-pg-description.html
share/doc/postgresql/html/catalog-pg-enum.html
@@ -79,8 +83,8 @@ share/doc/postgresql/html/catalog-pg-for
share/doc/postgresql/html/catalog-pg-index.html
share/doc/postgresql/html/catalog-pg-inherits.html
share/doc/postgresql/html/catalog-pg-language.html
+share/doc/postgresql/html/catalog-pg-largeobject-metadata.html
share/doc/postgresql/html/catalog-pg-largeobject.html
-share/doc/postgresql/html/catalog-pg-listener.html
share/doc/postgresql/html/catalog-pg-namespace.html
share/doc/postgresql/html/catalog-pg-opclass.html
share/doc/postgresql/html/catalog-pg-operator.html
@@ -123,6 +127,7 @@ share/doc/postgresql/html/contrib-dblink
share/doc/postgresql/html/contrib-dblink-exec.html
share/doc/postgresql/html/contrib-dblink-fetch.html
share/doc/postgresql/html/contrib-dblink-get-connections.html
+share/doc/postgresql/html/contrib-dblink-get-notify.html
share/doc/postgresql/html/contrib-dblink-get-pkey.html
share/doc/postgresql/html/contrib-dblink-get-result.html
share/doc/postgresql/html/contrib-dblink-is-busy.html
@@ -170,6 +175,7 @@ share/doc/postgresql/html/ddl-system-col
share/doc/postgresql/html/ddl.html
share/doc/postgresql/html/dict-int.html
share/doc/postgresql/html/dict-xsyn.html
+share/doc/postgresql/html/different-replication-solutions.html
share/doc/postgresql/html/disk-full.html
share/doc/postgresql/html/disk-usage.html
share/doc/postgresql/html/diskusage.html
@@ -208,6 +214,7 @@ share/doc/postgresql/html/error-style-gu
share/doc/postgresql/html/executor.html
share/doc/postgresql/html/explicit-joins.html
share/doc/postgresql/html/explicit-locking.html
+share/doc/postgresql/html/extend-cpp.html
share/doc/postgresql/html/extend-how.html
share/doc/postgresql/html/extend-type-system.html
share/doc/postgresql/html/extend.html
@@ -265,6 +272,7 @@ share/doc/postgresql/html/gist.html
share/doc/postgresql/html/git.html
share/doc/postgresql/html/high-availability.html
share/doc/postgresql/html/history.html
+share/doc/postgresql/html/hot-standby.html
share/doc/postgresql/html/hstore.html
share/doc/postgresql/html/index-catalog.html
share/doc/postgresql/html/index-cost-estimation.html
@@ -331,6 +339,7 @@ share/doc/postgresql/html/infoschema-sql
share/doc/postgresql/html/infoschema-table-constraints.html
share/doc/postgresql/html/infoschema-table-privileges.html
share/doc/postgresql/html/infoschema-tables.html
+share/doc/postgresql/html/infoschema-triggered-update-columns.html
share/doc/postgresql/html/infoschema-triggers.html
share/doc/postgresql/html/infoschema-usage-privileges.html
share/doc/postgresql/html/infoschema-user-mapping-options.html
@@ -345,9 +354,9 @@ share/doc/postgresql/html/install-proced
share/doc/postgresql/html/install-requirements.html
share/doc/postgresql/html/install-short.html
share/doc/postgresql/html/install-upgrading.html
-share/doc/postgresql/html/install-win32-full.html
-share/doc/postgresql/html/install-win32-libpq.html
-share/doc/postgresql/html/install-win32.html
+share/doc/postgresql/html/install-windows-full.html
+share/doc/postgresql/html/install-windows-libpq.html
+share/doc/postgresql/html/install-windows.html
share/doc/postgresql/html/installation-platform-notes.html
share/doc/postgresql/html/installation.html
share/doc/postgresql/html/intagg.html
@@ -386,6 +395,7 @@ share/doc/postgresql/html/lo-intro.html
share/doc/postgresql/html/lo.html
share/doc/postgresql/html/locale.html
share/doc/postgresql/html/locking-indexes.html
+share/doc/postgresql/html/log-shipping-alternative.html
share/doc/postgresql/html/logfile-maintenance.html
share/doc/postgresql/html/ltree.html
share/doc/postgresql/html/maintenance.html
@@ -407,13 +417,16 @@ share/doc/postgresql/html/mvcc.html
share/doc/postgresql/html/nls-programmer.html
share/doc/postgresql/html/nls-translator.html
share/doc/postgresql/html/nls.html
+share/doc/postgresql/html/non-durability.html
share/doc/postgresql/html/notation.html
share/doc/postgresql/html/oid2name.html
share/doc/postgresql/html/overview.html
share/doc/postgresql/html/pageinspect.html
share/doc/postgresql/html/parser-stage.html
+share/doc/postgresql/html/passwordcheck.html
share/doc/postgresql/html/performance-tips.html
share/doc/postgresql/html/perm-functions.html
+share/doc/postgresql/html/pgarchivecleanup.html
share/doc/postgresql/html/pgbench.html
share/doc/postgresql/html/pgbuffercache.html
share/doc/postgresql/html/pgcrypto.html
@@ -423,17 +436,18 @@ share/doc/postgresql/html/pgstandby.html
share/doc/postgresql/html/pgstatstatements.html
share/doc/postgresql/html/pgstattuple.html
share/doc/postgresql/html/pgtrgm.html
+share/doc/postgresql/html/pgupgrade.html
share/doc/postgresql/html/planner-optimizer.html
share/doc/postgresql/html/planner-stats-details.html
share/doc/postgresql/html/planner-stats.html
share/doc/postgresql/html/plhandler.html
+share/doc/postgresql/html/plperl-builtins.html
share/doc/postgresql/html/plperl-data.html
-share/doc/postgresql/html/plperl-database.html
share/doc/postgresql/html/plperl-funcs.html
share/doc/postgresql/html/plperl-global.html
-share/doc/postgresql/html/plperl-missing.html
share/doc/postgresql/html/plperl-triggers.html
share/doc/postgresql/html/plperl-trusted.html
+share/doc/postgresql/html/plperl-under-the-hood.html
share/doc/postgresql/html/plperl.html
share/doc/postgresql/html/plpgsql-control-structures.html
share/doc/postgresql/html/plpgsql-cursors.html
@@ -448,9 +462,15 @@ share/doc/postgresql/html/plpgsql-statem
share/doc/postgresql/html/plpgsql-structure.html
share/doc/postgresql/html/plpgsql-trigger.html
share/doc/postgresql/html/plpgsql.html
+share/doc/postgresql/html/plpython-data.html
share/doc/postgresql/html/plpython-database.html
+share/doc/postgresql/html/plpython-do.html
+share/doc/postgresql/html/plpython-envar.html
share/doc/postgresql/html/plpython-funcs.html
+share/doc/postgresql/html/plpython-python23.html
+share/doc/postgresql/html/plpython-sharing.html
share/doc/postgresql/html/plpython-trigger.html
+share/doc/postgresql/html/plpython-util.html
share/doc/postgresql/html/plpython.html
share/doc/postgresql/html/pltcl-data.html
share/doc/postgresql/html/pltcl-dbaccess.html
@@ -472,6 +492,7 @@ share/doc/postgresql/html/protocol-flow.
share/doc/postgresql/html/protocol-message-formats.html
share/doc/postgresql/html/protocol-message-types.html
share/doc/postgresql/html/protocol-overview.html
+share/doc/postgresql/html/protocol-replication.html
share/doc/postgresql/html/protocol.html
share/doc/postgresql/html/queries-limit.html
share/doc/postgresql/html/queries-order.html
@@ -484,6 +505,8 @@ share/doc/postgresql/html/queries-with.h
share/doc/postgresql/html/queries.html
share/doc/postgresql/html/query-path.html
share/doc/postgresql/html/querytree.html
+share/doc/postgresql/html/recovery-config.html
+share/doc/postgresql/html/recovery-target-settings.html
share/doc/postgresql/html/reference-client.html
share/doc/postgresql/html/reference-server.html
share/doc/postgresql/html/reference.html
@@ -672,6 +695,8 @@ share/doc/postgresql/html/release-8-4-3.
share/doc/postgresql/html/release-8-4-4.html
share/doc/postgresql/html/release-8-4-5.html
share/doc/postgresql/html/release-8-4.html
+share/doc/postgresql/html/release-9-0-1.html
+share/doc/postgresql/html/release-9-0.html
share/doc/postgresql/html/release.html
share/doc/postgresql/html/resources.html
share/doc/postgresql/html/role-attributes.html
@@ -723,9 +748,11 @@ share/doc/postgresql/html/spi-spi-cursor
share/doc/postgresql/html/spi-spi-cursor-find.html
share/doc/postgresql/html/spi-spi-cursor-move.html
share/doc/postgresql/html/spi-spi-cursor-open-with-args.html
+share/doc/postgresql/html/spi-spi-cursor-open-with-paramlist.html
share/doc/postgresql/html/spi-spi-cursor-open.html
share/doc/postgresql/html/spi-spi-exec.html
share/doc/postgresql/html/spi-spi-execp.html
+share/doc/postgresql/html/spi-spi-execute-plan-with-paramlist.html
share/doc/postgresql/html/spi-spi-execute-plan.html
share/doc/postgresql/html/spi-spi-execute-with-args.html
share/doc/postgresql/html/spi-spi-execute.html
@@ -749,6 +776,7 @@ share/doc/postgresql/html/spi-spi-palloc
share/doc/postgresql/html/spi-spi-pfree.html
share/doc/postgresql/html/spi-spi-pop.html
share/doc/postgresql/html/spi-spi-prepare-cursor.html
+share/doc/postgresql/html/spi-spi-prepare-params.html
share/doc/postgresql/html/spi-spi-prepare.html
share/doc/postgresql/html/spi-spi-push.html
share/doc/postgresql/html/spi-spi-returntuple.html
@@ -761,12 +789,14 @@ share/doc/postgresql/html/sql-abort.html
share/doc/postgresql/html/sql-alteraggregate.html
share/doc/postgresql/html/sql-alterconversion.html
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-alterforeigndatawrapper.html
share/doc/postgresql/html/sql-alterfunction.html
share/doc/postgresql/html/sql-altergroup.html
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-alteropclass.html
share/doc/postgresql/html/sql-alteroperator.html
share/doc/postgresql/html/sql-alteropfamily.html
@@ -830,6 +860,7 @@ share/doc/postgresql/html/sql-deallocate
share/doc/postgresql/html/sql-declare.html
share/doc/postgresql/html/sql-delete.html
share/doc/postgresql/html/sql-discard.html
+share/doc/postgresql/html/sql-do.html
share/doc/postgresql/html/sql-drop-owned.html
share/doc/postgresql/html/sql-dropaggregate.html
share/doc/postgresql/html/sql-dropcast.html
@@ -893,6 +924,7 @@ share/doc/postgresql/html/sql-set-transa
share/doc/postgresql/html/sql-set.html
share/doc/postgresql/html/sql-show.html
share/doc/postgresql/html/sql-start-transaction.html
+share/doc/postgresql/html/sql-syntax-calling-funcs.html
share/doc/postgresql/html/sql-syntax-lexical.html
share/doc/postgresql/html/sql-syntax.html
share/doc/postgresql/html/sql-truncate.html
@@ -904,6 +936,7 @@ share/doc/postgresql/html/sql.html
share/doc/postgresql/html/ssh-tunnels.html
share/doc/postgresql/html/ssl-tcp.html
share/doc/postgresql/html/sslinfo.html
+share/doc/postgresql/html/standby-settings.html
share/doc/postgresql/html/storage-file-layout.html
share/doc/postgresql/html/storage-fsm.html
share/doc/postgresql/html/storage-page-layout.html
@@ -964,6 +997,7 @@ share/doc/postgresql/html/typeconv-overv
share/doc/postgresql/html/typeconv-query.html
share/doc/postgresql/html/typeconv-union-case.html
share/doc/postgresql/html/typeconv.html
+share/doc/postgresql/html/unaccent.html
share/doc/postgresql/html/unsupported-features-sql-standard.html
share/doc/postgresql/html/user-manag.html
share/doc/postgresql/html/using-explain.html
@@ -993,6 +1027,7 @@ share/doc/postgresql/html/wal-internals.
share/doc/postgresql/html/wal-intro.html
share/doc/postgresql/html/wal-reliability.html
share/doc/postgresql/html/wal.html
+share/doc/postgresql/html/warm-standby-failover.html
share/doc/postgresql/html/warm-standby.html
share/doc/postgresql/html/xaggr.html
share/doc/postgresql/html/xfunc-c.html
Index: pkg/PLIST-main
===================================================================
RCS file: /cvs/ports/databases/postgresql/pkg/PLIST-main,v
retrieving revision 1.18
diff -u -p -r1.18 PLIST-main
--- pkg/PLIST-main 8 Oct 2010 06:50:23 -0000 1.18
+++ pkg/PLIST-main 3 Nov 2010 12:35:14 -0000
@@ -28,7 +28,6 @@ include/postgresql/informix/
include/postgresql/informix/esql/
include/postgresql/informix/esql/datetime.h
include/postgresql/informix/esql/decimal.h
-include/postgresql/informix/esql/sqlda.h
include/postgresql/informix/esql/sqltypes.h
include/postgresql/internal/
include/postgresql/internal/c.h
@@ -53,6 +52,9 @@ include/postgresql/pgtypes_timestamp.h
include/postgresql/postgres_ext.h
include/postgresql/sql3types.h
include/postgresql/sqlca.h
+include/postgresql/sqlda-compat.h
+include/postgresql/sqlda-native.h
+include/postgresql/sqlda.h
lib/libecpg.a
@comment lib/libecpg.so
@comment lib/libecpg.so.7
@@ -74,7 +76,6 @@ lib/postgresql/
lib/postgresql/pgxs/
lib/postgresql/pgxs/config/
lib/postgresql/pgxs/config/install-sh
-lib/postgresql/pgxs/config/mkinstalldirs
lib/postgresql/pgxs/src/
lib/postgresql/pgxs/src/Makefile.global
lib/postgresql/pgxs/src/Makefile.port
@@ -100,146 +101,211 @@ lib/postgresql/pgxs/src/test/regress/
@man man/man1/psql.1
@man man/man1/reindexdb.1
@man man/man1/vacuumdb.1
-...@man man/man7/abort.7
-...@man man/man7/alter_aggregate.7
-...@man man/man7/alter_conversion.7
-...@man man/man7/alter_database.7
-...@man man/man7/alter_domain.7
-...@man man/man7/alter_foreign_data_wrapper.7
-...@man man/man7/alter_function.7
-...@man man/man7/alter_group.7
-...@man man/man7/alter_index.7
-...@man man/man7/alter_language.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_schema.7
-...@man man/man7/alter_sequence.7
-...@man man/man7/alter_server.7
-...@man man/man7/alter_table.7
-...@man man/man7/alter_tablespace.7
-...@man man/man7/alter_text_search_configuration.7
-...@man man/man7/alter_text_search_dictionary.7
-...@man man/man7/alter_text_search_parser.7
-...@man man/man7/alter_text_search_template.7
-...@man man/man7/alter_trigger.7
-...@man man/man7/alter_type.7
-...@man man/man7/alter_user.7
-...@man man/man7/alter_user_mapping.7
-...@man man/man7/alter_view.7
-...@man man/man7/analyze.7
-...@man man/man7/begin.7
-...@man man/man7/checkpoint.7
-...@man man/man7/close.7
-...@man man/man7/cluster.7
-...@man man/man7/comment.7
-...@man man/man7/commit.7
-...@man man/man7/commit_prepared.7
-...@man man/man7/copy.7
-...@man man/man7/create_aggregate.7
-...@man man/man7/create_cast.7
-...@man man/man7/create_constraint_trigger.7
-...@man man/man7/create_conversion.7
-...@man man/man7/create_database.7
-...@man man/man7/create_domain.7
-...@man man/man7/create_foreign_data_wrapper.7
-...@man man/man7/create_function.7
-...@man man/man7/create_group.7
-...@man man/man7/create_index.7
-...@man man/man7/create_language.7
-...@man man/man7/create_operator.7
-...@man man/man7/create_operator_class.7
-...@man man/man7/create_operator_family.7
-...@man man/man7/create_role.7
-...@man man/man7/create_rule.7
-...@man man/man7/create_schema.7
-...@man man/man7/create_sequence.7
-...@man man/man7/create_server.7
-...@man man/man7/create_table.7
-...@man man/man7/create_table_as.7
-...@man man/man7/create_tablespace.7
-...@man man/man7/create_text_search_configuration.7
-...@man man/man7/create_text_search_dictionary.7
-...@man man/man7/create_text_search_parser.7
-...@man man/man7/create_text_search_template.7
-...@man man/man7/create_trigger.7
-...@man man/man7/create_type.7
-...@man man/man7/create_user.7
-...@man man/man7/create_user_mapping.7
-...@man man/man7/create_view.7
-...@man man/man7/deallocate.7
-...@man man/man7/declare.7
-...@man man/man7/delete.7
-...@man man/man7/discard.7
-...@man man/man7/drop_aggregate.7
-...@man man/man7/drop_cast.7
-...@man man/man7/drop_conversion.7
-...@man man/man7/drop_database.7
-...@man man/man7/drop_domain.7
-...@man man/man7/drop_foreign_data_wrapper.7
-...@man man/man7/drop_function.7
-...@man man/man7/drop_group.7
-...@man man/man7/drop_index.7
-...@man man/man7/drop_language.7
-...@man man/man7/drop_operator.7
-...@man man/man7/drop_operator_class.7
-...@man man/man7/drop_operator_family.7
-...@man man/man7/drop_owned.7
-...@man man/man7/drop_role.7
-...@man man/man7/drop_rule.7
-...@man man/man7/drop_schema.7
-...@man man/man7/drop_sequence.7
-...@man man/man7/drop_server.7
-...@man man/man7/drop_table.7
-...@man man/man7/drop_tablespace.7
-...@man man/man7/drop_text_search_configuration.7
-...@man man/man7/drop_text_search_dictionary.7
-...@man man/man7/drop_text_search_parser.7
-...@man man/man7/drop_text_search_template.7
-...@man man/man7/drop_trigger.7
-...@man man/man7/drop_type.7
-...@man man/man7/drop_user.7
-...@man man/man7/drop_user_mapping.7
-...@man man/man7/drop_view.7
-...@man man/man7/end.7
-...@man man/man7/execute.7
-...@man man/man7/explain.7
-...@man man/man7/fetch.7
-...@man man/man7/grant.7
-...@man man/man7/insert.7
-...@man man/man7/listen.7
-...@man man/man7/load.7
-...@man man/man7/lock.7
-...@man man/man7/move.7
-...@man man/man7/notify.7
-...@man man/man7/prepare.7
-...@man man/man7/prepare_transaction.7
-...@man man/man7/reassign_owned.7
-...@man man/man7/reindex.7
-...@man man/man7/release_savepoint.7
-...@man man/man7/reset.7
-...@man man/man7/revoke.7
-...@man man/man7/rollback.7
-...@man man/man7/rollback_prepared.7
-...@man man/man7/rollback_to_savepoint.7
-...@man man/man7/savepoint.7
-...@man man/man7/select.7
-...@man man/man7/select_into.7
-...@man man/man7/set.7
-...@man man/man7/set_constraints.7
-...@man man/man7/set_role.7
-...@man man/man7/set_session_authorization.7
-...@man man/man7/set_transaction.7
-...@man man/man7/show.7
-...@man man/man7/start_transaction.7
-...@man man/man7/table.7
-...@man man/man7/truncate.7
-...@man man/man7/unlisten.7
-...@man man/man7/update.7
-...@man man/man7/vacuum.7
-...@man man/man7/values.7
-...@man man/man7/with.7
+...@man man/man3/SPI_connect.3
+...@man man/man3/SPI_copytuple.3
+...@man man/man3/SPI_cursor_close.3
+...@man man/man3/SPI_cursor_fetch.3
+...@man man/man3/SPI_cursor_find.3
+...@man man/man3/SPI_cursor_move.3
+...@man man/man3/SPI_cursor_open.3
+...@man man/man3/SPI_cursor_open_with_args.3
+...@man man/man3/SPI_cursor_open_with_paramlist.3
+...@man man/man3/SPI_exec.3
+...@man man/man3/SPI_execp.3
+...@man man/man3/SPI_execute.3
+...@man man/man3/SPI_execute_plan.3
+...@man man/man3/SPI_execute_plan_with_paramlist.3
+...@man man/man3/SPI_execute_with_args.3
+...@man man/man3/SPI_finish.3
+...@man man/man3/SPI_fname.3
+...@man man/man3/SPI_fnumber.3
+...@man man/man3/SPI_freeplan.3
+...@man man/man3/SPI_freetuple.3
+...@man man/man3/SPI_freetuptable.3
+...@man man/man3/SPI_getargcount.3
+...@man man/man3/SPI_getargtypeid.3
+...@man man/man3/SPI_getbinval.3
+...@man man/man3/SPI_getnspname.3
+...@man man/man3/SPI_getrelname.3
+...@man man/man3/SPI_gettype.3
+...@man man/man3/SPI_gettypeid.3
+...@man man/man3/SPI_getvalue.3
+...@man man/man3/SPI_is_cursor_plan.3
+...@man man/man3/SPI_modifytuple.3
+...@man man/man3/SPI_palloc.3
+...@man man/man3/SPI_pfree.3
+...@man man/man3/SPI_pop.3
+...@man man/man3/SPI_prepare.3
+...@man man/man3/SPI_prepare_cursor.3
+...@man man/man3/SPI_prepare_params.3
+...@man man/man3/SPI_push.3
+...@man man/man3/SPI_repalloc.3
+...@man man/man3/SPI_returntuple.3
+...@man man/man3/SPI_saveplan.3
+...@man man/man3/SPI_scroll_cursor_fetch.3
+...@man man/man3/SPI_scroll_cursor_move.3
+...@man man/man3/dblink.3
+...@man man/man3/dblink_build_sql_delete.3
+...@man man/man3/dblink_build_sql_insert.3
+...@man man/man3/dblink_build_sql_update.3
+...@man man/man3/dblink_cancel_query.3
+...@man man/man3/dblink_close.3
+...@man man/man3/dblink_connect.3
+...@man man/man3/dblink_connect_u.3
+...@man man/man3/dblink_disconnect.3
+...@man man/man3/dblink_error_message.3
+...@man man/man3/dblink_exec.3
+...@man man/man3/dblink_fetch.3
+...@man man/man3/dblink_get_connections.3
+...@man man/man3/dblink_get_notify.3
+...@man man/man3/dblink_get_pkey.3
+...@man man/man3/dblink_get_result.3
+...@man man/man3/dblink_is_busy.3
+...@man man/man3/dblink_open.3
+...@man man/man3/dblink_send_query.3
+...@man man/man7/ABORT.7
+...@man man/man7/ALTER_AGGREGATE.7
+...@man man/man7/ALTER_CONVERSION.7
+...@man man/man7/ALTER_DATABASE.7
+...@man man/man7/ALTER_DEFAULT_PRIVILEGES.7
+...@man man/man7/ALTER_DOMAIN.7
+...@man man/man7/ALTER_FOREIGN_DATA_WRAPPER.7
+...@man man/man7/ALTER_FUNCTION.7
+...@man man/man7/ALTER_GROUP.7
+...@man man/man7/ALTER_INDEX.7
+...@man man/man7/ALTER_LANGUAGE.7
+...@man man/man7/ALTER_LARGE_OBJECT.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_SCHEMA.7
+...@man man/man7/ALTER_SEQUENCE.7
+...@man man/man7/ALTER_SERVER.7
+...@man man/man7/ALTER_TABLE.7
+...@man man/man7/ALTER_TABLESPACE.7
+...@man man/man7/ALTER_TEXT_SEARCH_CONFIGURATION.7
+...@man man/man7/ALTER_TEXT_SEARCH_DICTIONARY.7
+...@man man/man7/ALTER_TEXT_SEARCH_PARSER.7
+...@man man/man7/ALTER_TEXT_SEARCH_TEMPLATE.7
+...@man man/man7/ALTER_TRIGGER.7
+...@man man/man7/ALTER_TYPE.7
+...@man man/man7/ALTER_USER.7
+...@man man/man7/ALTER_USER_MAPPING.7
+...@man man/man7/ALTER_VIEW.7
+...@man man/man7/ANALYZE.7
+...@man man/man7/BEGIN.7
+...@man man/man7/CHECKPOINT.7
+...@man man/man7/CLOSE.7
+...@man man/man7/CLUSTER.7
+...@man man/man7/COMMENT.7
+...@man man/man7/COMMIT.7
+...@man man/man7/COMMIT_PREPARED.7
+...@man man/man7/COPY.7
+...@man man/man7/CREATE_AGGREGATE.7
+...@man man/man7/CREATE_CAST.7
+...@man man/man7/CREATE_CONSTRAINT_TRIGGER.7
+...@man man/man7/CREATE_CONVERSION.7
+...@man man/man7/CREATE_DATABASE.7
+...@man man/man7/CREATE_DOMAIN.7
+...@man man/man7/CREATE_FOREIGN_DATA_WRAPPER.7
+...@man man/man7/CREATE_FUNCTION.7
+...@man man/man7/CREATE_GROUP.7
+...@man man/man7/CREATE_INDEX.7
+...@man man/man7/CREATE_LANGUAGE.7
+...@man man/man7/CREATE_OPERATOR.7
+...@man man/man7/CREATE_OPERATOR_CLASS.7
+...@man man/man7/CREATE_OPERATOR_FAMILY.7
+...@man man/man7/CREATE_ROLE.7
+...@man man/man7/CREATE_RULE.7
+...@man man/man7/CREATE_SCHEMA.7
+...@man man/man7/CREATE_SEQUENCE.7
+...@man man/man7/CREATE_SERVER.7
+...@man man/man7/CREATE_TABLE.7
+...@man man/man7/CREATE_TABLESPACE.7
+...@man man/man7/CREATE_TABLE_AS.7
+...@man man/man7/CREATE_TEXT_SEARCH_CONFIGURATION.7
+...@man man/man7/CREATE_TEXT_SEARCH_DICTIONARY.7
+...@man man/man7/CREATE_TEXT_SEARCH_PARSER.7
+...@man man/man7/CREATE_TEXT_SEARCH_TEMPLATE.7
+...@man man/man7/CREATE_TRIGGER.7
+...@man man/man7/CREATE_TYPE.7
+...@man man/man7/CREATE_USER.7
+...@man man/man7/CREATE_USER_MAPPING.7
+...@man man/man7/CREATE_VIEW.7
+...@man man/man7/DEALLOCATE.7
+...@man man/man7/DECLARE.7
+...@man man/man7/DELETE.7
+...@man man/man7/DISCARD.7
+...@man man/man7/DO.7
+...@man man/man7/DROP_AGGREGATE.7
+...@man man/man7/DROP_CAST.7
+...@man man/man7/DROP_CONVERSION.7
+...@man man/man7/DROP_DATABASE.7
+...@man man/man7/DROP_DOMAIN.7
+...@man man/man7/DROP_FOREIGN_DATA_WRAPPER.7
+...@man man/man7/DROP_FUNCTION.7
+...@man man/man7/DROP_GROUP.7
+...@man man/man7/DROP_INDEX.7
+...@man man/man7/DROP_LANGUAGE.7
+...@man man/man7/DROP_OPERATOR.7
+...@man man/man7/DROP_OPERATOR_CLASS.7
+...@man man/man7/DROP_OPERATOR_FAMILY.7
+...@man man/man7/DROP_OWNED.7
+...@man man/man7/DROP_ROLE.7
+...@man man/man7/DROP_RULE.7
+...@man man/man7/DROP_SCHEMA.7
+...@man man/man7/DROP_SEQUENCE.7
+...@man man/man7/DROP_SERVER.7
+...@man man/man7/DROP_TABLE.7
+...@man man/man7/DROP_TABLESPACE.7
+...@man man/man7/DROP_TEXT_SEARCH_CONFIGURATION.7
+...@man man/man7/DROP_TEXT_SEARCH_DICTIONARY.7
+...@man man/man7/DROP_TEXT_SEARCH_PARSER.7
+...@man man/man7/DROP_TEXT_SEARCH_TEMPLATE.7
+...@man man/man7/DROP_TRIGGER.7
+...@man man/man7/DROP_TYPE.7
+...@man man/man7/DROP_USER.7
+...@man man/man7/DROP_USER_MAPPING.7
+...@man man/man7/DROP_VIEW.7
+...@man man/man7/END.7
+...@man man/man7/EXECUTE.7
+...@man man/man7/EXPLAIN.7
+...@man man/man7/FETCH.7
+...@man man/man7/GRANT.7
+...@man man/man7/INSERT.7
+...@man man/man7/LISTEN.7
+...@man man/man7/LOAD.7
+...@man man/man7/LOCK.7
+...@man man/man7/MOVE.7
+...@man man/man7/NOTIFY.7
+...@man man/man7/PREPARE.7
+...@man man/man7/PREPARE_TRANSACTION.7
+...@man man/man7/REASSIGN_OWNED.7
+...@man man/man7/REINDEX.7
+...@man man/man7/RELEASE_SAVEPOINT.7
+...@man man/man7/RESET.7
+...@man man/man7/REVOKE.7
+...@man man/man7/ROLLBACK.7
+...@man man/man7/ROLLBACK_PREPARED.7
+...@man man/man7/ROLLBACK_TO_SAVEPOINT.7
+...@man man/man7/SAVEPOINT.7
+...@man man/man7/SELECT.7
+...@man man/man7/SELECT_INTO.7
+...@man man/man7/SET.7
+...@man man/man7/SET_CONSTRAINTS.7
+...@man man/man7/SET_ROLE.7
+...@man man/man7/SET_SESSION_AUTHORIZATION.7
+...@man man/man7/SET_TRANSACTION.7
+...@man man/man7/SHOW.7
+...@man man/man7/START_TRANSACTION.7
+...@man man/man7/TABLE.7
+...@man man/man7/TRUNCATE.7
+...@man man/man7/UNLISTEN.7
+...@man man/man7/UPDATE.7
+...@man man/man7/VACUUM.7
+...@man man/man7/VALUES.7
+...@man man/man7/WITH.7
share/postgresql/
share/postgresql/conversion_create.sql
share/postgresql/information_schema.sql
Index: pkg/PLIST-server
===================================================================
RCS file: /cvs/ports/databases/postgresql/pkg/PLIST-server,v
retrieving revision 1.18
diff -u -p -r1.18 PLIST-server
--- pkg/PLIST-server 23 Mar 2010 10:24:45 -0000 1.18
+++ pkg/PLIST-server 3 Nov 2010 12:35:14 -0000
@@ -4,6 +4,7 @@
@conflict postgresql-clients-*
@conflict postgresql-server-*
@conflict postgresql-*
+...@ask-update postgresql-server-<9 Make sure your existing database is backed
up
@newgroup _postgresql:503
@newuser _postgresql:503:_postgresql:daemon:PostgreSQL
Manager:/var/postgresql:/bin/sh
@bin bin/initdb
@@ -39,6 +40,7 @@ include/postgresql/server/access/slru.h
include/postgresql/server/access/subtrans.h
include/postgresql/server/access/sysattr.h
include/postgresql/server/access/transam.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
@@ -78,6 +80,8 @@ include/postgresql/server/catalog/pg_con
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
@@ -88,7 +92,7 @@ include/postgresql/server/catalog/pg_inh
include/postgresql/server/catalog/pg_inherits_fn.h
include/postgresql/server/catalog/pg_language.h
include/postgresql/server/catalog/pg_largeobject.h
-include/postgresql/server/catalog/pg_listener.h
+include/postgresql/server/catalog/pg_largeobject_metadata.h
include/postgresql/server/catalog/pg_namespace.h
include/postgresql/server/catalog/pg_opclass.h
include/postgresql/server/catalog/pg_operator.h
@@ -110,6 +114,7 @@ include/postgresql/server/catalog/pg_ts_
include/postgresql/server/catalog/pg_type.h
include/postgresql/server/catalog/pg_type_fn.h
include/postgresql/server/catalog/pg_user_mapping.h
+include/postgresql/server/catalog/schemapg.h
include/postgresql/server/catalog/storage.h
include/postgresql/server/catalog/toasting.h
include/postgresql/server/commands/
@@ -136,7 +141,6 @@ include/postgresql/server/commands/typec
include/postgresql/server/commands/user.h
include/postgresql/server/commands/vacuum.h
include/postgresql/server/commands/variable.h
-include/postgresql/server/commands/version.h
include/postgresql/server/commands/view.h
include/postgresql/server/dynloader.h
include/postgresql/server/executor/
@@ -160,8 +164,10 @@ include/postgresql/server/executor/nodeH
include/postgresql/server/executor/nodeHashjoin.h
include/postgresql/server/executor/nodeIndexscan.h
include/postgresql/server/executor/nodeLimit.h
+include/postgresql/server/executor/nodeLockRows.h
include/postgresql/server/executor/nodeMaterial.h
include/postgresql/server/executor/nodeMergejoin.h
+include/postgresql/server/executor/nodeModifyTable.h
include/postgresql/server/executor/nodeNestloop.h
include/postgresql/server/executor/nodeRecursiveunion.h
include/postgresql/server/executor/nodeResult.h
@@ -260,12 +266,14 @@ include/postgresql/server/parser/parse_e
include/postgresql/server/parser/parse_func.h
include/postgresql/server/parser/parse_node.h
include/postgresql/server/parser/parse_oper.h
+include/postgresql/server/parser/parse_param.h
include/postgresql/server/parser/parse_relation.h
include/postgresql/server/parser/parse_target.h
include/postgresql/server/parser/parse_type.h
include/postgresql/server/parser/parse_utilcmd.h
include/postgresql/server/parser/parser.h
include/postgresql/server/parser/parsetree.h
+include/postgresql/server/parser/scanner.h
include/postgresql/server/parser/scansup.h
include/postgresql/server/pg_config.h
include/postgresql/server/pg_config_manual.h
@@ -334,6 +342,10 @@ include/postgresql/server/regex/regcusto
include/postgresql/server/regex/regerrs.h
include/postgresql/server/regex/regex.h
include/postgresql/server/regex/regguts.h
+include/postgresql/server/replication/
+include/postgresql/server/replication/walprotocol.h
+include/postgresql/server/replication/walreceiver.h
+include/postgresql/server/replication/walsender.h
include/postgresql/server/rewrite/
include/postgresql/server/rewrite/prs2lock.h
include/postgresql/server/rewrite/rewriteDefine.h
@@ -405,6 +417,7 @@ include/postgresql/server/storage/pmsign
include/postgresql/server/storage/pos.h
include/postgresql/server/storage/proc.h
include/postgresql/server/storage/procarray.h
+include/postgresql/server/storage/procsignal.h
include/postgresql/server/storage/relfilenode.h
include/postgresql/server/storage/s_lock.h
include/postgresql/server/storage/shmem.h
@@ -412,6 +425,7 @@ include/postgresql/server/storage/sinval
include/postgresql/server/storage/sinvaladt.h
include/postgresql/server/storage/smgr.h
include/postgresql/server/storage/spin.h
+include/postgresql/server/storage/standby.h
include/postgresql/server/tcop/
include/postgresql/server/tcop/dest.h
include/postgresql/server/tcop/fastpath.h
@@ -432,7 +446,9 @@ include/postgresql/server/utils/
include/postgresql/server/utils/acl.h
include/postgresql/server/utils/array.h
include/postgresql/server/utils/ascii.h
+include/postgresql/server/utils/attoptcache.h
include/postgresql/server/utils/builtins.h
+include/postgresql/server/utils/bytea.h
include/postgresql/server/utils/cash.h
include/postgresql/server/utils/catcache.h
include/postgresql/server/utils/combocid.h
@@ -443,7 +459,6 @@ 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/flatfiles.h
include/postgresql/server/utils/fmgroids.h
include/postgresql/server/utils/fmgrtab.h
include/postgresql/server/utils/formatting.h
@@ -469,12 +484,15 @@ include/postgresql/server/utils/plancach
include/postgresql/server/utils/portal.h
include/postgresql/server/utils/probes.h
include/postgresql/server/utils/ps_status.h
+include/postgresql/server/utils/rbtree.h
include/postgresql/server/utils/rel.h
include/postgresql/server/utils/relcache.h
+include/postgresql/server/utils/relmapper.h
include/postgresql/server/utils/resowner.h
include/postgresql/server/utils/selfuncs.h
include/postgresql/server/utils/snapmgr.h
include/postgresql/server/utils/snapshot.h
+include/postgresql/server/utils/spccache.h
include/postgresql/server/utils/syscache.h
include/postgresql/server/utils/timestamp.h
include/postgresql/server/utils/tqual.h
@@ -491,22 +509,25 @@ lib/postgresql/cyrillic_and_mic.so
lib/postgresql/dict_int.so
lib/postgresql/dict_snowball.so
lib/postgresql/dict_xsyn.so
+lib/postgresql/euc2004_sjis2004.so
lib/postgresql/euc_cn_and_mic.so
-lib/postgresql/euc_jis_2004_and_shift_jis_2004.so
lib/postgresql/euc_jp_and_sjis.so
lib/postgresql/euc_kr_and_mic.so
lib/postgresql/euc_tw_and_big5.so
lib/postgresql/latin2_and_win1250.so
lib/postgresql/latin_and_mic.so
+lib/postgresql/libpqwalreceiver.so
lib/postgresql/pageinspect.so
+lib/postgresql/passwordcheck.so
lib/postgresql/plperl.so
lib/postgresql/plpgsql.so
lib/postgresql/test_parser.so
+lib/postgresql/unaccent.so
lib/postgresql/utf8_and_ascii.so
lib/postgresql/utf8_and_big5.so
lib/postgresql/utf8_and_cyrillic.so
+lib/postgresql/utf8_and_euc2004.so
lib/postgresql/utf8_and_euc_cn.so
-lib/postgresql/utf8_and_euc_jis_2004.so
lib/postgresql/utf8_and_euc_jp.so
lib/postgresql/utf8_and_euc_kr.so
lib/postgresql/utf8_and_euc_tw.so
@@ -515,8 +536,8 @@ lib/postgresql/utf8_and_gbk.so
lib/postgresql/utf8_and_iso8859.so
lib/postgresql/utf8_and_iso8859_1.so
lib/postgresql/utf8_and_johab.so
-lib/postgresql/utf8_and_shift_jis_2004.so
lib/postgresql/utf8_and_sjis.so
+lib/postgresql/utf8_and_sjis2004.so
lib/postgresql/utf8_and_uhc.so
lib/postgresql/utf8_and_win.so
@man man/man1/initdb.1
@@ -525,8 +546,7 @@ lib/postgresql/utf8_and_win.so
@man man/man1/pg_resetxlog.1
@man man/man1/postgres.1
@man man/man1/postmaster.1
-share/doc/postgresql/
-share/doc/postgresql/README.OpenBSD
+share/doc/pkg-readmes/postgresql-server-${VERSION}
share/postgresql/pg_hba.conf.sample
share/postgresql/pg_ident.conf.sample
share/postgresql/pg_service.conf.sample
@@ -553,7 +573,9 @@ share/postgresql/tsearch_data/swedish.st
share/postgresql/tsearch_data/synonym_sample.syn
share/postgresql/tsearch_data/thesaurus_sample.ths
share/postgresql/tsearch_data/turkish.stop
+share/postgresql/tsearch_data/unaccent.rules
share/postgresql/tsearch_data/xsyn_sample.rules
+...@rcscript ${RCDIR}/postgresql
@mode 755
@owner _postgresql
@group _postgresql
Index: pkg/README-server
===================================================================
RCS file: pkg/README-server
diff -N pkg/README-server
--- /dev/null 1 Jan 1970 00:00:00 -0000
+++ pkg/README-server 3 Nov 2010 12:35:14 -0000
@@ -0,0 +1,99 @@
+Using PostgreSQL in an OpenBSD environment
+
+At least two different accounts are involved when working with PostgreSQL:
+One is an OpenBSD userid, '_postgresql', which is used as the userid of files
+that are part of PostgreSQL. The other, usually named 'postgres', is not an
+OpenBSD userid, i.e. you will not find it in /etc/passwd, but an account
+internal to the database system. The 'postgres' account is called the dba
+account (database administrator) and is created when a new database is
+initialized using the initdb command.
+
+If you are installing PostgreSQL for the first time, you have to create
+a default database first. In the following example we install a database
+in /var/postgresql/data with a dba account 'postgres' and md5 authentication.
+We will be prompted for a password to protect the dba account:
+
+ # su - _postgresql
+ $ mkdir /var/postgresql/data
+ $ initdb -D /var/postgresql/data -U postgres -A md5 -W
+
+It is strongly advised that you do not work with the postgres dba account
+other than creating more users and/or databases or for administrative task.
+Use the PostgreSQL permission system to make sure that a database is only
+accessed by programs/users that have the right to do so.
+
+Please consult the PostgreSQL website for more information, especially when
+you are upgrading an existing database installation.
+
+
+Network Connections and Tuning
+
+To allow connections over TCP (and other options) edit the file:
+
+ /var/postgresql/data/postgresql.conf
+
+and also edit the pg_hba.conf (in the same directory) making the
+appropriate changes to allow connection from your network.
+
+The default sizes in the GENERIC kernel for SysV semaphores
+are not really large enough for a database with more than a
+handful of connections. A server running such a database should
+have at least the following in /etc/sysctl.conf:
+
+ kern.seminfo.semmni=256
+ kern.seminfo.semmns=2048
+
+To serve a large number of connections (>250), you may also need
+to increase the maximum shared memory segment size, on the i386
+try:
+
+ 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 values 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,
+it may be advisable to put the _postgresql user and processes in
+their own login(1) class with tuned resources, such as more open
+file descriptors etc.
+
+For example, add this to the login.conf(5) file:
+
+ postgresql:\
+ :openfiles-cur=768:\
+ :tc=daemon:
+
+Rebuild the login.conf.db file if necessary:
+
+ # cap_mkdb /etc/login.conf
+
+Change the login class with either vipw(8) or chsh(8).
+
+For more than about 250 connections, these numbers should be
+increased. Please report any changes and experiences to the package
+maintainers so that we can update this file for future versions.
+
+Kerberos authentication
+
+By default the postgresql server requires it's own krb5.keytab file. It
+should be readable only by the _postgresql user. The default location of
+the file is '/etc/postgresql/krb5.keytab' but is tunable by setting the
+krb_server_keyfile line in postgresql.conf.
+
+To generate the keytab:
+
+ # mkdir /etc/postgresql
+ # ktutil -k /etc/postgresql/krb5.keytab get postgres/server.domain
+ # chown _postgresql:_postgresql /etc/postgresql/krb5.keytab
+
+Clients/Frontends
+
+Many applications can use the PostgreSQL database right away. To facilitate
+administration of a PostgreSQL database, two clients are notable:
+
+www/phppgadmin A web based user interface that uses PHP5
+databases/pgadmin3 A graphical user interface that uses wxWidgets
Index: pkg/postgresql.rc
===================================================================
RCS file: pkg/postgresql.rc
diff -N pkg/postgresql.rc
--- /dev/null 1 Jan 1970 00:00:00 -0000
+++ pkg/postgresql.rc 3 Nov 2010 12:35:14 -0000
@@ -0,0 +1,23 @@
+#!/bin/sh
+#
+# $OpenBSD$
+
+. /etc/rc.d/rc.subr
+
+daemon="${TRUEPREFIX}/bin/postgres"
+bin="${TRUEPREFIX}/bin/pg_ctl"
+datadir="/var/postgresql/data"
+
+rc_start() {
+ /usr/bin/su -l _postgresql -c \
+ "${bin} -D ${datadir} start -l /var/postgresql/logfile" \
+ >/dev/null 2>&1
+}
+
+rc_stop() {
+ /usr/bin/su -l _postgresql -c \
+ "${bin} -D ${datadir} stop -m fast" >/dev/null 2>&1 && \
+ /bin/rm -f ${datadir}/postmaster.pid
+}
+
+rc_cmd $1
