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

I am looking for an LTO tape library. Do you have one to spare?
Port details
postgresql90-client 9.0.17 databases on this many watch lists=11 search for ports that depend on this port An older version of this port was marked as vulnerable.
PostgreSQL database (client)
Maintained by: pgsql@FreeBSD.org search for ports maintained by this maintainer
Port Added: 20 Sep 2010 13:48:16
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
Master port: databases/postgresql90-server

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

This port is required by:

for Libraries
  1. converters/osm2pgsql
  2. databases/aolserver-nspostgres
  3. databases/apq-pgsql
  4. databases/courier-authlib-pgsql
  5. databases/fpc-postgres
  6. databases/glom
  7. databases/grass
  8. databases/hashtypes
  9. databases/ip4r
  10. databases/iplike
  11. databases/jasperserver
  12. databases/libdbi-drivers
  13. databases/libgda3-postgresql
  14. databases/libgda4-postgresql
  15. databases/libgda5-postgresql
  16. databases/libzdb
  17. databases/luasql-postgres
  18. databases/ludia*
  19. databases/nagios-check_postgres_replication
  20. databases/p5-DBD-Pg
  21. databases/p5-Pg
  22. databases/pg_reorg
  23. databases/pg_rman
  24. databases/pg_statsinfo
  25. databases/pgaccess
  26. databases/pgadmin3
  27. databases/pgagent
  28. databases/pgpool-II
  29. databases/pgpool-II-22
  30. databases/pgpool-II-23
  31. databases/pgpool-II-30
  32. databases/pgrouting
  33. databases/pgsphere
  34. databases/pgtcl
  35. databases/pgworksheet
  36. databases/php5-pdo_pgsql
  37. databases/php5-pgsql
  38. databases/php52-pdo_pgsql*
  39. databases/php52-pgsql*
  40. databases/php53-pdo_pgsql
  41. databases/php53-pgsql
  42. databases/php55-pdo_pgsql
  43. databases/php55-pgsql
  44. databases/postgis*
  45. databases/postgis20
  46. databases/postgis21
  47. databases/postgresql-libpgeasy
  48. databases/postgresql-libpq++*
  49. databases/postgresql-libpqxx
  50. databases/postgresql-libpqxx3
  51. databases/postgresql-odbc
  52. databases/postgresql-pllua
  53. databases/postgresql-plproxy
  54. databases/postgresql-plruby
  55. databases/postgresql-repmgr
  56. databases/postgresql90-contrib
  57. databases/postgresql90-docs
  58. databases/postgresql90-pgtcl
  59. databases/postgresql90-plpython
  60. databases/postgresql90-server
  61. databases/proftpd-mod_sql_postgres
  62. databases/py-PyGreSQL
  63. databases/py-postgresql
  64. databases/py-psycopg
  65. databases/py-psycopg2
  66. databases/py-pyPgSQL
  67. databases/qt-pgsql-plugin*
  68. databases/qt4-pgsql-plugin
  69. databases/qt5-sqldrivers-pgsql
  70. databases/rubygem-do_postgres
  71. databases/rubygem-pg
  72. databases/skytools
  73. databases/slony1
  74. databases/slony1v2
  75. databases/soci
  76. databases/sqlclient
  77. databases/tablelog
  78. databases/vfront
  79. devel/matreshka
  80. devel/preps-gui
  81. devel/prepstools
  82. dns/bind97-sdb*
  83. dns/powerdns
  84. dns/powerdns-devel
  85. editors/calligra
  86. games/ldmud
  87. graphics/mapnik
  88. graphics/qgis
  89. lang/algol68g
  90. lang/modula3
  91. lang/smalltalk
  92. lang/urweb
  93. mail/dspam
  94. mail/dspam-devel
  95. mail/exim-postgresql
  96. math/octave-forge-database
  97. net/asterisk
  98. net/asterisk10*
  99. net/asterisk11
  100. net/asterisk14
  101. net/cyphesis
  102. net/prosearch
  103. net/ser
  104. net/turnserver
  105. net-im/iserverd
  106. net-mgmt/nagios-check_postgres
  107. net-mgmt/netdisco
  108. ports-mgmt/portscout
  109. security/pam-pgsql
  110. sysutils/bacula-server
  111. sysutils/condor
  112. sysutils/rsyslog5-pgsql*
  113. sysutils/rsyslog6-devel-pgsql*
  114. sysutils/rsyslog6-pgsql*
  115. textproc/openfts
  116. www/bacula-web
  117. www/davical
  118. www/dpsearch
  119. www/mod_auth_pgsql2
  120. www/pglogd
  121. www/thundersnarf
* - 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/postgresql90-client/ && make install clean
To add the package: pkg install databases/postgresql90-client


Configuration Options
===> The following configuration options are available for postgresql90-client-9.0.17:
     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)
====> Build with kerberos provider support: 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.0.17/
  3. ftp://ftp.gr.postgresql.org/pub/databases/postgresql/source/v9.0.17/
  4. ftp://ftp.ie.postgresql.org/mirrors/ftp.postgresql.org/pub/source/v9.0.17/
  5. ftp://ftp.lv.postgresql.org/pub/postgresql/source/v9.0.17/
  6. ftp://ftp.postgresql.org/pub/source/v9.0.17/
  7. ftp://ftp.se.postgresql.org/pub/databases/relational/postgresql/source/v9.0.17/
  8. ftp://ftp2.cz.postgresql.org/pub/postgresql/source/v9.0.17/
  9. ftp://ftp2.it.postgresql.org/mirrors/postgres/source/v9.0.17/
  10. ftp://ftp2.nl.postgresql.org/mirror/postgresql/source/v9.0.17/
  11. ftp://ftp3.de.postgresql.org/pub/Mirrors/ftp.postgresql.org/source/v9.0.17/
  12. ftp://ftp3.ru.postgresql.org/pub/mirror/postgresql/pub/source/v9.0.17/
  13. ftp://ftp3.tw.postgresql.org/pub/postgresql/source/v9.0.17/
  14. ftp://ftp5.es.postgresql.org/mirror/postgresql/source/v9.0.17/
  15. ftp://ftp6.pl.postgresql.org/pub/postgresql/source/v9.0.17/
  16. ftp://ftp6.ro.postgresql.org/pub/mirrors/ftp.postgresql.org/source/v9.0.17/
  17. ftp://ftp7.pl.postgresql.org/pub/mirror/ftp.postgresql.org/source/v9.0.17/
  18. http://ftp2.jp.postgresql.org/pub/postgresql/source/v9.0.17/
  19. http://ring.nict.go.jp/archives/misc/db/postgresql/source/v9.0.17/

Number of commits found: 15

Commit History - (may be incomplete: see SVNWeb link above for full details)
DateByDescription
26 Feb 2014 17:24:36
Original commit files touched by this commit  9.0.16
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.0.14
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.0.13
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.0.13
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.0.13
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.0.13
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)
04 Jun 2012 11:00:52
Original commit files touched by this commit  9.0.8
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
28 Feb 2012 21:37:40
Original commit files touched by this commit  9.0.7_1
girgen search for other commits by this committer
Fix pkg-plist
25 Jan 2012 21:12:33
Original commit files touched by this commit  9.0.6
 This port version is marked as vulnerable.
crees search for other commits by this committer
- To preserve my sanity, slave 82 and 83 to 84, and 90 to 91, resulting in
  three fewer Makefiles to maintain

- Switch patch master site

- Various cleanups
18 Oct 2011 09:03:33
Original commit files touched by this commit  9.0.5
 This port version is marked as vulnerable.
girgen search for other commits by this committer
The PostgreSQL Global Development Group today released minor version updates
for all active branches of the PostgreSQL object-relational database system,
including versions 9.1.1, 9.0.5, 8.4.9, 8.3.16 and 8.2.22.

All users are strongly urged to update their installations at the next
scheduled downtime.

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

Cleanup ports. Better handling of the knob PG_USER.
Also add uuid to 9.0 and 9.1 contrib ports.
02 May 2011 21:37:31
Original commit files touched by this commit  9.0.4_1
 This port version is marked as vulnerable.
girgen search for other commits by this committer
Fix a problem with creating the postgresql user when using a package.
31 Dec 2010 09:57:21
Original commit files touched by this commit  9.0.2
 This port version is marked as vulnerable.
mm search for other commits by this committer
- Update to 9.0.2
- Unify ICU handling

PR:             ports/153245
Approved by:    maintainer (timeout)
26 Oct 2010 12:34:27
Original commit files touched by this commit  9.0.1_1
 This port version is marked as vulnerable.
girgen search for other commits by this committer
Make postgresql90-client depend on libxml. Technically it does not depend on
libxml,
only postgresql90-server does, but since we don't want two different pg_config
setups,
one for client and one for server, I'm bringing the libxml dependency on board
until
I can find out a better way to solve this.
07 Oct 2010 06:58:10
Original commit files touched by this commit  9.0.0
 This port version is marked as vulnerable.
girgen search for other commits by this committer
Update all PostgreSQL ports to latest versions.

Also, try to break the previous 1:1 relation between FreeBSD system and
PostgreSQL versions installed. Use different PREFIX:es to install
different versions on the same system.

PR: ports/132402, ports/145002, ports/146657
20 Sep 2010 13:46:47
Original commit files touched by this commit  9.0.0
 This port version is marked as vulnerable.
girgen search for other commits by this committer
PostgreSQL 9.0 is here!  The PostgreSQL Global Development Group
announces the availability of our most eagerly awaited release.
PostgreSQL 9.0 includes built-in, binary replication, and over a dozen
other major features which will appeal to everyone from web developers
to database hackers.

9.0 includes more major features than any release before it, including:
* Hot standby
* Streaming replication
* In-place upgrades
* 64-bit Windows builds
* Easy mass permissions management
* Anonymous blocks and named parameter calls for stored procedures
* New windowing functions and ordered aggregates
(Only the first 15 lines of the commit message are shown above View all of this commit message)

Number of commits found: 15

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
curlApr 11
dbus-glibApr 11
libaudiofileApr 11
linux-f10-curlApr 11
linux-f10-dbus-glibApr 11
linux-f10-libaudiofileApr 11
linux-f10-nas-libsApr 11
linux-f10-openldapApr 11
mingw32-openssl*Apr 11
mingw32-opensslApr 11
nasApr 11
openssl*Apr 11
opensslApr 11
linux-f10-openssl*Apr 10
linux-f10-openssl*Apr 10

13 vulnerabilities affecting 34 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 24394
Broken 176
Deprecated 120
Ignore 528
Forbidden 4
Restricted 263
No CDROM 108
Vulnerable 27
Expired 43
Set to expire 105
Interactive 22
new 24 hours 1
new 48 hours4
new 7 days15
new fortnight35
new month149

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