ports/databases/postgresql92-server/files/patch-src:backend:utils:misc:postgresql.conf.sample, branch pkg-install-eol

The PostgreSQL Global Development Group announces the beta release of

2012-05-15T22:14:55Z

PostgreSQL 9.2, which will include major increases in performance and both vertical and horizontal scalability. The PostgreSQL Project asks all users to download and begin testing 9.2 Beta as soon as possible. Major performance and scalability advances in this version include: * Index-only scans, allowing users to avoid inefficient scans of base tables * Enhanced read-only workload scaling to 64 cores and over 300,000 queries per second * Improvements to data write speeds, including group commit * Reductions in CPU power consumption * Cascading replication, supporting geographically distributed standby databases PostgreSQL 9.2 will also offer many new features for application developers, including: * JSON data support, enabling hybrid document-relational databases * Range types, supporting new types of calendar, time-series and * analytic applications * Multiple improvements to ALTER and other statements, easing runtime * database updates For a full listing of the features in version 9.2 Beta, please see the release notes: http://www.postgresql.org/docs/devel/static/release-9-2.html We depend on our community to help test the next version in order to guarantee that it is high-performance and bug-free. Please install PostgreSQL 9.2 Beta and try it with your workloads and applications as soon as you can, and give feedback to the PostgreSQL developers. More information on how to test and report issues: http://www.postgresql.org/developer/beta

Update all PostgreSQL ports to latest versions.

2010-10-07T06:58:10Z

Also, try to break the previous 1:1 relation between FreeBSD system and PostgreSQL versions installed. Use different PREFIX:es to install different versions on the same system. PR: ports/132402, ports/145002, ports/146657

- Update to 8.4.1

2009-12-02T22:21:27Z

- Set INTDATE on as default (this is default by PostgreSQL) PR: ports/139277 Submitted by: Olli Hauer Approved by: maintainer timeout (2 months)

Remove bad "BETA" alert. This is not beta anymore.

2008-02-18T12:55:02Z

Set update_process_title = off, as suggested by kris@ and others.

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

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

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)

Remove the PORTNAME from postgreql-client. PORTNAME is set by

2003-12-05T21:22:42Z

MASTERDIR/Makefile[1]. Improve the CONFLICTS messages[2]. Fix the DEPENDS so that MIT krb5 depends on security/krb5, not heimdal[3]. Add a file that was missing in the upgrade that has PostgreSQL log to syslog by default[4]. PR: [4] Originally submitted in ports/59402 Submitted by: [1,2,4] maintainer [3] keoki seu