FreshPorts -- The Place For Ports If you buy from Amazon USA, please support us by using this link.
Follow us
Blog
Twitter

Please give me your LTO-4 or better tape library and I'll put it to good use.
Port details
postgresql92-server The most advanced open-source database available anywhere
9.2.13_1 databases on this many watch lists=7 search for ports that depend on this port An older version of this port was marked as vulnerable. Find issues related to this port Report an issue related to this port
Maintainer: pgsql@FreeBSD.org search for ports maintained by this maintainer
Port Added: 11 May 2012 08:36:43
License: not specified in port
PostgreSQL is a sophisticated Object-Relational DBMS, supporting
almost all SQL constructs, including subselects, transactions, and
user-defined types and functions. It is the most advanced open-source
database available anywhere. Commercial Support is also available.

The original Postgres code was the effort of many graduate students,
undergraduate students, and staff programmers working under the direction of
Professor Michael Stonebraker at the University of California, Berkeley. In
1995, Andrew Yu and Jolly Chen took on the task of converting the DBMS query
language to SQL and created a new database system which came to known as
Postgres95. Many others contributed to the porting, testing, debugging and
enhancement of the Postgres95 code. As the code improved, and 1995 faded into
memory, PostgreSQL was born.

PostgreSQL development is presently being performed by a team of Internet
developers who are now responsible for all current and future development. The
development team coordinator is Marc G. Fournier (scrappy@PostgreSQL.ORG).
Support is available from the PostgreSQL developer/user community through the
support mailing list (questions@PostgreSQL.ORG).

PostgreSQL is free and the complete source is available.

WWW: http://www.postgresql.org/
SVNWeb : Homepage : Distfiles Availability : PortsMon
Slave ports
  1. databases/postgresql92-client
  2. databases/postgresql92-contrib
  3. databases/postgresql92-docs
  4. databases/postgresql92-plperl
  5. databases/postgresql92-plpython
  6. databases/postgresql92-pltcl

NOTE: FreshPorts displays only information on required and default dependencies. Optional dependencies are not covered.

Build dependencies:
  1. libcrypto.so.8 : security/openssl
  2. gmake : devel/gmake
  3. msgfmt : devel/gettext-tools
Runtime dependencies:
  1. libcrypto.so.8 : security/openssl
Library dependencies:
  1. libpq.so.5 : databases/postgresql92-client
  2. libintl.so : devel/gettext-runtime

This port is required by:

for Build for Run * - deleted ports are only shown under the This port is required by section. It was harder to do for the Required section. Perhaps later...

To install the port: cd /usr/ports/databases/postgresql92-server/ && make install clean
To add the package: pkg install databases/postgresql92-server


Configuration Options
===> The following configuration options are available for postgresql92-server-9.2.13_1:
     DEBUG=off: Builds with debugging symbols
     DTRACE=off: Build with DTrace probes
     GSSAPI=off: Build with GSSAPI support
     ICU=off: Use ICU for unicode collation
     INTDATE=on: Builds with 64-bit date/time type
     LDAP=off: Build with LDAP authentication support
     NLS=on: Use internationalized messages
     OPTIMIZED_CFLAGS=off: Builds with compiler optimizations (-O3)
     PAM=off: Build with PAM Support
     SSL=on: Build with OpenSSL support
     TZDATA=on: Use internal timezone database
====> Build with kerberos provider support: you can only select none or one of them
     MIT_KRB5=off: Build with MIT kerberos support
     HEIMDAL_KRB5=off: Builds with Heimdal kerberos
===> Use 'make config' to modify these settings

USES:
tar:bzip2 cpe gmake pgsql:9.2 gettext

Master Sites:
  1. ftp://ftp.postgresql.org/pub/source/v9.2.13/
  2. http://distcache.FreeBSD.org/ports-distfiles/postgresql/
  3. http://ftp.postgresql.org/pub/source/v9.2.13/
  4. https://ftp.postgresql.org/pub/source/v9.2.13/
Notes from UPDATING
These upgrade notes are taken from /usr/ports/UPDATING
  • 2012-05-30
    Affects: users of databases/postgresql*-server
    Author: jgh@FreeBSD.org
    Reason: 
      Affected users are those who use the crypt(text, text) function with
      DES encryption in the optional pg_crypto module. Passwords affected
      are those that contain characters that cannot be represented with
      7-bit ASCII. If a password contains a character that has the most
      significant bit set (0x80), and DES encryption is used, that character
      and all characters after it will be ignored.
    
    

Number of commits found: 71

Commit History - (may be incomplete: see SVNWeb link above for full details)
DateByDescription
24 Jul 2015 06:05:23
Original commit files touched by this commit  9.2.13_1
Revision:392771
bapt search for other commits by this committer
Really fix ldap option
22 Jul 2015 23:20:03
Original commit files touched by this commit  9.2.13_1
Revision:392703
bapt search for other commits by this committer
Fix ldap option
22 Jul 2015 23:10:40
Original commit files touched by this commit  9.2.13_1
Revision:392702
bapt search for other commits by this committer
Only defined options marked as server only for the servers
Remove (server) from the description
22 Jul 2015 22:56:56
Original commit files touched by this commit  9.2.13_1
Revision:392701
bapt search for other commits by this committer
UNIQUENAME is not used anymore for long to save options
22 Jul 2015 22:45:36
Original commit files touched by this commit  9.2.13_1
Revision:392699
bapt search for other commits by this committer
Simplify a bit the Makefiles

Use OPTIONS_SUB to automatically PLIST_SUB
Use OPTIONS helpers
22 Jul 2015 21:46:28
Original commit files touched by this commit  9.2.13_1
Revision:392696
bapt search for other commits by this committer
Cleanup plist and avoid useless @exec
12 Jun 2015 13:00:50
Original commit files touched by this commit  9.2.13
Revision:389267
girgen search for other commits by this committer
Update PostgreSQL to latest versions.

Earlier update releases attempted to fix an issue in PostgreSQL 9.3 and 9.4
with "multixact wraparound", but failed to account for issues doing multixact
cleanup during crash recovery. This could cause servers to be unable to restart
after a crash. As such, all users of 9.3 and 9.4 should apply this update as
soon as possible.

URL:	http://www.postgresql.org/about/news/1592/
05 Jun 2015 14:57:29
Original commit files touched by this commit  9.2.12
Revision:388585
girgen search for other commits by this committer
Update PostgreSQL to latest versions.
The update is mostly to fix the file persmission problem described
in the URL below. You might want to wait until next upgrade, depending
on you local configuration.
URL:	http://www.postgresql.org/about/news/1590/
22 May 2015 23:22:20
Original commit files touched by this commit  9.2.11
Revision:387089
girgen search for other commits by this committer
Update PostgreSQL ports to latest version.

Data Corruption Fix

For users of PostgreSQL versions 9.3 or 9.4, this release fixes a problem where
the database will fail to protect against "multixact wraparound", resulting in
data corruption or loss. Users with a high transaction rate (1 million or more
per hour) in a database with many foreign keys are especially vulnerable. We
strongly urge all users of 9.4 and 9.3 to update their installations in the
next few days.

Users of versions 9.2 and earlier are not affected by this issue.

Security:	fc38cd83-00b3-11e5-8ebd-0026551a22dc
14 May 2015 10:15:09
Original commit files touched by this commit  9.2.10_1
Revision:386312 This port version is marked as vulnerable.
mat search for other commits by this committer
MASTER_SITES cleanup.

- Replace ${MASTER_SITE_FOO} with FOO.
- Merge MASTER_SITE_SUBDIR into MASTER_SITES when possible. (This means 99.9%
  of the time.)
- Remove occurrences of MASTER_SITE_LOCAL when no subdirectory was present and
  no hint of what it should be was present.
- Fix some logic.
- And generally, make things more simple and easy to understand.

While there, add magic values to the FESTIVAL, GENTOO, GIMP, GNUPG, QT and
SAMBA macros.

Also, replace some EXTRACT_SUFX occurences with USES=tar:*.

Checked by:	make fetch-urlall-list
With hat:	portmgr
Sponsored by:	Absolight
19 Apr 2015 11:12:22
Original commit files touched by this commit  9.2.10_1
Revision:384279 This port version is marked as vulnerable.
girgen search for other commits by this committer
Commit the missing part of last commit: Chase upcoming update of ICU to 5.5.
18 Apr 2015 12:37:23
Original commit files touched by this commit  9.2.10_1
Revision:384223 This port version is marked as vulnerable.
girgen search for other commits by this committer
Chase upcoming update of ICU to 5.5.
05 Apr 2015 09:00:59
Original commit files touched by this commit  9.2.10
Revision:383272 This port version is marked as vulnerable.
girgen search for other commits by this committer
remove redundant cpe markers on the slave ports
25 Mar 2015 09:33:53
Original commit files touched by this commit  9.2.10
Revision:382201 This port version is marked as vulnerable.
marino search for other commits by this committer
databases category: Remove $PTHREAD_LIBS

Note: virtuoso did not pass check-plist from before, so it was fixed.

approved by:	PTHREAD blanket
20 Mar 2015 08:58:15
Original commit files touched by this commit  9.2.10
Revision:381721 This port version is marked as vulnerable.
robak search for other commits by this committer
databases/postgresql92-server: add CPE information

- Maintainer's timeout (pgsql@FreeBSD.org)

PR:		197487
Submitted by:	Shun <shun.fbsd.pr@dropcut.net>
07 Feb 2015 17:05:08
Original commit files touched by this commit  9.2.10
Revision:378604 This port version is marked as vulnerable.
girgen search for other commits by this committer
Revert the change from readline to libedit, and instead make libedit optional.
PR:	ports/197362
05 Feb 2015 22:54:35
Original commit files touched by this commit  9.2.10
Revision:378500 This port version is marked as vulnerable.
girgen search for other commits by this committer
Update PostgreSQL-9.x to latests versions.

This update fixes multiple security issues reported in PostgreSQL over the past
few months. All of these issues require prior authentication, and some require
additional conditions, and as such are not considered generally urgent.
However, users should examine the list of security holes patched below in case
they are particularly vulnerable.

Security:	CVE-2015-0241,CVE-2015-0242,CVE-2015-0243,
		CVE-2015-0244,CVE-2014-8161
12 Nov 2014 09:53:42
Original commit files touched by this commit  9.2.9_1
Revision:372487 This port version is marked as vulnerable.
girgen search for other commits by this committer
Revert r247147.
We need -pthread in LDFLAGS for threaded extensions like plv8js to work.

PR:		175783
Submitted by:	Li-Wen Hsu <lwhsu@FreeBSD.org>
10 Sep 2014 13:34:54
Original commit files touched by this commit  9.2.9
Revision:367837 This port version is marked as vulnerable.
bapt search for other commits by this committer
Turn OPTIONS_SINGLE KRB5 into an OPTIONS_RADIO like it is supposed to be

PR:		193451
Submitted by:	dmitry2004@yandex.ru
25 Aug 2014 17:53:27
Original commit files touched by this commit  9.2.9
Revision:366114 This port version is marked as vulnerable.
crees search for other commits by this committer
Convert pgsql ports to use USES+=pgsql

Reviewed by:	bapt
02 Aug 2014 07:01:54
Original commit files touched by this commit  9.2.9
Revision:363792 This port version is marked as vulnerable.
mva search for other commits by this committer
- Unbreak builds after the lang/python27 update (r363790)

Exp-run:	192242, 192244
30 Jul 2014 18:21:47
Original commit files touched by this commit  9.2.9
Revision:363500 This port version is marked as vulnerable.
crees search for other commits by this committer
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.
24 Jul 2014 18:34:16
Original commit files touched by this commit  9.2.8_2
Revision:362835 This port version is marked as vulnerable.
tijl search for other commits by this committer
net/openldap24-*:
- Convert to USES=libtool and bump dependent ports
- Avoid USE_AUTOTOOLS
- Don't use PTHREAD_LIBS
- Use MAKE_CMD

databases/glom:
- Drop :keepla
- Add INSTALL_TARGET=install-strip

databases/libgda4* databases/libgda5*:
- Convert to USES=libtool and bump dependent ports
- USES=tar:xz
- Use INSTALL_TARGET=install-strip
- Use @sample
(Only the first 15 lines of the commit message are shown above View all of this commit message)
24 Jun 2014 22:34:28
Original commit files touched by this commit  9.2.8_1
Revision:359153 This port version is marked as vulnerable.
bapt search for other commits by this committer
Properly call MAKE_CMD
09 Jun 2014 21:57:43
Original commit files touched by this commit  9.2.8_1
Revision:357209 This port version is marked as vulnerable.
girgen search for other commits by this committer
Prepare for upcoming ICU-5.3 upgrade.
16 Apr 2014 18:28:50
Original commit files touched by this commit  9.2.8_1
Revision:351411 This port version is marked as vulnerable.
zeising search for other commits by this committer
The FreeBSD x11@ and graphics team proudly presents
a zeising, kwm production, with help from dumbbell, bdrewery:

NEW XORG ON FREEBSD 9-STABLE AND 10-STABLE

This update switches over to use the new xorg stack by default on FreeBSD 9
and 10 stable, on osversions where vt(9) is available.
It is still possible to use the old stack by specifying WITHOUT_NEW_XORG in
/etc/make.conf .
FreeBSD 8-STABLE and released versions of FreeBSD still use
the old version.
A package repository with binary packages for new xorg will
be available soon.

This patch also contains updates of libxcb and related ports, pixman, as well
(Only the first 15 lines of the commit message are shown above View all of this commit message)
21 Mar 2014 08:15:26
Original commit files touched by this commit  9.2.8
Revision:348732 This port version is marked as vulnerable.
girgen search for other commits by this committer
Fix mistake with ossp-uuid: don't use --with-ossp-uuid, since it will need
the ossp library present, and then we never use it.
20 Mar 2014 23:09:05
Original commit files touched by this commit  9.2.8
Revision:348722 This port version is marked as vulnerable.
girgen search for other commits by this committer
Fixed bad filesize in distinfo
20 Mar 2014 13:43:16
Original commit files touched by this commit  9.2.8
Revision:348685 This port version is marked as vulnerable.
girgen search for other commits by this committer
The PostgreSQL Global Development Group has released an update to all supported
version of the database system, including versions 9.3.4, 9.2.8, 9.1.13,
9.0.17, and 8.4.21. This minor release fixes a data corruption issue with
replication and crash recovery in version 9.3, as well as several other minor
issues in all versions.  All users of version 9.3 are urged to update their
installations at the next possible downtime.  Users of older versions should
update at their convenience.

The data corruption issue in PostgreSQL 9.3 affects binary replication
standbys, servers being recovered from point-in-time-recovery backup, and
standalone servers which recover from a system crash. The bug causes
unrecoverable index corruption during recovery due to incorrect replay of row
locking operations.  This can then cause query results to be inconsistent
depending on whether or not an index is used, and eventually lead to primary
key violations and similar issues.  For this reason, users are encouraged to
(Only the first 15 lines of the commit message are shown above View all of this commit message)
26 Feb 2014 17:24:36
Original commit files touched by this commit  9.2.7
Revision:346217 This port version is marked as vulnerable.
antoine search for other commits by this committer
Stage support

Reviewed by:	postgresql@
Tested by:	miwi and me
20 Feb 2014 18:11:38
Original commit files touched by this commit  9.2.7
Revision:345257 This port version is marked as vulnerable.
girgen search for other commits by this committer
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
		CVE-2014-0064,CVE-2014-0065,CVE-2014-0066,CVE-2014-0067
10 Feb 2014 23:46:46
Original commit files touched by this commit  9.2.6_1
Revision:343714 This port version is marked as vulnerable.
girgen search for other commits by this committer
fix messed up file sizes for icu patch
10 Feb 2014 16:32:41
Original commit files touched by this commit  9.2.6_1
Revision:343650 This port version is marked as vulnerable.
girgen search for other commits by this committer
Chase ICU update
07 Feb 2014 11:44:09
Original commit files touched by this commit  9.2.6_1
Revision:343214 This port version is marked as vulnerable.
bapt search for other commits by this committer
Chase boost and icu bump
While here convert some LIB_DEPENDS
11 Dec 2013 18:08:53
Original commit files touched by this commit  9.2.6
Revision:336187 This port version is marked as vulnerable.
bapt search for other commits by this committer
In preparation for making libtool generate libraries with a sane name, fix all
LIB_DEPENDS in databases
05 Dec 2013 15:59:53
Original commit files touched by this commit  9.2.6
Revision:335673 This port version is marked as vulnerable.
girgen search for other commits by this committer
The PostgreSQL Global Development Group has released a critical update
to all supported versions of the PostgreSQL database system, which
includes minor versions 9.3.2, 9.2.6, 9.1.11, 9.0.15, and 8.4.19. This
update fixes three serious data-loss bugs affecting replication and
database maintenance.  All users are urged to update their
installations at the earliest opportunity.

URL:	http://www.postgresql.org/about/news/1492/
28 Oct 2013 18:52:22
Original commit files touched by this commit  9.2.5
Revision:331888 This port version is marked as vulnerable.
sunpoet search for other commits by this committer
- Fix PLIST for python3

Submitted by:	sunpoet (myself)
Approved by:	crees (pgsql)
15 Oct 2013 17:17:06
Original commit files touched by this commit  9.2.5
Revision:330414 This port version is marked as vulnerable.
sunpoet search for other commits by this committer
- Remove DISTV: only used in PKGNAMESUFFIX and complained by portlint
- Convert to new LIB_DEPENDS format for postgresql*-contrib

Submitted by:	sunpoet (myself)
Reviewed by:	crees (pgsql)
Approved by:	jgh (pgsql)
12 Oct 2013 00:59:50
Original commit files touched by this commit  9.2.5
Revision:330109 This port version is marked as vulnerable.
girgen search for other commits by this committer
Update PostgreSQL ports to 9.3.1, 9.2.5, 9.1.10, 9.0.14, and 8.4.18.

Note that users of the hstore extension on version 9.3 must take an additional,
post upgrade step of running "ALTER EXTENSION hstore UPDATE" in each database
after update.

URL:	http://www.postgresql.org/about/news/1487/
10 Oct 2013 00:09:35
Original commit files touched by this commit  9.2.4
Revision:329946 This port version is marked as vulnerable.
jgh search for other commits by this committer
- Fix pkg name collision

Reviewed by: pgsql@
With hat: pgsql@
07 Oct 2013 20:03:38
Original commit files touched by this commit  9.2.4
Revision:329729 This port version is marked as vulnerable.
jgh search for other commits by this committer
- revert r329725

Reported by: qat@
With hat: pgsql@
07 Oct 2013 19:04:04
Original commit files touched by this commit  9.2.4
Revision:329725 This port version is marked as vulnerable.
jgh search for other commits by this committer
- Fix pkg name collision

Reviewed by: crees@
With hat: pgsql@
20 Sep 2013 16:13:49
Original commit files touched by this commit  9.2.4
Revision:327717 This port version is marked as vulnerable.
bapt search for other commits by this committer
Add NO_STAGE all over the place in preparation for the staging support (cat:
databases)
07 Jul 2013 00:15:47
Original commit files touched by this commit  9.2.4
Revision:322415 This port version is marked as vulnerable.
jgh search for other commits by this committer
- convert from USE_GMAKE to USES=gmake
- trim historical headers

With hat: pgsql@
12 May 2013 21:09:39
Original commit files touched by this commit  9.2.4
Revision:317978 This port version is marked as vulnerable.
girgen search for other commits by this committer
Update postgresql93-client to properly depend on pkgconfig
Reported by: Ports-QAT
06 May 2013 18:37:00
Original commit files touched by this commit  9.2.4
Revision:317540 This port version is marked as vulnerable.
crees search for other commits by this committer
Don't build client with ldap-- this is unnecessary and causes build breakage
for package building because of lack of LDAP installation.

PR:		ports/177381
Tested by:	Chris Dukes <chris.dukes.aix@gmail.com>
28 Apr 2013 18:15:06
Original commit files touched by this commit  9.2.4
Revision:316740 This port version is marked as vulnerable.
crees search for other commits by this committer
databases/postgresql-server ports: Unbreak NLS

Submitted by:	bapt
28 Apr 2013 14:00:03
Original commit files touched by this commit  9.2.4
Revision:316726 This port version is marked as vulnerable.
crees search for other commits by this committer
databases/postgresql{84,91,92}-server: Readd bsd.port.pre.mk; it is required for
checking existence of files in FILESDIR
26 Apr 2013 15:10:57
Original commit files touched by this commit  9.2.4
Revision:316620 This port version is marked as vulnerable.
bapt search for other commits by this committer
Convert USE_GETTEXT -> USES=gettext

While here:
- Trim headers
- Remove some useless pre.mk/post.mk
- Convert to optionsng
04 Apr 2013 13:21:23
Original commit files touched by this commit  9.2.4
Revision:315718 This port version is marked as vulnerable.
girgen search for other commits by this committer
The PostgreSQL Global Development Group has released a security
update to all current versions of the PostgreSQL database system,
including versions 9.2.4, 9.1.9, 9.0.13, and 8.4.17. This update
fixes a high-exposure security vulnerability in versions 9.0 and
later. All users of the affected versions are strongly urged to apply
the update *immediately*.

A major security issue (for versions 9.x only) fixed in this release,
[CVE-2013-1899](http://cve.mitre.org/cgi-bin/cvename.cgi?name=CVE-2013-1899),
makes it possible for a connection request containing a database name
that begins with "-" to be crafted that can damage or destroy files
within a server's data directory. Anyone with access to the port the
PostgreSQL server listens on can initiate this request. This issue was
discovered by Mitsumasa Kondo and Kyotaro Horiguchi of NTT Open Source
Software Center.
(Only the first 15 lines of the commit message are shown above View all of this commit message)
08 Feb 2013 07:54:10
Original commit files touched by this commit  9.2.3
Revision:311915 This port version is marked as vulnerable.
girgen search for other commits by this committer
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.

URL:	http://www.postgresql.org/about/news/1446/
Security: http://cve.mitre.org/cgi-bin/cvename.cgi?name=CVE-2013-0255
22 Jan 2013 18:32:00
Original commit files touched by this commit  9.2.2_1
Revision:310833 This port version is marked as vulnerable.
crees search for other commits by this committer
Remove versioned PKGNAMESUFFIX from -plpython ports; the versions differ anyway

Submitted by:	sunpoet
22 Jan 2013 17:59:42
Original commit files touched by this commit  9.2.2_1
Revision:310832 This port version is marked as vulnerable.
crees search for other commits by this committer
Fix package build for -plpython

Although the plpython work was done by rm, this problem was actually my fault

Noticed by:	sunpoet
20 Jan 2013 10:17:45
Original commit files touched by this commit  9.2.2_1
Revision:310679 This port version is marked as vulnerable.
rm search for other commits by this committer
- add pkg-plist changes, forgotten in r310678
- fix portname in MOVED
- remove trailing whitespace in MOVED, while here
27 Dec 2012 21:11:42
Original commit files touched by this commit  9.2.2_1
Revision:309555 This port version is marked as vulnerable.
jgh search for other commits by this committer
- remove broken configurable non-default user/group for postgresql-server
- while here fix formatting of new header

With hat: pgsql@
19 Dec 2012 16:13:30
Original commit files touched by this commit  9.2.2_1
Revision:309247 This port version is marked as vulnerable.
girgen search for other commits by this committer
Chase ICU update properly and bump PORTREVISION
19 Dec 2012 16:03:59
Original commit files touched by this commit  9.2.2
Revision:309246 This port version is marked as vulnerable.
girgen search for other commits by this committer
Chase ICU update to 50
10 Dec 2012 16:44:10
Original commit files touched by this commit  9.2.2
Revision:308614 This port version is marked as vulnerable.
girgen search for other commits by this committer
Feature safe: yes
PR: 174336
fix typo
06 Dec 2012 16:40:36
Original commit files touched by this commit  9.2.2
Revision:308391 This port version is marked as vulnerable.
girgen search for other commits by this committer
The PostgreSQL Global Development Group has released an update to all current
versions of the PostgreSQL database system, including versions 9.2.2, 9.1.7,
9.0.11, 8.4.15, and 8.3.22.  Users of PostgreSQL Hot Standby replication
should update at the next possible opportunity. Other users should update
at their next maintenance window.

Deprecate the 8.3.22 version, since it is near end-of-life.

URL:	http://www.postgresql.org/about/news/1430/

Feature safe: yes
16 Oct 2012 17:28:22
Original commit files touched by this commit  9.2.1
Revision:305983 This port version is marked as vulnerable.
jgh search for other commits by this committer
- adopt optionsNG

with hat pgsql@
Feature safe: yes
24 Sep 2012 22:03:11
Original commit files touched by this commit  9.2.1
Revision:304804 This port version is marked as vulnerable.
girgen search for other commits by this committer
Update PostgreSQL to 9.2.1, 9.1.6, 9.0.10, 8.4.14 and 8.3.21 respectively.

This update fixes critical issues for major versions 9.1 and 9.2, and
users running those versions should apply it as soon as possible.

URL:	http://www.postgresql.org/about/news/1416/
10 Sep 2012 11:53:41
Original commit files touched by this commit  9.2.0
Revision:304028 This port version is marked as vulnerable.
girgen search for other commits by this committer
PostgreSQL 9.2 is released.

"PostgreSQL 9.2 will ship with native JSON support,
covering indexes, replication and performance improvements,
and many more features."

Read more at the web site.

URL:	http://www.postgresql.org/about/news/1415/
27 Aug 2012 14:16:01
Original commit files touched by this commit  9.2.r1
girgen search for other commits by this committer
update postgresql 9.2 to RC1
19 Aug 2012 15:24:30
Original commit files touched by this commit  9.2.b4
crees search for other commits by this committer
Use pre-build instead of pre-everything for backupwarning-- stop making people
wait before fetching etc

Suggested by:	ohauer
Discussed with:	girgen

While here, fix package for postgresql92-server
17 Aug 2012 20:32:44
Original commit files touched by this commit  9.2.b4
girgen search for other commits by this committer
update postgresql 9.2 to beta4
10 Aug 2012 11:10:12
Original commit files touched by this commit  9.2.b3
crees search for other commits by this committer
Fix fetch

Submitted by:	beat
07 Aug 2012 07:49:01
Original commit files touched by this commit  9.2.b3
girgen search for other commits by this committer
The PostgreSQL Global Development Group announces the third beta release
of 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 3 as soon as possible.

9.2 Beta 3 includes multiple bug fixes to earlier beta releases, fixing
almost all known outstanding issues as of last week.  Among them are:

* Multiple documentation updates
* Apply translation updates
* Fixes to transaction log and replication issues with SP-GiST
* Replace libpq's "row processor" API with a "single row" mode.
* Fix WITH issue with set operations (UNION/INTERSECT/EXCEPT)
* Improvements to Autovacuum cancellation
* Multiple pg_upgrade fixes
(Only the first 15 lines of the commit message are shown above View all of this commit message)
04 Jun 2012 11:00:52
Original commit files touched by this commit  9.2.b2
girgen search for other commits by this committer
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.

URL:      http://www.postgresql.org/about/news/1398/

Security: http://cve.mitre.org/cgi-bin/cvename.cgi?name=CVE-2012-2143
          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.

Security: http://cve.mitre.org/cgi-bin/cvename.cgi?name=CVE-2012-2655
          Ignore SECURITY DEFINER and SET attributes for a procedural
language’s call handle
30 May 2012 22:26:15
Original commit files touched by this commit  9.2.b1_1
jgh search for other commits by this committer
- Address postgresql*-servers for crypt vulnerability (CVE-2012-2143)

http://www.postgresql.org/about/news/1397/

With hat: pgsql
15 May 2012 22:14:55
Original commit files touched by this commit  9.2.b1
girgen search for other commits by this committer
The PostgreSQL Global Development Group announces the beta release of
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
(Only the first 15 lines of the commit message are shown above View all of this commit message)
11 May 2012 08:35:51
Original commit files touched by this commit  9.1.3
 This port version is marked as vulnerable.
girgen search for other commits by this committer
Repository copy from postgresql91-server

Number of commits found: 71

Login
User Login
Create account

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

This site
What is FreshPorts?
About the authors
FAQ
How big is it?
The latest upgrade!
Privacy
Forums
Blog
Contact

Search
Enter Keywords:
 
more...

Latest Vulnerabilities
bind910Jul 28
bind99Jul 28
logstashJul 27
openssh-portableJul 27
chromiumJul 25
wordpress*Jul 24
wordpress*Jul 24
wordpress*Jul 24
wordpress*Jul 24
wordpress-zh_TW*Jul 24
libidnJul 23
opensaml2Jul 23
shibboleth2-spJul 23
soxJul 23
soxJul 23

32 vulnerabilities affecting 83 ports have been reported in the past 14 days

* - modified, not new

All vulnerabilities


Ports
Home
Categories
Deleted ports
Sanity Test Failures
Newsfeeds

Statistics
Graphs
NEW Graphs (Javascript)
Traffic

Calculated hourly:
Port count 25083
Broken 201
Deprecated 105
Ignore 499
Forbidden 1
Restricted 204
No CDROM 94
Vulnerable 46
Expired 0
Set to expire 93
Interactive 0
new 24 hours 7
new 48 hours14
new 7 days34
new fortnight79
new month200

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