Hi,

PostgreSQL 9.2 is out.
Release notes: http://www.postgresql.org/docs/9.2/static/release-9-2.html
Announcement: http://www.postgresql.org/about/news/1415/

As usual a dump/restore is required (we don't support yet pg_upgrade).

Feedbacks welcome.
Regards,

-- 
Pierre-Emmanuel André <pea at raveland.org>
GPG key: 0x7AE329DC
Index: Makefile
===================================================================
RCS file: /cvs/ports/databases/postgresql/Makefile,v
retrieving revision 1.167
diff -u -p -r1.167 Makefile
--- Makefile    19 Aug 2012 18:22:32 -0000      1.167
+++ Makefile    11 Sep 2012 07:27:05 -0000
@@ -5,7 +5,7 @@ COMMENT-server= PostgreSQL RDBMS (server
 COMMENT-docs=  PostgreSQL RDBMS documentation
 COMMENT-contrib=PostgreSQL RDBMS contributions
 
-VERSION=       9.1.5
+VERSION=       9.2.0
 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.3 \
-               ecpg_compat     4.3 \
-               pgtypes         4.2 \
-               pq              5.4
+SHARED_LIBS=   ecpg            7.4 \
+               ecpg_compat     4.4 \
+               pgtypes         4.3 \
+               pq              5.5 
 
 HOMEPAGE=      http://www.postgresql.org/
 
@@ -29,8 +29,7 @@ PERMIT_DISTFILES_CDROM=       Yes
 PERMIT_DISTFILES_FTP=  Yes
 WANTLIB=               c com_err crypto m readline ssl termcap z
 
-MASTER_SITES= 
ftp://ftp2.uk.postgresql.org/sites/ftp.postgresql.org/source/v${VERSION}/ \
-       ftp://ftp5.us.postgresql.org/pub/PostgreSQL/source/v${VERSION}/ \
+MASTER_SITES=  ftp://ftp5.us.postgresql.org/pub/PostgreSQL/source/v${VERSION}/ 
\
        ftp://ftp5.es.postgresql.org/mirror/postgresql/source/v${VERSION}/ \
        ftp://ftp.postgresql.org/pub/source/v${VERSION}/
 
Index: distinfo
===================================================================
RCS file: /cvs/ports/databases/postgresql/distinfo,v
retrieving revision 1.44
diff -u -p -r1.44 distinfo
--- distinfo    19 Aug 2012 18:22:32 -0000      1.44
+++ distinfo    11 Sep 2012 07:27:05 -0000
@@ -1,2 +1,2 @@
-SHA256 (postgresql-9.1.5.tar.gz) = WbGFfBhVwjE/Ceb3gAf7SmJe4EdPX1gDZIy5coFci/A=
-SIZE (postgresql-9.1.5.tar.gz) = 20439796
+SHA256 (postgresql-9.2.0.tar.gz) = 4ln7y2ruZ+JOeQ5iRySGf6S08TUv1I142I+1sqDfJjQ=
+SIZE (postgresql-9.2.0.tar.gz) = 21068595
Index: patches/patch-src_Makefile_shlib
===================================================================
RCS file: /cvs/ports/databases/postgresql/patches/patch-src_Makefile_shlib,v
retrieving revision 1.7
diff -u -p -r1.7 patch-src_Makefile_shlib
--- patches/patch-src_Makefile_shlib    21 Jul 2009 19:43:45 -0000      1.7
+++ patches/patch-src_Makefile_shlib    11 Sep 2012 07:27:05 -0000
@@ -1,7 +1,7 @@
 $OpenBSD: patch-src_Makefile_shlib,v 1.7 2009/07/21 19:43:45 pea Exp $
---- src/Makefile.shlib.orig    Mon Jan  5 10:27:19 2009
-+++ src/Makefile.shlib Sun May 31 11:58:20 2009
-@@ -154,7 +154,7 @@ ifeq ($(PORTNAME), openbsd)
+--- 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)
    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.6
diff -u -p -r1.6 patch-src_interfaces_ecpg_compatlib_Makefile
--- patches/patch-src_interfaces_ecpg_compatlib_Makefile        23 Sep 2011 
09:46:14 -0000      1.6
+++ patches/patch-src_interfaces_ecpg_compatlib_Makefile        11 Sep 2012 
07:27:05 -0000
@@ -1,12 +1,12 @@
 $OpenBSD: patch-src_interfaces_ecpg_compatlib_Makefile,v 1.6 2011/09/23 
09:46:14 pea Exp $
---- src/interfaces/ecpg/compatlib/Makefile.orig        Mon Mar 28 15:42:09 2011
-+++ src/interfaces/ecpg/compatlib/Makefile     Wed Apr  6 09:13:17 2011
+--- 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
 @@ -14,8 +14,8 @@ top_builddir = ../../../..
  include $(top_builddir)/src/Makefile.global
  
  NAME= ecpg_compat
 -SO_MAJOR_VERSION= 3
--SO_MINOR_VERSION= 3
+-SO_MINOR_VERSION= 4
 +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.6
diff -u -p -r1.6 patch-src_interfaces_ecpg_ecpglib_Makefile
--- patches/patch-src_interfaces_ecpg_ecpglib_Makefile  23 Sep 2011 09:46:14 
-0000      1.6
+++ patches/patch-src_interfaces_ecpg_ecpglib_Makefile  11 Sep 2012 07:27:05 
-0000
@@ -1,12 +1,12 @@
 $OpenBSD: patch-src_interfaces_ecpg_ecpglib_Makefile,v 1.6 2011/09/23 09:46:14 
pea Exp $
---- src/interfaces/ecpg/ecpglib/Makefile.orig  Mon Mar 28 15:42:09 2011
-+++ src/interfaces/ecpg/ecpglib/Makefile       Wed Apr  6 09:14:11 2011
+--- 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
 @@ -14,8 +14,8 @@ top_builddir = ../../../..
  include $(top_builddir)/src/Makefile.global
  
  NAME= ecpg
 -SO_MAJOR_VERSION= 6
--SO_MINOR_VERSION= 3
+-SO_MINOR_VERSION= 4
 +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.6
diff -u -p -r1.6 patch-src_interfaces_ecpg_pgtypeslib_Makefile
--- patches/patch-src_interfaces_ecpg_pgtypeslib_Makefile       23 Sep 2011 
09:46:14 -0000      1.6
+++ patches/patch-src_interfaces_ecpg_pgtypeslib_Makefile       11 Sep 2012 
07:27:05 -0000
@@ -1,12 +1,12 @@
 $OpenBSD: patch-src_interfaces_ecpg_pgtypeslib_Makefile,v 1.6 2011/09/23 
09:46:14 pea Exp $
---- src/interfaces/ecpg/pgtypeslib/Makefile.orig       Mon Mar 28 15:42:09 2011
-+++ src/interfaces/ecpg/pgtypeslib/Makefile    Wed Apr  6 09:14:52 2011
+--- 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 = ../../../..
  include $(top_builddir)/src/Makefile.global
  
  NAME= pgtypes
 -SO_MAJOR_VERSION= 3
--SO_MINOR_VERSION= 2
+-SO_MINOR_VERSION= 3
 +SO_MAJOR_VERSION= ${LIBpgtypes_MAJOR}
 +SO_MINOR_VERSION= ${LIBpgtypes_MINOR}
  
Index: patches/patch-src_interfaces_libpq_Makefile
===================================================================
RCS file: 
/cvs/ports/databases/postgresql/patches/patch-src_interfaces_libpq_Makefile,v
retrieving revision 1.8
diff -u -p -r1.8 patch-src_interfaces_libpq_Makefile
--- patches/patch-src_interfaces_libpq_Makefile 23 Sep 2011 09:46:14 -0000      
1.8
+++ patches/patch-src_interfaces_libpq_Makefile 11 Sep 2012 07:27:05 -0000
@@ -1,12 +1,12 @@
 $OpenBSD: patch-src_interfaces_libpq_Makefile,v 1.8 2011/09/23 09:46:14 pea 
Exp $
---- src/interfaces/libpq/Makefile.orig Mon Mar 28 15:42:09 2011
-+++ src/interfaces/libpq/Makefile      Wed Apr  6 09:15:34 2011
+--- src/interfaces/libpq/Makefile.orig Fri May 11 00:35:09 2012
++++ src/interfaces/libpq/Makefile      Tue May 15 10:27:11 2012
 @@ -16,8 +16,8 @@ include $(top_builddir)/src/Makefile.global
  
  # shared library parameters
  NAME= pq
 -SO_MAJOR_VERSION= 5
--SO_MINOR_VERSION= 4
+-SO_MINOR_VERSION= 5
 +SO_MAJOR_VERSION= ${LIBpq_MAJOR}
 +SO_MINOR_VERSION= ${LIBpq_MINOR}
  
Index: pkg/PLIST-contrib
===================================================================
RCS file: /cvs/ports/databases/postgresql/pkg/PLIST-contrib,v
retrieving revision 1.8
diff -u -p -r1.8 PLIST-contrib
--- pkg/PLIST-contrib   23 Sep 2011 09:46:14 -0000      1.8
+++ pkg/PLIST-contrib   11 Sep 2012 07:27:05 -0000
@@ -6,6 +6,7 @@
 @bin bin/pg_archivecleanup
 @bin bin/pg_standby
 @bin bin/pg_test_fsync
+@bin bin/pg_test_timing
 @bin bin/pg_upgrade
 @bin bin/pgbench
 @bin bin/vacuumlo
@@ -43,9 +44,18 @@ lib/postgresql/refint.so
 lib/postgresql/seg.so
 lib/postgresql/sslinfo.so
 lib/postgresql/tablefunc.so
+lib/postgresql/tcn.so
 lib/postgresql/timetravel.so
 lib/postgresql/tsearch2.so
 lib/postgresql/uuid-ossp.so
+@man man/man1/oid2name.1
+@man man/man1/pg_archivecleanup.1
+@man man/man1/pg_standby.1
+@man man/man1/pg_test_fsync.1
+@man man/man1/pg_test_timing.1
+@man man/man1/pg_upgrade.1
+@man man/man1/pgbench.1
+@man man/man1/vacuumlo.1
 share/postgresql/extension/adminpack--1.0.sql
 share/postgresql/extension/adminpack.control
 share/postgresql/extension/autoinc--1.0.sql
@@ -83,7 +93,8 @@ share/postgresql/extension/file_fdw.cont
 share/postgresql/extension/fuzzystrmatch--1.0.sql
 share/postgresql/extension/fuzzystrmatch--unpackaged--1.0.sql
 share/postgresql/extension/fuzzystrmatch.control
-share/postgresql/extension/hstore--1.0.sql
+share/postgresql/extension/hstore--1.0--1.1.sql
+share/postgresql/extension/hstore--1.1.sql
 share/postgresql/extension/hstore--unpackaged--1.0.sql
 share/postgresql/extension/hstore.control
 share/postgresql/extension/insert_username--1.0.sql
@@ -116,7 +127,8 @@ share/postgresql/extension/pg_buffercach
 share/postgresql/extension/pg_freespacemap--1.0.sql
 share/postgresql/extension/pg_freespacemap--unpackaged--1.0.sql
 share/postgresql/extension/pg_freespacemap.control
-share/postgresql/extension/pg_stat_statements--1.0.sql
+share/postgresql/extension/pg_stat_statements--1.0--1.1.sql
+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
@@ -143,6 +155,8 @@ share/postgresql/extension/sslinfo.contr
 share/postgresql/extension/tablefunc--1.0.sql
 share/postgresql/extension/tablefunc--unpackaged--1.0.sql
 share/postgresql/extension/tablefunc.control
+share/postgresql/extension/tcn--1.0.sql
+share/postgresql/extension/tcn.control
 share/postgresql/extension/test_parser--1.0.sql
 share/postgresql/extension/test_parser--unpackaged--1.0.sql
 share/postgresql/extension/test_parser.control
Index: pkg/PLIST-docs
===================================================================
RCS file: /cvs/ports/databases/postgresql/pkg/PLIST-docs,v
retrieving revision 1.56
diff -u -p -r1.56 PLIST-docs
--- pkg/PLIST-docs      19 Aug 2012 18:22:32 -0000      1.56
+++ pkg/PLIST-docs      11 Sep 2012 07:27:05 -0000
@@ -31,6 +31,7 @@ share/doc/postgresql/html/app-pgbaseback
 share/doc/postgresql/html/app-pgconfig.html
 share/doc/postgresql/html/app-pgcontroldata.html
 share/doc/postgresql/html/app-pgdump.html
+share/doc/postgresql/html/app-pgreceivexlog.html
 share/doc/postgresql/html/app-pgresetxlog.html
 share/doc/postgresql/html/app-pgrestore.html
 share/doc/postgresql/html/app-postgres.html
@@ -94,10 +95,12 @@ share/doc/postgresql/html/catalog-pg-ope
 share/doc/postgresql/html/catalog-pg-opfamily.html
 share/doc/postgresql/html/catalog-pg-pltemplate.html
 share/doc/postgresql/html/catalog-pg-proc.html
+share/doc/postgresql/html/catalog-pg-range.html
 share/doc/postgresql/html/catalog-pg-rewrite.html
 share/doc/postgresql/html/catalog-pg-seclabel.html
 share/doc/postgresql/html/catalog-pg-shdepend.html
 share/doc/postgresql/html/catalog-pg-shdescription.html
+share/doc/postgresql/html/catalog-pg-shseclabel.html
 share/doc/postgresql/html/catalog-pg-statistic.html
 share/doc/postgresql/html/catalog-pg-tablespace.html
 share/doc/postgresql/html/catalog-pg-trigger.html
@@ -139,6 +142,9 @@ share/doc/postgresql/html/contrib-dblink
 share/doc/postgresql/html/contrib-dblink-is-busy.html
 share/doc/postgresql/html/contrib-dblink-open.html
 share/doc/postgresql/html/contrib-dblink-send-query.html
+share/doc/postgresql/html/contrib-prog-client.html
+share/doc/postgresql/html/contrib-prog-server.html
+share/doc/postgresql/html/contrib-prog.html
 share/doc/postgresql/html/contrib-spi.html
 share/doc/postgresql/html/contrib.html
 share/doc/postgresql/html/creating-cluster.html
@@ -151,6 +157,7 @@ share/doc/postgresql/html/datatype-chara
 share/doc/postgresql/html/datatype-datetime.html
 share/doc/postgresql/html/datatype-enum.html
 share/doc/postgresql/html/datatype-geometric.html
+share/doc/postgresql/html/datatype-json.html
 share/doc/postgresql/html/datatype-money.html
 share/doc/postgresql/html/datatype-net-types.html
 share/doc/postgresql/html/datatype-numeric.html
@@ -235,6 +242,7 @@ share/doc/postgresql/html/encryption-opt
 share/doc/postgresql/html/errcodes-appendix.html
 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/executor.html
 share/doc/postgresql/html/explicit-joins.html
 share/doc/postgresql/html/explicit-locking.html
@@ -250,6 +258,8 @@ share/doc/postgresql/html/external-pl.ht
 share/doc/postgresql/html/external-projects.html
 share/doc/postgresql/html/fdw-callbacks.html
 share/doc/postgresql/html/fdw-functions.html
+share/doc/postgresql/html/fdw-helpers.html
+share/doc/postgresql/html/fdw-planning.html
 share/doc/postgresql/html/fdwhandler.html
 share/doc/postgresql/html/features-sql-standard.html
 share/doc/postgresql/html/features.html
@@ -267,10 +277,12 @@ share/doc/postgresql/html/functions-enum
 share/doc/postgresql/html/functions-formatting.html
 share/doc/postgresql/html/functions-geometry.html
 share/doc/postgresql/html/functions-info.html
+share/doc/postgresql/html/functions-json.html
 share/doc/postgresql/html/functions-logical.html
 share/doc/postgresql/html/functions-matching.html
 share/doc/postgresql/html/functions-math.html
 share/doc/postgresql/html/functions-net.html
+share/doc/postgresql/html/functions-range.html
 share/doc/postgresql/html/functions-sequence.html
 share/doc/postgresql/html/functions-srf.html
 share/doc/postgresql/html/functions-string.html
@@ -333,6 +345,7 @@ share/doc/postgresql/html/infoschema-che
 share/doc/postgresql/html/infoschema-collation-character-set-applicab.html
 share/doc/postgresql/html/infoschema-collations.html
 share/doc/postgresql/html/infoschema-column-domain-usage.html
+share/doc/postgresql/html/infoschema-column-options.html
 share/doc/postgresql/html/infoschema-column-privileges.html
 share/doc/postgresql/html/infoschema-column-udt-usage.html
 share/doc/postgresql/html/infoschema-columns.html
@@ -358,6 +371,7 @@ share/doc/postgresql/html/infoschema-ref
 share/doc/postgresql/html/infoschema-role-column-grants.html
 share/doc/postgresql/html/infoschema-role-routine-grants.html
 share/doc/postgresql/html/infoschema-role-table-grants.html
+share/doc/postgresql/html/infoschema-role-udt-grants.html
 share/doc/postgresql/html/infoschema-role-usage-grants.html
 share/doc/postgresql/html/infoschema-routine-privileges.html
 share/doc/postgresql/html/infoschema-routines.html
@@ -376,7 +390,9 @@ share/doc/postgresql/html/infoschema-tab
 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-udt-privileges.html
 share/doc/postgresql/html/infoschema-usage-privileges.html
+share/doc/postgresql/html/infoschema-user-defined-types.html
 share/doc/postgresql/html/infoschema-user-mapping-options.html
 share/doc/postgresql/html/infoschema-user-mappings.html
 share/doc/postgresql/html/infoschema-view-column-usage.html
@@ -417,6 +433,7 @@ share/doc/postgresql/html/libpq-notice-p
 share/doc/postgresql/html/libpq-notify.html
 share/doc/postgresql/html/libpq-pgpass.html
 share/doc/postgresql/html/libpq-pgservice.html
+share/doc/postgresql/html/libpq-single-row-mode.html
 share/doc/postgresql/html/libpq-ssl.html
 share/doc/postgresql/html/libpq-status.html
 share/doc/postgresql/html/libpq-threading.html
@@ -469,6 +486,7 @@ share/doc/postgresql/html/pgstandby.html
 share/doc/postgresql/html/pgstatstatements.html
 share/doc/postgresql/html/pgstattuple.html
 share/doc/postgresql/html/pgtestfsync.html
+share/doc/postgresql/html/pgtesttiming.html
 share/doc/postgresql/html/pgtrgm.html
 share/doc/postgresql/html/pgupgrade.html
 share/doc/postgresql/html/planner-optimizer.html
@@ -539,6 +557,7 @@ 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/rangetypes.html
 share/doc/postgresql/html/recovery-config.html
 share/doc/postgresql/html/recovery-target-settings.html
 share/doc/postgresql/html/reference-client.html
@@ -767,6 +786,7 @@ share/doc/postgresql/html/release-9-1-3.
 share/doc/postgresql/html/release-9-1-4.html
 share/doc/postgresql/html/release-9-1-5.html
 share/doc/postgresql/html/release-9-1.html
+share/doc/postgresql/html/release-9-2.html
 share/doc/postgresql/html/release.html
 share/doc/postgresql/html/resources.html
 share/doc/postgresql/html/role-attributes.html
@@ -809,6 +829,11 @@ share/doc/postgresql/html/server-start.h
 share/doc/postgresql/html/source-format.html
 share/doc/postgresql/html/source.html
 share/doc/postgresql/html/sourcerepo.html
+share/doc/postgresql/html/spgist-examples.html
+share/doc/postgresql/html/spgist-extensibility.html
+share/doc/postgresql/html/spgist-implementation.html
+share/doc/postgresql/html/spgist-intro.html
+share/doc/postgresql/html/spgist.html
 share/doc/postgresql/html/spi-examples.html
 share/doc/postgresql/html/spi-interface-support.html
 share/doc/postgresql/html/spi-interface.html
@@ -844,6 +869,7 @@ share/doc/postgresql/html/spi-spi-gettyp
 share/doc/postgresql/html/spi-spi-gettypeid.html
 share/doc/postgresql/html/spi-spi-getvalue.html
 share/doc/postgresql/html/spi-spi-is-cursor-plan.html
+share/doc/postgresql/html/spi-spi-keepplan.html
 share/doc/postgresql/html/spi-spi-modifytuple.html
 share/doc/postgresql/html/spi-spi-palloc.html
 share/doc/postgresql/html/spi-spi-pfree.html
@@ -1029,6 +1055,7 @@ share/doc/postgresql/html/storage.html
 share/doc/postgresql/html/stylesheet.css
 share/doc/postgresql/html/supported-platforms.html
 share/doc/postgresql/html/tablefunc.html
+share/doc/postgresql/html/tcn.html
 share/doc/postgresql/html/test-parser.html
 share/doc/postgresql/html/textsearch-configuration.html
 share/doc/postgresql/html/textsearch-controls.html
Index: pkg/PLIST-main
===================================================================
RCS file: /cvs/ports/databases/postgresql/pkg/PLIST-main,v
retrieving revision 1.21
diff -u -p -r1.21 PLIST-main
--- pkg/PLIST-main      23 Sep 2011 09:46:14 -0000      1.21
+++ pkg/PLIST-main      11 Sep 2012 07:27:06 -0000
@@ -15,6 +15,7 @@
 @bin bin/pg_config
 @bin bin/pg_dump
 @bin bin/pg_dumpall
+@bin bin/pg_receivexlog
 @bin bin/pg_restore
 @bin bin/psql
 @bin bin/reindexdb
@@ -99,6 +100,7 @@ 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_receivexlog.1
 @man man/man1/pg_restore.1
 @man man/man1/psql.1
 @man man/man1/reindexdb.1
@@ -133,6 +135,7 @@ lib/postgresql/pgxs/src/test/regress/
 @man man/man3/SPI_gettypeid.3
 @man man/man3/SPI_getvalue.3
 @man man/man3/SPI_is_cursor_plan.3
+@man man/man3/SPI_keepplan.3
 @man man/man3/SPI_modifytuple.3
 @man man/man3/SPI_palloc.3
 @man man/man3/SPI_pfree.3
Index: pkg/PLIST-server
===================================================================
RCS file: /cvs/ports/databases/postgresql/pkg/PLIST-server,v
retrieving revision 1.21
diff -u -p -r1.21 PLIST-server
--- pkg/PLIST-server    23 Sep 2011 09:46:14 -0000      1.21
+++ pkg/PLIST-server    11 Sep 2012 07:27:06 -0000
@@ -4,7 +4,7 @@
 @conflict postgresql-clients-*
 @conflict postgresql-server-*
 @conflict postgresql-*
-@ask-update postgresql-server-<9.1 Make sure your existing database is backed 
up
+@ask-update postgresql-server-<9.2 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
@@ -38,6 +38,8 @@ include/postgresql/server/access/rmgr.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/subtrans.h
 include/postgresql/server/access/sysattr.h
 include/postgresql/server/access/transam.h
@@ -107,10 +109,12 @@ include/postgresql/server/catalog/pg_opf
 include/postgresql/server/catalog/pg_pltemplate.h
 include/postgresql/server/catalog/pg_proc.h
 include/postgresql/server/catalog/pg_proc_fn.h
+include/postgresql/server/catalog/pg_range.h
 include/postgresql/server/catalog/pg_rewrite.h
 include/postgresql/server/catalog/pg_seclabel.h
 include/postgresql/server/catalog/pg_shdepend.h
 include/postgresql/server/catalog/pg_shdescription.h
+include/postgresql/server/catalog/pg_shseclabel.h
 include/postgresql/server/catalog/pg_statistic.h
 include/postgresql/server/catalog/pg_tablespace.h
 include/postgresql/server/catalog/pg_trigger.h
@@ -133,6 +137,7 @@ include/postgresql/server/commands/colla
 include/postgresql/server/commands/comment.h
 include/postgresql/server/commands/conversioncmds.h
 include/postgresql/server/commands/copy.h
+include/postgresql/server/commands/createas.h
 include/postgresql/server/commands/dbcommands.h
 include/postgresql/server/commands/defrem.h
 include/postgresql/server/commands/discard.h
@@ -153,6 +158,8 @@ 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/datatype/
+include/postgresql/server/datatype/timestamp.h
 include/postgresql/server/dynloader.h
 include/postgresql/server/executor/
 include/postgresql/server/executor/execdebug.h
@@ -173,6 +180,7 @@ include/postgresql/server/executor/nodeF
 include/postgresql/server/executor/nodeGroup.h
 include/postgresql/server/executor/nodeHash.h
 include/postgresql/server/executor/nodeHashjoin.h
+include/postgresql/server/executor/nodeIndexonlyscan.h
 include/postgresql/server/executor/nodeIndexscan.h
 include/postgresql/server/executor/nodeLimit.h
 include/postgresql/server/executor/nodeLockRows.h
@@ -296,27 +304,21 @@ include/postgresql/server/pg_config_os.h
 include/postgresql/server/pg_trace.h
 include/postgresql/server/pgstat.h
 include/postgresql/server/pgtime.h
+include/postgresql/server/plpgsql.h
 include/postgresql/server/port/
 include/postgresql/server/port.h
 include/postgresql/server/port/aix.h
-include/postgresql/server/port/bsdi.h
 include/postgresql/server/port/cygwin.h
 include/postgresql/server/port/darwin.h
-include/postgresql/server/port/dgux.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/nextstep.h
 include/postgresql/server/port/openbsd.h
 include/postgresql/server/port/osf.h
 include/postgresql/server/port/sco.h
 include/postgresql/server/port/solaris.h
-include/postgresql/server/port/sunos4.h
-include/postgresql/server/port/svr4.h
-include/postgresql/server/port/ultrix4.h
-include/postgresql/server/port/univel.h
 include/postgresql/server/port/unixware.h
 @comment include/postgresql/server/port/win32/
 include/postgresql/server/port/win32.h
@@ -350,6 +352,7 @@ include/postgresql/server/postmaster/bgw
 include/postgresql/server/postmaster/fork_process.h
 include/postgresql/server/postmaster/pgarch.h
 include/postgresql/server/postmaster/postmaster.h
+include/postgresql/server/postmaster/startup.h
 include/postgresql/server/postmaster/syslogger.h
 include/postgresql/server/postmaster/walwriter.h
 include/postgresql/server/regex/
@@ -363,6 +366,7 @@ include/postgresql/server/replication/sy
 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
 include/postgresql/server/rewrite/
 include/postgresql/server/rewrite/prs2lock.h
 include/postgresql/server/rewrite/rewriteDefine.h
@@ -409,6 +413,7 @@ include/postgresql/server/snowball/libst
 include/postgresql/server/snowball/libstemmer/stem_UTF_8_turkish.h
 include/postgresql/server/storage/
 include/postgresql/server/storage/backendid.h
+include/postgresql/server/storage/barrier.h
 include/postgresql/server/storage/block.h
 include/postgresql/server/storage/buf.h
 include/postgresql/server/storage/buf_internals.h
@@ -492,6 +497,7 @@ include/postgresql/server/utils/hsearch.
 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/logtape.h
 include/postgresql/server/utils/lsyscache.h
 include/postgresql/server/utils/memutils.h
@@ -499,6 +505,7 @@ include/postgresql/server/utils/nabstime
 include/postgresql/server/utils/numeric.h
 include/postgresql/server/utils/palloc.h
 include/postgresql/server/utils/pg_crc.h
+include/postgresql/server/utils/pg_crc_tables.h
 include/postgresql/server/utils/pg_locale.h
 include/postgresql/server/utils/pg_lzcompress.h
 include/postgresql/server/utils/pg_rusage.h
@@ -506,14 +513,17 @@ 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/rangetypes.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/reltrigger.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/sortsupport.h
 include/postgresql/server/utils/spccache.h
 include/postgresql/server/utils/syscache.h
 include/postgresql/server/utils/timestamp.h

Reply via email to