notbugAs an Amazon Associate I earn from qualifying purchases.
Want a good read? Try FreeBSD Mastery: Jails (IT Mastery Book 15)
Want a good monitor light? See my photosAll times are UTC
Ukraine
This referral link gives you 10% off a Fastmail.com account and gives me a discount on my Fastmail account.

Get notified when packages are built

A new feature has been added. FreshPorts already tracks package built by the FreeBSD project. This information is displayed on each port page. You can now get an email when FreshPorts notices a new package is available for something on one of your watch lists. However, you must opt into that. Click on Report Subscriptions on the right, and New Package Notification box, and click on Update.

Finally, under Watch Lists, click on ABI Package Subscriptions to select your ABI (e.g. FreeBSD:14:amd64) & package set (latest/quarterly) combination for a given watch list. This is what FreshPorts will look for.

Port details
postgresql92-contrib The contrib utilities from the PostgreSQL distribution
9.2.24_1 databases Deleted on this many watch lists=2 search for ports that depend on this port Find issues related to this port Report an issue related to this port View this port on Repology. pkg-fallout 9.2.24_1Version of this port present on the latest quarterly branch.
Deprecated DEPRECATED: PostgreSQL 9.2 support has reached End-of-line. Please upgrade to a later version.
Expired This port expired on: 2017-04-05
Maintainer: pgsql@FreeBSD.org search for ports maintained by this maintainer
Port Added: 2012-05-15 22:15:58
Last Update: 2018-02-10 22:14:39
SVN Revision: 461440
License: PostgreSQL
WWW:
http://www.postgresql.org/
Description:
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/
Homepage    cgit ¦ GitHub ¦ GitHub ¦ GitLab ¦ SVNWeb

Manual pages:
FreshPorts has no man page information for this port.
pkg-plist: as obtained via: make generate-plist
There is no configure plist information for this port.
Dependency lines:
  • postgresql92-contrib>0:databases/postgresql92-contrib
No installation instructions:
This port has been deleted.
PKGNAME: postgresql92-contrib
Flavors: there is no flavor information for this port.
distinfo:
TIMESTAMP = 1510172181 SHA256 (postgresql/postgresql-9.2.24.tar.bz2) = a754c02f7051c2f21e52f8669a421b50485afcde9a581674d6106326b189d126 SIZE (postgresql/postgresql-9.2.24.tar.bz2) = 16552576

Expand this list (2 items)

Collapse this list.

SHA256 (postgresql/pg-9218-icu-2016-08-10.diff.gz) = 2f9c831b3dff866f0b2f6f2a9ef771a4045486bc252a851aadc73c50d376319d SIZE (postgresql/pg-9218-icu-2016-08-10.diff.gz) = 5587

Collapse this list.


No package information for this port in our database
Sometimes this happens. Not all ports have packages.
Master port: databases/postgresql92-server
Dependencies
NOTE: FreshPorts displays only information on required and default dependencies. Optional dependencies are not covered.
Build dependencies:
  1. bison : devel/bison
  2. gmake : devel/gmake
Library dependencies:
  1. libxslt.so : textproc/libxslt
  2. libxml2.so : textproc/libxml2
  3. libpq.so.5 : databases/postgresql92-client
There are no ports dependent upon this port

Configuration Options:
No options to configure
Options name:
N/A
USES:
bison pgsql:9.2 tar:bzip2 cpe gmake
FreshPorts was unable to extract/find any pkg message
Master Sites:
Expand this list (1 items)
Collapse this list.
  1. https://ftp.postgresql.org/pub/source/v9.2.24/
Collapse this list.

Number of commits found: 21

Commit History - (may be incomplete: for full details, see links to repositories near top of page)
This is a slave port. You may also want to view the commits to the master port: databases/postgresql92-server
CommitCreditsLog message
9.2.24_1
10 Feb 2018 22:14:39
Revision:461440Original commit files touched by this commit
rene search for other commits by this committer
Removed expired postgresql92 ports.
9.2.24_1
08 Feb 2018 17:38:36
Revision:461251Original commit files touched by this commit
girgen search for other commits by this committer
Update to latest versions of PostgreSQL

2018-02-08 Security Update Release
==================================

The PostgreSQL Global Development Group has released an update to all supported
versions of our database system, including 10.2, 9.6.7, 9.5.11, 9.4.16, 9.3.21.
This release fixes two security issues. This release also fixes issues with
VACUUM, GIN indexes, and hash indexes that could lead to data corruption, as
well as fixes for using parallel queries and logical replication.

All users using the affected versions of PostgreSQL should update as soon as
possible. Please see the notes on "Updating" below for any post-update steps
that may be required.
(Only the first 15 lines of the commit message are shown above View all of this commit message)
9.2.23
05 Sep 2017 09:27:11
Revision:449278Original commit files touched by this commit
girgen search for other commits by this committer
The PostgreSQL Global Development Group has released an update to all
supported versions of our database system, including 9.6.5, 9.5.9,
9.4.14, 9.3.19, and 9.2.23.

This release includes fixes that prevent a crash in pg_restore when
using parallel mode. It also patches over a few other bugs reported
since the last releases in August.

Additionally, in 9.4.14 only, there is a fix to an issue with walsenders
preventing primary-server shutdown unless immediate shutdown mode is used.

Users should plan to update at the next convenient downtime.

Bug Fixes and Improvements
(Only the first 15 lines of the commit message are shown above View all of this commit message)
9.2.16
01 Apr 2016 14:00:57
Revision:412346Original commit files touched by this commit
mat search for other commits by this committer
Remove ${PORTSDIR}/ from dependencies, categories d, e, f, and g.

With hat:	portmgr
Sponsored by:	Absolight
9.2.14
08 Oct 2015 21:25:01
Revision:398895Original commit files touched by this commit
girgen search for other commits by this committer
Update PostgreSQL port to latest version.

Two security issues have been fixed in this release which affect users
of specific PostgreSQL features:

CVE-2015-5289: json or jsonb input values constructed from arbitrary
user input can crash the PostgreSQL server and cause a denial of
service.

CVE-2015-5288: The crypt( function included with the optional pgCrypto
extension could be exploited to read a few additional bytes of memory.
No working exploit for this issue has been developed.

This update will also disable SSL renegotiation by default;
previously, it was enabled by default.   SSL renegotiation will be
removed entirely in PostgreSQL versions 9.5 and later.

URL:		http://www.postgresql.org/about/news/1615/
Security:	CVE-2015-5288 CVE-2015-5289
9.2.13_1
06 Oct 2015 08:47:43
Revision:398690Original commit files touched by this commit
girgen search for other commits by this committer
Fix broken XML support.

PR:	ports/202649
9.2.10
25 Mar 2015 09:33:53
Revision:382201Original commit files touched by this commit
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
9.2.10
05 Feb 2015 22:54:35
Revision:378500Original commit files touched by this commit
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
9.2.9_1
25 Aug 2014 17:53:27
Revision:366114Original commit files touched by this commit
crees search for other commits by this committer
Convert pgsql ports to use USES+=pgsql

Reviewed by:	bapt
9.2.8_1
16 Apr 2014 18:28:50
Revision:351411Original commit files touched by this commit
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)
9.2.8
21 Mar 2014 08:15:26
Revision:348732Original commit files touched by this commit
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.
9.2.8
20 Mar 2014 13:43:16
Revision:348685Original commit files touched by this commit
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)
9.2.7
26 Feb 2014 17:24:36
Revision:346217Original commit files touched by this commit
antoine search for other commits by this committer
Stage support

Reviewed by:	postgresql@
Tested by:	miwi and me
9.2.5
15 Oct 2013 17:17:06
Revision:330414Original commit files touched by this commit
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)
9.2.4
10 Oct 2013 00:09:35
Revision:329946Original commit files touched by this commit
jgh search for other commits by this committer
- Fix pkg name collision

Reviewed by: pgsql@
With hat: pgsql@
9.2.4
07 Oct 2013 20:03:38
Revision:329729Original commit files touched by this commit
jgh search for other commits by this committer
- revert r329725

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

Reviewed by: crees@
With hat: pgsql@
9.2.4
20 Sep 2013 16:13:49
Revision:327717Original commit files touched by this commit
bapt search for other commits by this committer
Add NO_STAGE all over the place in preparation for the staging support (cat:
databases)
9.2.3
08 Mar 2013 11:32:12
Revision:313635Original commit files touched by this commit
bapt search for other commits by this committer
Convert USE_BISON to USES= bison

It brings bison as a build dependency in case it is set the following way:
USES= bison or USES= bison:build

it brings bison as a run dependency in case it is set the following way:
USES= bison:run

it brings bison both as a run and build dependency in case it the set the
following way:
USES= bison:both

While here trim some headers
Convert some USE_GNOME= gnomehack to USES= pathfix
9.2.1
16 Oct 2012 17:28:22
Revision:305983Original commit files touched by this commit
jgh search for other commits by this committer
- adopt optionsNG

with hat pgsql@
Feature safe: yes
9.2.b1
15 May 2012 22:14:55
Original commit files touched by this commit
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)

Number of commits found: 21