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

I am looking for an LTO tape library. Do you have one to spare?
Port details
postgresql92-client PostgreSQL database (client)
9.2.9_1 databases on this many watch lists=5 search for ports that depend on this port
Maintained by: 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.

SVNWeb : Main Web Site : Distfiles Availability : PortsMon
Master port: databases/postgresql92-server

NOTE: FreshPorts displays only information on required and default dependencies. 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

This port is required by:

for Build for Libraries
  1. converters/osm2pgsql
  2. databases/apq-pgsql
  3. databases/courier-authlib-pgsql
  4. databases/fpc-postgres
  5. databases/grass
  6. databases/hashtypes
  7. databases/ip4r
  8. databases/iplike
  9. databases/jasperserver*
  10. databases/libdbi-drivers
  11. databases/libgda4-postgresql
  12. databases/libgda5-postgresql
  13. databases/libzdb
  14. databases/luasql-postgres
  15. databases/mantis
  16. databases/nagios-check_postgres_replication
  17. databases/p5-DBD-Pg
  18. databases/p5-DBD-Pg32
  19. databases/p5-Pg
  20. databases/pgaccess
  21. databases/pgadmin3
  22. databases/pgagent
  23. databases/pgpool-II
  24. databases/pgpool-II-22
  25. databases/pgpool-II-23
  26. databases/pgpool-II-30
  27. databases/pgrouting
  28. databases/pgsphere
  29. databases/pgtcl
  30. databases/pgworksheet
  31. databases/php5-pdo_pgsql
  32. databases/php5-pgsql
  33. databases/php53-pdo_pgsql
  34. databases/php53-pgsql
  35. databases/php55-pdo_pgsql
  36. databases/php55-pgsql
  37. databases/php56-pdo_pgsql
  38. databases/php56-pgsql
  39. databases/postgis21
  40. databases/postgresql-libpgeasy
  41. databases/postgresql-libpqxx
  42. databases/postgresql-libpqxx3
  43. databases/postgresql-odbc
  44. databases/postgresql-plproxy
  45. databases/postgresql-plv8js
  46. databases/postgresql92-contrib
  47. databases/postgresql92-docs
  48. databases/postgresql92-pgtcl
  49. databases/postgresql92-server
  50. databases/proftpd-mod_sql_postgres
  51. databases/py-PyGreSQL
  52. databases/py-postgresql
  53. databases/py-psycopg
  54. databases/py-psycopg2
  55. databases/py-pyPgSQL
  56. databases/qt4-pgsql-plugin
  57. databases/qt5-sqldrivers-pgsql
  58. databases/rubygem-do_postgres
  59. databases/rubygem-pg
  60. databases/skytools
  61. databases/soci
  62. databases/sqlclient
  63. databases/tablelog
  64. databases/vfront
  65. devel/gnatcoll
  66. devel/matreshka
  67. devel/preps-gui
  68. dns/powerdns
  69. dns/powerdns-devel*
  70. editors/calligra
  71. games/ldmud
  72. graphics/mapnik
  73. graphics/qgis
  74. lang/algol68g
  75. lang/modula3
  76. lang/smalltalk
  77. mail/archiveopteryx
  78. mail/archiveopteryx-devel
  79. mail/dspam
  80. mail/dspam-devel*
  81. mail/exim-postgresql
  82. math/octave-forge-database
  83. net/asterisk
  84. net/asterisk11
  85. net/cyphesis
  86. net/ser*
  87. net/turnserver
  88. net-im/iserverd*
  89. net-mgmt/icinga2
  90. net-mgmt/nagios-check_postgres
  91. net-mgmt/netdisco
  92. security/pam-pgsql
  93. sysutils/bacula-server
  94. sysutils/bacula5-server
  95. textproc/refdb
  96. www/bacula-web
  97. www/calendarserver
  98. www/davical
  99. www/mod_auth_pgsql2
  100. www/pglogd
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-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.9_1:
     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)
     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)
====> 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

Master Sites:

Number of commits found: 9

Commit History - (may be incomplete: see SVNWeb link above for full details)
25 Aug 2014 17:53:27
Original commit files touched by this commit  9.2.9
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
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
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
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
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
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
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
bapt search for other commits by this committer
Add NO_STAGE all over the place in preparation for the staging support (cat:
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
* 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
(Only the first 15 lines of the commit message are shown above View all of this commit message)

Number of commits found: 9

User Login
Create account

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

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

Enter Keywords:

Latest Vulnerabilities
ntpDec 20
ntp-develDec 20
gitDec 19
otrsDec 16
mod_dav_svnDec 15
subversionDec 15
subversion16Dec 15
subversion17Dec 15
nvidia-driverDec 14
nvidia-driver-173Dec 14
nvidia-driver-304Dec 14
asterisk11Dec 11
bind99Dec 11
xorg-serverDec 10
unboundDec 09

10 vulnerabilities affecting 27 ports have been reported in the past 14 days

* - modified, not new

All vulnerabilities

Deleted ports
Sanity Test Failures

NEW Graphs (Javascript)

Calculated hourly:
Port count 24434
Broken 144
Deprecated 70
Ignore 397
Forbidden 2
Restricted 207
Vulnerable 19
Expired 0
Set to expire 65
Interactive 0
new 24 hours 3
new 48 hours3
new 7 days25
new fortnight41
new month137

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