ports/databases/postgresql91-server/pkg-plist-contrib, branch release/8.0.0

This commit was manufactured by cvs2svn to create tag 'RELEASE_8_0_0'.

2009-11-14T12:33:33Z

- Fix plist for contrib

2009-09-19T22:06:02Z

PR: ports/136654, ports/136962 Reported by: YAMAMOTO Takao , Gergely Czuczy Approved by: maintainer timeout (girgen; 2 months) Feature safe: yes

Welcome PostgreSQL 8.4

2009-07-07T22:30:06Z

After many years of development, PostgreSQL has become feature-complete in many areas. This release shows a targeted approach to adding features (e.g., authentication, monitoring, space reuse), and adds capabilities defined in the later SQL standards. The major areas of enhancement are: Windowing Functions Common Table Expressions and Recursive Queries Default and variadic parameters for functions Parallel Restore Column Permissions Per-database locale settings Improved hash indexes Improved join performance for EXISTS and NOT EXISTS queries Easier-to-use Warm Standby Automatic sizing of the Free Space Map Visibility Map (greatly reduces vacuum overhead for slowly-changing tables) Version-aware psql (backslash commands work against older servers) Support SSL certificates for user authentication Per-function runtime statistics Easy editing of functions in psql New contrib modules: pg_stat_statements, auto_explain, citext, btree_gin URL: http://www.postgresql.org/docs/8.4/interactive/release-8-4.html

Update to RC2.

2008-01-22T14:08:48Z

[1] Fix problem installing from package. [2] Use DISTVERSION instead of PORTVERSION. (the port reports now correct version 8.3.r2) [2] Enable more 8.3 features: - Add OPTION for the new XML data type (default: enabled) - Add OPTION for usage of system timezone data (default: included tzdata) PR: ports/119770 [1], ports/119561 [2] Submitted by: Artis Caune [1], Martin Matuska [2]

Update all PostgreSQL ports to latest versions.

2008-01-07T13:51:57Z

This includes a bunch of security fixes: CVE-2007-6067, CVE-2007-4772, CVE-2007-6601, CVE-2007-6600 and CVE-2007-4769. Security: http://www.postgresql.org/about/news.905

Introducing the first beta of PostgreSQL 8.3

2007-10-15T15:32:19Z

Note that this is a BETA VERSION of the PostgreSQL server. Use it only for testing.

Welcome new release of the world's most advanced open source database:

2006-12-06T16:50:34Z

PostgreSQL 8.2.0 Complete release notes are available at http://www.postgresql.org/docs/current/static/release-8-2.html

eplace ugly "@unexec rmdir %D... 2>/dev/null || true" with @dirrmtry

2006-01-22T05:52:28Z

Approved by: krion@ PR: ports/88711 (related)

Welcome to PostgreSQL 8.1.

2005-11-10T02:23:38Z

The new release includes performance improvements and advanced SQL features which will support bigger data warehouses, higher-volume transaction processing, and more complex distributed enterprise software. Major new features in this release include: Roles: PostgreSQL now supports database roles, which simplify the management of large numbers of users with complex overlapping database rights. IN/OUT Parameters: PostgreSQL functions now support IN, OUT and INOUT parameters, which substantially improves support of complex business logic for J2EE and .NET applications. Two-Phase Commit (2PC): Long in demand for WAN applications and heterogeneous data centers using PostgreSQL, this feature allows ACID-compliant transactions across widely separated servers. Some Performance Enhancements found in this release include: Improved Multiprocessor (SMP) Performance: The buffer manager for 8.1 has been enhanced to scale almost linearly with the number of processors, leading to significant performance gains on 8-way, 16-way, dual-core, and multi-core CPU servers. Bitmap Scan: Indexes will be dynamically converted to bitmaps in memory when appropriate, giving up to twenty times faster index performance on complex queries against very large tables. Table Partitioning: The query planner is now able to avoid scanning whole sections of a large table using a technique known as Constraint Exclusion. Shared Row Locking: PostgreSQL's "better than row-level locking" now supports even higher levels of concurrency through the addition of shared row locks for foreign keys. For a more complete listing of changes in this release, please see the Release Notes visible at: http://www.postgresql.org/docs/current/static/release.html#RELEASE-8-1

Say hello to postgresql-8.0. Some of the highlights of the new version

2005-01-31T00:36:16Z

are savepoints (within transactions), point-in-time recovery and tablespaces. Check out the release notes and the shiny new PostgreSQL.org website at: http://www.PostgreSQL.org/docs/8.0/static/release.html#RELEASE-8-0 The port uses the new postgresql ports' layout and is split into a server and a client part. The following knobs can be used by ports depending on PostgreSQL: # USE_PGSQL - Add PostgreSQL client dependency. # If no version is given (by the maintainer via the port or # by the user via defined variable), try to find the # currently installed version. Fall back to default if # necessary (PostgreSQL-7.4 = 74). # DEFAULT_PGSQL_VER # - PostgreSQL default version. Can be overridden within a port. # Default: 74. # WANT_PGSQL_VER # - Maintainer can set an arbitrary version of PostgreSQL by # using it. # BROKEN_WITH_PGSQL # - This variable can be defined if the ports doesn't support # one or more versions of PostgreSQL. PR: 75344 Approved by: portmgr@ (kris), ade & sean (mentors)