notbugAs an Amazon Associate I earn from qualifying purchases.
Want a good read? Try FreeBSD Mastery: Jails (IT Mastery Book 15)
All times are UTC
non port: databases/postgresql-contrib/Makefile

Number of commits found: 20

Thursday, 20 May 2010
15:43 girgen search for other commits by this committer
Update all PostgreSQL ports to latest version.

Remove postgresql-contrib in favour for postgresqlNN-contrib.
This way we will get packages built, which is nice.

Security:       CVE-2010-1169
Security:       CVE-2010-1170

The PostgreSQL Project today released minor versions updating all active
branches of the PostgreSQL object-relational database system, including
versions 8.4.4, 8.3.11, 8.2.17, 8.1.21, 8.0.25, and 7.4.29. This release
fixes moderate-risk security issues with PL/perl and PL/tcl, as well as
a data corruption issue with standby databases.  Users of any of these
three features should update their PostgreSQL installations immediately.

The PL/perl security fix closes a security hole in PL/perl
procedures which could allow privilege escalation on the host system,
caused by a flaw in; see CVE-2010-1169 and CVE-2010-1447 for
details.  A second patch prevents PL/tcl's pltcl_modules table from
being subverted in order to run arbitrary Tcl scripts; see
CVE-2010-1170.  These issues only affect users who have enabled either
of these two stored procedure languages.

Also corrected is use of the command ALTER TABLE SET TABLESPACE, which
previously could cause data corruption on Warm Standby database slaves.
This issue affects only version 8.4.

There are also 21 other bug fixes in this release, some of which apply
only to version 8.4, and a few of which are specifically for Windows.
While these are generally fixes for minor issues, among the changes are:

     * Fix for a combinational crash condition
     * Prevent normal users from resetting some GUCs in
       their own role definitions
     * Correctly apply constraint exclusion in UPDATE and DELETE queries
     * Minor fixes for WAL archiving
     * Update timezone data for 12 zones

See the release notes for a full list of changes with details.

Releasenotes at
Original commit
Wednesday, 8 Jul 2009
20:56 girgen search for other commits by this committer
ossp-uuid conflicts with e2fsprogs-libuuid, which is used by Xorg,
so it is not reasonable to depend on it.

Pointed out by Kostik Belousov
Original commit
Tuesday, 7 Jul 2009
22:30 girgen search for other commits by this committer
Welcome PostgreSQL 8.4

After many years of development, PostgreSQL has become feature-complete in many
This release shows a targeted approach to adding features (e.g., authentication,
monitoring, space reuse), and adds capabilities defined in the later SQL
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

Original commit
Friday, 6 Jun 2008
13:17 edwin search for other commits by this committer
Bump portrevision due to upgrade of devel/gettext.

The affected ports are the ones with gettext as a run-dependency
according to ports/INDEX-7 (5007 of them) and the ones with USE_GETTEXT
in Makefile (29 of them).

PR:             ports/124340
Submitted by:   edwin@
Approved by:    portmgr (pav)
Original commit
Tuesday, 11 Mar 2008
23:34 pav search for other commits by this committer
- Fix typo (unclosed double-quote)

PR:             ports/120618
Submitted by:   Gennady Proskurin <>

- Change default PostgreSQL dependency from 8.1 to 8.2

PR:             ports/120865
Submitted by:   edwin
Original commit
Monday, 7 Jan 2008
13:51 girgen search for other commits by this committer
Update all PostgreSQL ports to latest versions.

This includes a bunch of security fixes: CVE-2007-6067, CVE-2007-4772,
CVE-2007-6601, CVE-2007-6600 and CVE-2007-4769.

Original commit
Wednesday, 17 Oct 2007
10:13 ade search for other commits by this committer
Migration from bison 1.x to 2.x

PR:             117086
Tested by:      -exp runs
Original commit
Saturday, 4 Aug 2007
11:41 gabor search for other commits by this committer
- Remove the DESTDIR modifications from individual ports as we have a new,
  fully chrooted DESTDIR, which does not need such any more.

Sponsored by:   Google Summer of Code 2007
Approved by:    portmgr (pav)
Original commit
Sunday, 22 Jul 2007
01:39 edwin search for other commits by this committer
Set DEFAULT_PGSQL_VER to 81 after the change in Mk/

Approved by:    pav
Original commit
Thursday, 10 Nov 2005
02:23 girgen search for other commits by this committer
Welcome to PostgreSQL 8.1.

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

Major new features in this release include:

           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

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

       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:
Original commit
Thursday, 3 Feb 2005
09:30 girgen search for other commits by this committer
In order to address a potential security hole recently identified with
the "LOAD" option, the PostgreSQL Global Development Group is
announcing the release of new versions of PostgreSQL.

Update to 7.3.9, 7.4.7 & 8.0.1.

Take the opportunity to reset PORTREVISION of slave ports.

Back out name change of startup script. The new script uses rc.subr(8),
and as such also uses rcorder(8). But, rcorder does not exist in FreeBSD
4.x. Hence rename the script it back to the top of the directory
list. [1]

The periodic script should of course be executable. [2]

[1] Noted by Niels Chr. Bank-Pedersen <ncbp at bank-pedersen dot dk>
[2] Noted by Fritz Heinrichmeyer <fritz.heinrichmeyer at fernuni-hagen dot de>
Original commit
Monday, 31 Jan 2005
01:56 girgen search for other commits by this committer
Bump portrevision
Original commit
00:35 girgen search for other commits by this committer
Split the postgresql ports into a server and a client part.

All ports depending on postgresql shall use the USE_PGSQL=yes knob
defined in Mk/ Bumping portrevisions where needed.

PR:             75344
Approved by:    portmgr@ (kris), ade & sean (mentors)
Original commit
Monday, 6 Dec 2004
03:59 girgen search for other commits by this committer
Add myself as committer, and use my address.

Approved by: ade (mentor)
Original commit
Monday, 28 Jun 2004
21:48 vanilla search for other commits by this committer
Upgrade to 7.4.3.

PR:             ports/68456
Submitted by:   maintainer
Original commit
Wednesday, 4 Feb 2004
05:21 marcus search for other commits by this committer
Bump PORTREVISION on all ports that depend on gettext to aid with upgrading.

(Part 2)
Original commit
Thursday, 4 Dec 2003
12:00 seanc search for other commits by this committer
Introduce the world to PostgreSQL 7.4!  By and large this release is
regarded as a major release with features with interest to those with
large databases.  The updates are extensive and the best source of info
is in the release notes.  Enjoy and direct questions to database@!

Release notes:

PR:             ports/59403, ports/59404, ports/59393, ports/59394,
                ports/59395, ports/59397, ports/59398, ports/59402, &&
Submitted by:   maintainer
Approved by:    marcus (portmgr@ hat)
Original commit
Thursday, 4 Sep 2003
09:29 osa search for other commits by this committer
Use another way for PortgreSQL slave ports (make without -C),
because much more people still use old versions of make.
For committers: please use the same way for following
PRs: 56345-56350.

Spotted by:     Dan Langille <> via FreshPorts
Submitted by:   Palle Girgensohn <> (maintainer)
Original commit
Wednesday, 3 Sep 2003
15:22 osa search for other commits by this committer
Add ipc_check and reindexdb.
Change the way postgres slave ports build: use ${MAKE} -V instead of .include.
Utilize ${DOCSDIR}. [1]

Submitted by:   Palle Girgensohn <> (maintainer),
                osa [1]
Approved by:    maintainer
PR:             56342
Original commit
Sunday, 24 Aug 2003
12:17 edwin search for other commits by this committer
New port: postgresql-contrib

        New port, containing all contrib stuff distributed with postgresql

        From the README:

        The PostgreSQL contrib tree

        This subtree contains porting tools, analysis utilities,
        and plug-in features that are not part of the core PostgreSQL
        system, mainly because they address a limited audience or
        are too experimental to be part of the main source tree.
        This does not preclude their usefulness.

        Each subdirectory contains a README file with information
        about the module.  Most items can be built with `gmake all'
        and installed with `gmake install' in the usual fashion,
        after you have run the `configure' script in the top-level
        directory.  Some directories supply new user-defined
        functions, operators, or types.  After you have installed
        the files you need to register the new entities in the
        database system by running the commands in the supplied
        .sql file.  For example,

                $ psql -d dbname -f module.sql

        See the PostgreSQL documentation for more information about
        this procedure.

PR:             ports/53181
Submitted by:   Palle Girgensohn <>
Original commit

Number of commits found: 20