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-client PostgreSQL database (client)
9.2.13 databases on this many watch lists=5 search for ports that depend on this port 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: 15 May 2012 22:15:58
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
Master port: databases/postgresql92-server

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. libintl.so : devel/gettext-runtime

This port is required by:

for Libraries * - 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-client/ && make install clean
To add the package: pkg install databases/postgresql92-client


Configuration Options
===> The following configuration options are available for postgresql92-client-9.2.13:
     DEBUG=off: Builds with debugging symbols
     GSSAPI=off: Build with GSSAPI support
     LIBEDIT=off: Use non-GPL libedit instead of readline
     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
====> 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 readline 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/

Number of commits found: 12

Commit History - (may be incomplete: see SVNWeb link above for full details)
DateByDescription
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
07 Feb 2015 17:05:08
Original commit files touched by this commit  9.2.10_1
Revision:378604
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
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
25 Aug 2014 17:53:27
Original commit files touched by this commit  9.2.9
Revision:366114
crees search for other commits by this committer
Convert pgsql ports to use USES+=pgsql

Reviewed by:	bapt
30 Jun 2014 23:07:29
Original commit files touched by this commit  9.2.8_1
Revision:359941
bapt search for other commits by this committer
Fixes build with readline from ports
26 Feb 2014 17:24:36
Original commit files touched by this commit  9.2.7
Revision:346217
antoine search for other commits by this committer
Stage support

Reviewed by:	postgresql@
Tested by:	miwi and me
15 Oct 2013 17:17:06
Original commit files touched by this commit  9.2.5
Revision:330414
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)
10 Oct 2013 00:09:35
Original commit files touched by this commit  9.2.4
Revision:329946
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
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
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
bapt search for other commits by this committer
Add NO_STAGE all over the place in preparation for the staging support (cat:
databases)
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)

Number of commits found: 12

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
xen-toolsAug 04
libidn*Aug 03
chicken*Jul 31
net-snmpJul 31
net-snmpJul 31
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

14 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 25085
Broken 198
Deprecated 106
Ignore 499
Forbidden 1
Restricted 204
No CDROM 94
Vulnerable 43
Expired 62
Set to expire 94
Interactive 0
new 24 hours 4
new 48 hours4
new 7 days14
new fortnight48
new month156

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