notbugAs an Amazon Associate I earn from qualifying purchases.
Want a good read? Try FreeBSD Mastery: Jails (IT Mastery Book 15)

Two new features

Two new features were added on 2020-05-30:
  1. Repology links - each port now has a link to See issue 148 for details.
  2. Ports I maintain report - port maintainers can now subscribe to a daily report of commits to the ports they maintain. See Watch ports I maintain at Report Subscriptions. Details at issue 138
non port: databases/postgresql84-server/pkg-plist-server

Number of commits found XX: 25

Mon, 8 Jun 2015
[ 01:20 amdmi3 ] Original commit   Revision:388809
388809 databases/postgresql84-server/pkg-plist-client
388809 databases/postgresql84-server/pkg-plist-contrib
388809 databases/postgresql84-server/pkg-plist-plperl
388809 databases/postgresql84-server/pkg-plist-plpython
388809 databases/postgresql84-server/pkg-plist-pltcl
388809 databases/postgresql84-server/pkg-plist-server
- Modernize plist

Approved by:	portmgr blanket
Wed, 30 Jul 2014
[ 18:21 crees ] Original commit   Revision:363500
363500 databases/postgresql84-server/Makefile
363500 databases/postgresql84-server/distinfo
363500 databases/postgresql84-server/files/patch-contrib-uuid
363500 databases/postgresql84-server/pkg-plist-server
363500 databases/postgresql90-server/Makefile
363500 databases/postgresql90-server/distinfo
363500 databases/postgresql90-server/files/patch-contrib-uuid
363500 databases/postgresql90-server/pkg-plist-server
363500 databases/postgresql91-server/Makefile
363500 databases/postgresql91-server/distinfo

(Only the first 10 of 20 ports in this commit are shown above. View all ports for this commit)
Update to the latest snapshots.

uuid-ossp patch has been outdated with irrelevant changes (for us),
so massage back in.

In head of postgresql, this is handled properly, so eventually the ossp patches
can go.
Thu, 20 Feb 2014
[ 18:11 girgen ] Original commit   Revision:345257
345257 databases/postgresql84-server/Makefile
345257 databases/postgresql84-server/distinfo
345257 databases/postgresql84-server/pkg-plist-server
345257 databases/postgresql90-server/Makefile
345257 databases/postgresql90-server/distinfo
345257 databases/postgresql90-server/pkg-plist-server
345257 databases/postgresql91-docs/Makefile
345257 databases/postgresql91-server/Makefile
345257 databases/postgresql91-server/distinfo
345257 databases/postgresql92-server/Makefile

(Only the first 10 of 16 ports in this commit are shown above. View all ports for this commit)
The PostgreSQL Global Development Group has released an important
update to all supported versions of the PostgreSQL database system,
which includes minor versions 9.3.3, 9.2.7, 9.1.12, 9.0.16, and
8.4.20. This update contains fixes for multiple security issues, as
well as several fixes for replication and data integrity issues.  All
users are urged to update their installations at the earliest
opportunity, especially those using binary replication or running a
high-security application.

This update fixes CVE-2014-0060, in which PostgreSQL did not properly
enforce the WITH ADMIN OPTION permission for ROLE management. Before
this fix, any member of a ROLE was able to grant others access to the
same ROLE regardless if the member was given the WITH ADMIN OPTION
permission. It also fixes multiple privilege escalation issues,
including: CVE-2014-0061, CVE-2014-0062, CVE-2014-0063, CVE-2014-0064,
CVE-2014-0065, and CVE-2014-0066. More information on these issues can
be found on our security page and the security issue detail wiki page.

Security:	CVE-2014-0060,CVE-2014-0061,CVE-2014-0062,CVE-2014-0063
Fri, 5 Apr 2013
[ 15:26 girgen ] Original commit   Revision:315734
315734 databases/postgresql84-client/Makefile
315734 databases/postgresql84-contrib/Makefile
315734 databases/postgresql84-server/Makefile
315734 databases/postgresql84-server/pkg-plist-server
Fix pkg-list for postgresql84-server

Approved by:	portmgr (miwi)
Fri, 8 Feb 2013
[ 07:54 girgen ] Original commit   Revision:311915
311915 databases/postgresql83-server/Makefile
311915 databases/postgresql83-server/distinfo
311915 databases/postgresql83-server/pkg-plist-client
311915 databases/postgresql83-server/pkg-plist-server
311915 databases/postgresql84-client/Makefile
311915 databases/postgresql84-contrib/Makefile
311915 databases/postgresql84-server/Makefile
311915 databases/postgresql84-server/distinfo
311915 databases/postgresql84-server/pkg-plist-server
311915 databases/postgresql90-server/Makefile

(Only the first 10 of 19 ports in this commit are shown above. View all ports for this commit)
PostgreSQL 9.2.3, 9.1.8, 9.0.12, 8.4.16 and 8.3.23 released

This update fixes a denial-of-service (DOS) vulnerability.  All users
should update their PostgreSQL installations as soon as possible.

The security issue fixed in this release, CVE-2013-0255, allows a
previously authenticated user to crash the server by calling
an internal function with invalid arguments.

Fri, 17 Aug 2012
[ 19:39 jgh ] Original commit 
302694 databases/postgresql83-server/Makefile
302694 databases/postgresql83-server/distinfo
302694 databases/postgresql84-server/Makefile
302694 databases/postgresql84-server/distinfo
302694 databases/postgresql84-server/pkg-plist-client
302694 databases/postgresql84-server/pkg-plist-server
302694 databases/postgresql90-server/Makefile
302694 databases/postgresql90-server/distinfo
302694 databases/postgresql91-server/Makefile
302694 databases/postgresql91-server/distinfo

(Only the first 10 of 11 ports in this commit are shown above. View all ports for this commit)
The PostgreSQL Global Development Group today released security updates for all
active branches
of the PostgreSQL database system, including versions 9.1.5, 9.0.9, 8.4.13 and
8.3.20. This
update patches security holes associated with libxml2 and libxslt, similar to
those affecting
other open source projects. All users are urged to update their installations at
the first
available opportunity.

This security release fixes a vulnerability in the built-in XML functionality,
and a vulnerability
in the XSLT functionality supplied by the optional XML2 extension. Both
vulnerabilities allow
reading of arbitrary files by any authenticated database user, and the XSLT
allows writing files as well. The fixes cause limited backwards compatibility
These issues correspond to the following two vulnerabilities:

CVE-2012-3488: PostgreSQL insecure use of libxslt
CVE-2012-3489: PostgreSQL insecure use of libxml2
This release also contains several fixes to version 9.1, and a smaller number of
fixes to older versions, including:
(Only the first 15 lines of the commit message are shown above View all of this commit message)
Mon, 4 Jun 2012
[ 11:00 girgen ] Original commit 
1.229 databases/postgresql83-server/Makefile
1.82 databases/postgresql83-server/distinfo
1.2 databases/postgresql83-server/files/patch-crypt-des.c
1.34 databases/postgresql83-server/pkg-plist-server
1.251 databases/postgresql84-server/Makefile
1.85 databases/postgresql84-server/distinfo
1.2 databases/postgresql84-server/files/patch-crypt-des.c
1.40 databases/postgresql84-server/pkg-plist-server
1.9 databases/postgresql90-client/Makefile
1.243 databases/postgresql90-server/Makefile

(Only the first 10 of 21 ports in this commit are shown above. View all ports for this commit)
The PostgreSQL Global Development Group today released security updates for all
active branches of the PostgreSQL database system, including versions 9.1.4,
9.0.8, 8.4.12 and 8.3.19.

Users of the crypt(text, text) function with DES encryption in the optional
pg_crypto module should upgrade their installations immediately, if you have'nt
already updated since the port was patched on May 30.  All other database
administrators are urged to upgrade your version of PostgreSQL at the
next scheduled downtime.


          Fix incorrect password transformation in contrib/pgcrypto’s DES
crypt() function
          This was fixed in a patch release for the FreeBSD ports on May 30.

          Ignore SECURITY DEFINER and SET attributes for a procedural
language’s call handle
Sun, 22 Jan 2012
[ 06:59 jgh ] Original commit 
1.210 databases/postgresql82-server/Makefile
1.6 databases/postgresql82-server/files/
1.25 databases/postgresql82-server/pkg-plist-server
1.223 databases/postgresql83-server/Makefile
1.6 databases/postgresql83-server/files/
1.32 databases/postgresql83-server/pkg-plist-server
1.243 databases/postgresql84-server/Makefile
1.7 databases/postgresql84-server/files/
1.39 databases/postgresql84-server/pkg-plist-server
1.236 databases/postgresql90-server/Makefile

(Only the first 10 of 15 ports in this commit are shown above. View all ports for this commit)
- Add profile support for PostgreSQL servers
- re-assign LOCALBASE to PREFIX
- add PG_GROUP to SUB_PLIST for packaging fix
- fix permissions for package installations

PR:     ports/162776
Submitted by:   jgh, Phil Phillips < pphillips at >
Reviewed by: rene (mentor)
Approved by: crees (maintainer, mentor)
Thu, 19 Jan 2012
[ 19:06 jgh ] Original commit 
1.209 databases/postgresql82-server/Makefile
1.24 databases/postgresql82-server/pkg-plist-server
1.222 databases/postgresql83-server/Makefile
1.31 databases/postgresql83-server/pkg-plist-server
1.242 databases/postgresql84-server/Makefile
1.38 databases/postgresql84-server/pkg-plist-server
1.235 databases/postgresql90-server/Makefile
1.38 databases/postgresql90-server/pkg-plist-server
1.237 databases/postgresql91-server/Makefile
1.41 databases/postgresql91-server/pkg-plist-server
fix typo %%PG_GROUP%% in pkg-plist-server

Spotted by: decke
Approved by:    crees, rene (mentors,implicit)
Wed, 18 Jan 2012
[ 21:35 jgh ] Original commit 
1.207 databases/postgresql82-server/Makefile
1.23 databases/postgresql82-server/pkg-plist-server
1.240 databases/postgresql84-server/Makefile
1.37 databases/postgresql84-server/pkg-plist-server
1.233 databases/postgresql90-server/Makefile
1.37 databases/postgresql90-server/pkg-plist-server
1.235 databases/postgresql91-server/Makefile
1.40 databases/postgresql91-server/pkg-plist-server
Fix plist to create directory with proper ownerships PostgreSQL database
may start.

PR:     ports/164273 (critical)
Submitted by: Alexander Yerenkow <yerenkow at>
Approved by:    maintainer-timeout: girgen (1 day), portmgr (linimon)
Mon, 5 Dec 2011
[ 16:45 girgen ] Original commit 
1.206 databases/postgresql82-server/Makefile
1.219 databases/postgresql83-server/Makefile
1.239 databases/postgresql84-server/Makefile
1.83 databases/postgresql84-server/distinfo
1.22 databases/postgresql84-server/pkg-plist-client
1.36 databases/postgresql84-server/pkg-plist-server
1.232 databases/postgresql90-server/Makefile
1.83 databases/postgresql90-server/distinfo
1.36 databases/postgresql90-server/pkg-plist-server
1.234 databases/postgresql91-server/Makefile

(Only the first 10 of 12 ports in this commit are shown above. View all ports for this commit)
The PostgreSQL Global Development Group today released updates for all
active branches of the PostgreSQL object-relational database system,
including versions 9.1.2, 9.0.6, 8.4.10, 8.3.17 and 8.2.23.

This release contains 52 fixes to version 9.1, and a smaller number of
fixes to older versions, including:

- Fix bugs in information_schema.referential_constraints view**
- Correct collations for citext columns and indexes**
- Prevent possible crash when joining to a scalar function
- Prevent transitory data corruption of GIN indexes after a crash
- Prevent data corruption on TOAST columns when copying data
- Fix failures during hot standby startup
- Correct another "variable not found in subplan target list" bug
- Fix bug with sorting on aggregate expressions in windowing functions
(Only the first 15 lines of the commit message are shown above View all of this commit message)
Thu, 20 Oct 2011
[ 21:07 crees ] Original commit 
1.204 databases/postgresql82-server/Makefile
1.22 databases/postgresql82-server/pkg-plist-server
1.217 databases/postgresql83-server/Makefile
1.29 databases/postgresql83-server/pkg-plist-server
1.235 databases/postgresql84-server/Makefile
1.35 databases/postgresql84-server/pkg-plist-server
1.230 databases/postgresql90-server/Makefile
1.35 databases/postgresql90-server/pkg-plist-server
1.231 databases/postgresql91-server/Makefile
1.38 databases/postgresql91-server/pkg-plist-server
- Fix packaging issue (missed %%PG_USER%% in pkg-plist-server)
- Remove extra include from postgresql82-server

PR:             ports/161816 ports/161824 ports/161821
Submitted by:   Jason Helfman (
Approved by:    portmgr (pav)
Tue, 18 Oct 2011
[ 09:03 girgen ] Original commit 
1.201 databases/postgresql82-server/Makefile
1.70 databases/postgresql82-server/distinfo
1.11 databases/postgresql82-server/files/502.pgsql
1.1 databases/postgresql82-server/files/
1.2 databases/postgresql82-server/files/patch-src-plperl-plperl
1.5 databases/postgresql82-server/pkg-install-server
1.21 databases/postgresql82-server/pkg-plist-server
1.214 databases/postgresql83-server/Makefile
1.79 databases/postgresql83-server/distinfo
1.12 databases/postgresql83-server/files/502.pgsql

(Only the first 10 of 43 ports in this commit are shown above. View all ports for this commit)
The PostgreSQL Global Development Group today released minor version updates
for all active branches of the PostgreSQL object-relational database system,
including versions 9.1.1, 9.0.5, 8.4.9, 8.3.16 and 8.2.22.

All users are strongly urged to update their installations at the next
scheduled downtime.


Cleanup ports. Better handling of the knob PG_USER.
Also add uuid to 9.0 and 9.1 contrib ports.
Mon, 15 Aug 2011
[ 14:52 crees ] Original commit 
1.199 databases/postgresql82-server/Makefile
1.4 databases/postgresql82-server/pkg-install-server
1.212 databases/postgresql83-server/Makefile
1.9 databases/postgresql83-server/pkg-install-server
1.227 databases/postgresql84-server/Makefile
1.5 databases/postgresql84-server/files/
1.33 databases/postgresql84-server/pkg-plist-server
1.222 databases/postgresql90-server/Makefile
1.5 databases/postgresql90-server/files/
1.33 databases/postgresql90-server/pkg-plist-server
Revert previous commit -- appears to cause rc problems as I missed some subs" REL="NOFOLLOW">

PR:             ports/157558 ports/157559 ports/157666 ports/157669
Submitted by:
Approved by:    maintainer (girgen; implicit -- this reverts a commit I did
after maintainer timeout)
Fri, 12 Aug 2011
[ 09:55 crees ] Original commit 
1.226 databases/postgresql84-server/Makefile
1.4 databases/postgresql84-server/files/
1.32 databases/postgresql84-server/pkg-plist-server

PR:             ports/157666
Submitted by:   me
Approved by:    maintainer timeout (girgen, 8 weeks)
Mon, 18 Apr 2011
[ 23:34 girgen ] Original commit 
1.197 databases/postgresql82-server/Makefile
1.69 databases/postgresql82-server/distinfo
1.2 databases/postgresql82-server/files/
1.20 databases/postgresql82-server/pkg-plist-server
1.210 databases/postgresql83-server/Makefile
1.78 databases/postgresql83-server/distinfo
1.3 databases/postgresql83-server/files/
1.27 databases/postgresql83-server/pkg-plist-server
1.221 databases/postgresql84-server/Makefile
1.81 databases/postgresql84-server/distinfo

(Only the first 10 of 27 ports in this commit are shown above. View all ports for this commit)
Update PostgreSQL to 9.0.4, 8.4.8, 8.3.15 and 8.2.21.

This update contains a critical fix to the pg_upgrade utility
which prevents significant downtime issues. Do not use
pg_upgrade without installing this update first.

The issue with pg_upgrade and the fix are detailed on the PostgreSQL
Users who have already used pg_upgrade should run the database repair
script given on that page on their databases as soon as possible.

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

Allow the username of the postgresql user to configurable for 8.4 and 9.0.
Largely inspired by the work of Jason Helfman [153668, 153136].

Change PGUSER knob to PG_USER not to clash with PGUSER environment.

PR: 153668, 153136, 155493, 155137
Mon, 22 Nov 2010
[ 19:21 sunpoet ] Original commit 
1.204 databases/postgresql83-server/Makefile
1.26 databases/postgresql83-server/pkg-plist-server
1.214 databases/postgresql84-server/Makefile
1.30 databases/postgresql84-server/pkg-plist-server
1.208 databases/postgresql90-server/Makefile
1.29 databases/postgresql90-server/pkg-plist-server
- Use dirrmtry on share/postgresql/tsearch_data for postgresql{83|84|90}-server

PR:             ports/151882
Submitted by:   sunpoet (myself)
Approved by:    girgen (maintainer timeout, 20 days)
Thu, 7 Oct 2010
[ 06:58 girgen ] Original commit 
1.908 databases/Makefile
1.164 databases/postgresql74-server/Makefile
1.56 databases/postgresql74-server/distinfo
1.185 databases/postgresql80-server/Makefile
1.68 databases/postgresql80-server/distinfo
1.17 databases/postgresql80-server/pkg-plist-server
1.190 databases/postgresql81-server/Makefile
1.68 databases/postgresql81-server/distinfo
1.17 databases/postgresql81-server/pkg-plist-server
1.191 databases/postgresql82-server/Makefile

(Only the first 10 of 28 ports in this commit are shown above. View all ports for this commit)
Update all PostgreSQL ports to latest versions.

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
Sat, 5 Jun 2010
[ 11:04 girgen ] Original commit 
1.206 databases/postgresql84-server/Makefile
1.28 databases/postgresql84-server/pkg-plist-server
Fix package list
Thu, 20 May 2010
[ 15:43 girgen ] Original commit 
1.2141 MOVED
1.20 databases/postgresql-contrib/Makefile
1.2 databases/postgresql-contrib/pkg-descr
1.1 databases/postgresql74-contrib/Makefile
1.1 databases/postgresql74-contrib/pkg-descr
1.161 databases/postgresql74-server/Makefile
1.55 databases/postgresql74-server/distinfo
1.9 databases/postgresql74-server/files/502.pgsql
1.1 databases/postgresql80-contrib/Makefile
1.1 databases/postgresql80-contrib/pkg-descr

(Only the first 10 of 39 ports in this commit are shown above. View all ports for this commit)
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.
(Only the first 15 lines of the commit message are shown above View all of this commit message)
Thu, 25 Mar 2010
[ 21:47 delphij ] Original commit 
1.200 databases/postgresql84-server/Makefile
1.76 databases/postgresql84-server/distinfo
1.26 databases/postgresql84-server/pkg-plist-server
Update to 8.4.3.

PR:             ports/144863
Submitted by:   Alexander <alp rsu ru>
Security:       e050119b-3856-11df-b2b2-002170daae37
With hat:       ports-security@
Thu, 17 Dec 2009
[ 16:07 mm ] Original commit 
1.196 databases/postgresql84-server/Makefile
1.74 databases/postgresql84-server/distinfo
1.25 databases/postgresql84-server/pkg-plist-server
- Update to 8.4.2

Security:       CVE-2009-4034
Security:       CVE-2009-4136
PR:             ports/141639
Submitted by:   Alexander Pyhalov <>
Approved by:    ports-security (delphij)
Wed, 2 Dec 2009
[ 22:21 mm ] Original commit 
1.3 databases/postgresql84-client/Makefile
1.195 databases/postgresql84-server/Makefile
1.73 databases/postgresql84-server/distinfo
1.7 databases/postgresql84-server/files/patch-src:backend:utils:misc:postgresql.conf.sample
1.17 databases/postgresql84-server/pkg-plist-client
1.24 databases/postgresql84-server/pkg-plist-server
- Update to 8.4.1
- Set INTDATE on as default (this is default by PostgreSQL)

PR:             ports/139277
Submitted by:   Olli Hauer <>
Approved by:    maintainer timeout (2 months)
Wed, 8 Jul 2009
[ 20:31 girgen ] Original commit 
1.2 databases/postgresql84-client/Makefile
1.194 databases/postgresql84-server/Makefile
1.2 databases/postgresql84-server/files/
1.16 databases/postgresql84-server/pkg-plist-client
1.23 databases/postgresql84-server/pkg-plist-server
Fix broken pkg-plist for gettext files.

Also, inform about pg_standby rather than autovacuum. [1]

PR:     136468 [1]
Tue, 7 Jul 2009
[ 22:30 girgen ] Original commit 
1.18 databases/postgresql-contrib/Makefile
1.5 databases/postgresql83-client/Makefile
1.193 databases/postgresql84-server/Makefile
1.72 databases/postgresql84-server/distinfo
1.2 databases/postgresql84-server/files/patch-doc-Makefile
1.4 databases/postgresql84-server/files/patch-src-makefiles-Makefile.freebsd
1.15 databases/postgresql84-server/pkg-plist-client
1.9 databases/postgresql84-server/pkg-plist-contrib
1.22 databases/postgresql84-server/pkg-plist-server
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


Number of commits found XX: 25

User Login
Create account

Servers and bandwidth provided by
New York Internet, iXsystems, and RootBSD

This site
What is FreshPorts?
About the authors
How big is it?
The latest upgrade!

Enter Keywords:

Latest Vulnerabilities
typo3-10Aug 04
typo3-9Aug 04
libX11Aug 01
xephyrAug 01
xorg-dmxAug 01
xorg-nestserverAug 01
xorg-serverAug 01
xorg-vfbserverAug 01
xwaylandAug 01
python38Jul 31
arkJul 30
chromiumJul 28
freerdpJul 28
libsndfileJul 28
zeekJul 28

13 vulnerabilities affecting 77 ports have been reported in the past 14 days

* - modified, not new

All vulnerabilities

Last updated:
2020-08-04 10:33:08

Deleted ports
Sanity Test Failures

NEW Graphs (Javascript)

Calculated hourly:
Port count 40255
Broken 91
Deprecated 599
Ignore 326
Forbidden 5
Restricted 147
Vulnerable 20
Expired 3
Set to expire 570
Interactive 0
new 24 hours 2
new 48 hours10
new 7 days44
new fortnight76
new month141

Servers and bandwidth provided by
New York Internet, iXsystems, and RootBSD
Valid HTML, CSS, and RSS.
Copyright © 2000-2020 Dan Langille. All rights reserved.