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

Port details
postgresql92-server 9.2.4 databases on this many watch lists=8 search for ports that depend on this port An older version of this port was marked as vulnerable.
The most advanced open-source database available anywhere
Maintained by: 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 : Main Web Site : 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 required dependencies information. Optional dependencies are not covered.

Required To Build:
  1. security/openssl
  2. devel/gmake
Required To Run:
  1. security/openssl
Required Libraries:
  1. textproc/libxml2
  2. devel/gettext
  3. databases/postgresql92-client

This port is required by:

for Build for Run

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


Configuration Options
===> The following configuration options are available for postgresql-server-9.2.4:
     DEBUG=off: Builds with debugging symbols
     DTRACE=off: Build with DTrace probes (server only)
     GSSAPI=off: Build with GSSAPI support
     ICU=off: Use ICU for unicode collation (server)
     INTDATE=on: Builds with 64-bit date/time type (server)
     KRB5=off: Build with kerberos provider support
     LDAP=off: Build with LDAP authentication support (server only)
     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 (server)
     XML=on: Build with XML data type (server)
====> Options available for the single KRB5: you have to select exactly 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

Master Sites:
  1. ftp://ftp.FreeBSD.org/pub/FreeBSD/ports/distfiles/postgresql/
  2. ftp://ftp.ee.postgresql.org/mirrors/postgresql/source/v9.2.4/
  3. ftp://ftp.gr.postgresql.org/pub/databases/postgresql/source/v9.2.4/
  4. ftp://ftp.ie.postgresql.org/mirrors/ftp.postgresql.org/pub/source/v9.2.4/
  5. ftp://ftp.lv.postgresql.org/pub/postgresql/source/v9.2.4/
  6. ftp://ftp.postgresql.org/pub/source/v9.2.4/
  7. ftp://ftp.se.postgresql.org/pub/databases/relational/postgresql/source/v9.2.4/
  8. ftp://ftp2.cz.postgresql.org/pub/postgresql/source/v9.2.4/
  9. ftp://ftp2.it.postgresql.org/mirrors/postgres/source/v9.2.4/
  10. ftp://ftp2.nl.postgresql.org/mirror/postgresql/source/v9.2.4/
  11. ftp://ftp3.de.postgresql.org/pub/Mirrors/ftp.postgresql.org/source/v9.2.4/
  12. ftp://ftp3.ru.postgresql.org/pub/mirror/postgresql/pub/source/v9.2.4/
  13. ftp://ftp3.tw.postgresql.org/pub/postgresql/source/v9.2.4/
  14. ftp://ftp5.es.postgresql.org/mirror/postgresql/source/v9.2.4/
  15. ftp://ftp6.pl.postgresql.org/pub/postgresql/source/v9.2.4/
  16. ftp://ftp6.ro.postgresql.org/pub/mirrors/ftp.postgresql.org/source/v9.2.4/
  17. ftp://ftp7.pl.postgresql.org/pub/mirror/ftp.postgresql.org/source/v9.2.4/
  18. http://ftp2.jp.postgresql.org/pub/postgresql/source/v9.2.4/
  19. http://ring.nict.go.jp/archives/misc/db/postgresql/source/v9.2.4/
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: 27

Commit History - (may be incomplete: see SVNWeb link above for full details)
DateByDescription
12 May 2013 21:09:39
Original commit files touched by this commit  9.2.4
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
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
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
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
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
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
 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
 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
 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
 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
 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
 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
 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
 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
 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
 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
 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
 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
 This port version is marked as vulnerable.
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: 27

287e
Login
User Login
Create account

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

Search
Enter Keywords:
 
more...

Latest Vulnerabilities
otrsMay 23
otrsMay 23
otrsMay 23
otrsMay 23
chromiumMay 22
chromiumMay 22
firefox*May 21
firefox-devel*May 21
firefox-esr*May 21
firefox10*May 21
firefox15*May 21
firefox3*May 21
firefox3-devel*May 21
firefox35*May 21
firefox36*May 21

8 vulnerabilities affecting 24 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 24536
Broken 216
Deprecated 474
Ignore 631
Forbidden 2
Restricted 292
No CDROM 109
Vulnerable 25
Expired 132
Set to expire 512
Interactive 33
new 24 hours 4
new 48 hours10
new 7 days31
new fortnight62
new month215

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

Servers and bandwidth provided by
New York Internet, SuperNews, and RootBSD
Valid HTML, CSS, and RSS.
Copyright © 2000-2013 DVL Software Limited. All rights reserved.
0