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

Port details
postgresql93-client PostgreSQL database (client)
9.3.17 databases on this many watch lists=12 search for ports that depend on this port An older version of this port was marked as vulnerable. 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: 11 May 2013 23:46:44
License: PostgreSQL
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 : PortsMon

To install the port: cd /usr/ports/databases/postgresql93-client/ && make install clean
To add the package: pkg install postgresql93-client

PKGNAME: postgresql93-client

ONLY_FOR_ARCHS: nil

NOT_FOR_ARCHS: nil

distinfo:

TIMESTAMP = 1494282359
SHA256 (postgresql/postgresql-9.3.17.tar.bz2) = 9c03e5f280cfe9bd202fa01af773eb146abd8ab3065f7279d574c568f6948dbe
SIZE (postgresql/postgresql-9.3.17.tar.bz2) = 17158802
SHA256 (postgresql/pg-9314-icu-2016-08-10.diff.gz) = 4be31ad9899d5caf9f57ad7ebfc0d14f0fcf58ad539c82fb353b016fb76c0c30
SIZE (postgresql/pg-9314-icu-2016-08-10.diff.gz) = 5583


Master port: databases/postgresql93-server

NOTE: FreshPorts displays only information on required and default dependencies. Optional dependencies are not covered.

Build dependencies:
  1. pkgconf>=1.3.0_1 : devel/pkgconf
  2. gmake : devel/gmake
  3. msgfmt : devel/gettext-tools
  4. perl5>=5.24<5.25 : lang/perl5.24
Runtime dependencies:
  1. perl5>=5.24<5.25 : lang/perl5.24
Library dependencies:
  1. libintl.so : devel/gettext-runtime

This port is required by:

for Build for Libraries
  1. converters/osm2pgsql
  2. databases/adabase
  3. databases/apq-pgsql
  4. databases/courier-authlib-pgsql
  5. databases/fpc-postgres
  6. databases/grass
  7. databases/hashtypes
  8. Expand this list (131 items)
  9. databases/ip4r
  10. databases/iplike
  11. databases/libdbi-drivers
  12. databases/libgda4-postgresql*
  13. databases/libgda5-postgresql
  14. databases/libpqtypes
  15. databases/libzbxpgsql
  16. databases/libzdb
  17. databases/luasql-postgres
  18. databases/p5-DBD-Pg
  19. databases/p5-DBD-Pg32*
  20. databases/p5-Pg
  21. databases/pgaccess
  22. databases/pgadmin3
  23. databases/pgagent
  24. databases/pgmodeler
  25. databases/pgpool
  26. databases/pgpool-II-22*
  27. databases/pgpool-II-23*
  28. databases/pgpool-II-35
  29. databases/pgpool-II-36
  30. databases/pgreplay
  31. databases/pgrouting
  32. databases/pgsphere
  33. databases/pgtcl
  34. databases/pguri
  35. databases/pgworksheet
  36. databases/php5-pdo_pgsql*
  37. databases/php5-pgsql*
  38. databases/php53-pdo_pgsql*
  39. databases/php53-pgsql*
  40. databases/php55-pdo_pgsql*
  41. databases/php55-pgsql*
  42. databases/php56-pdo_pgsql
  43. databases/php56-pgsql
  44. databases/php70-pdo_pgsql
  45. databases/php70-pgsql
  46. databases/php71-pdo_pgsql
  47. databases/php71-pgsql
  48. databases/postgis20
  49. databases/postgis21
  50. databases/postgis22
  51. databases/postgis23
  52. databases/postgresql-libpgeasy
  53. databases/postgresql-libpqxx
  54. databases/postgresql-libpqxx3
  55. databases/postgresql-odbc
  56. databases/postgresql-plproxy
  57. databases/postgresql-plv8js
  58. databases/postgresql93-contrib
  59. databases/postgresql93-docs
  60. databases/postgresql93-pgtcl
  61. databases/postgresql93-plv8js*
  62. databases/postgresql93-server
  63. databases/proftpd-mod_sql_postgres
  64. databases/py-PyGreSQL
  65. databases/py-pgcli
  66. databases/py-postgresql
  67. databases/py-psycopg*
  68. databases/py-psycopg2
  69. databases/py-psycopg2cffi
  70. databases/py-pyPgSQL
  71. databases/py3-psycopg2
  72. databases/py35-psycopg2*
  73. databases/qt4-pgsql-plugin
  74. databases/qt5-sqldrivers-pgsql
  75. databases/rubygem-do_postgres
  76. databases/rubygem-pg
  77. databases/skytools
  78. databases/soci
  79. databases/sqlclient
  80. databases/tablelog
  81. databases/tdbc
  82. databases/tsearch_extras
  83. databases/vfront
  84. databases/virtualpg
  85. devel/kore
  86. devel/kore-notls
  87. devel/matreshka
  88. devel/py-pyqi
  89. devel/sope*
  90. devel/sope2
  91. devel/sope3
  92. dns/powerdns
  93. editors/calligra
  94. finance/sql-ledger
  95. games/ldmud
  96. graphics/mapnik
  97. graphics/qgis
  98. lang/algol68g
  99. lang/modula3
  100. lang/smalltalk
  101. mail/dspam
  102. mail/exim-postgresql
  103. mail/opensmtpd-extras-table-postgresql
  104. math/octave-forge-database
  105. math/saga
  106. net/asterisk*
  107. net/asterisk11
  108. net/asterisk13
  109. net/cyphesis*
  110. net/libnss-pgsql
  111. net/opensips
  112. net/turnserver
  113. net-im/mastodon
  114. net-mgmt/ccnet-server
  115. net-mgmt/icinga2
  116. net-mgmt/nagios-check_postgres
  117. net-mgmt/netdisco
  118. net-mgmt/seafile-server
  119. ports-mgmt/portscout
  120. science/orthanc-postgresql
  121. security/pam-pgsql
  122. shells/sparforte
  123. sysutils/bacula-server
  124. sysutils/bacula5-server
  125. sysutils/bareos-server
  126. textproc/refdb
  127. www/bacula-web
  128. www/calendarserver
  129. www/davical
  130. www/mod_auth_pgsql2
  131. www/nginx-full
  132. www/pglogd
  133. Collapse this list.
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...
Configuration Options
===> The following configuration options are available for postgresql93-client-9.3.17:
     DEBUG=off: Build with debugging support
     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:
pkgconfig tar:bzip2 cpe gmake perl5 readline gettext ssl

Master Sites:
  1. ftp://ftp.postgresql.org/pub/source/v9.3.17/
  2. http://ftp.postgresql.org/pub/source/v9.3.17/
  3. https://ftp.postgresql.org/pub/source/v9.3.17/

Number of commits found: 20

NOTE: This slave port may no longer be vulnerable to issues shown below because the master port has been updated.

Commit History - (may be incomplete: see SVNWeb link above for full details)
This is a slave port. You may also want to view the commits to the master port: databases/postgresql93-server
DateByDescription
13 Jan 2016 10:36:22
Original commit files touched by this commit  9.3.10_1
Revision:406034 This port version is marked as vulnerable.
girgen search for other commits by this committer
Some binaries where moved from contrib to base in 9.5, like pgbench and
pg_upgrade. Other where added in 9.5, but the port failed to install them.
Make sure they are properly installed by the correct port (-client or -server)
[1]

Remove unused and hence confusing OSSP_UUID parameters from Makefile [2]

Add options to allow user to be set for the backup script in periodic.
Add this option only to 9.5 for now. It will be updated to other servers at
next regular patch release. [3]

The path to perl in hard coded into pgxs/src/Makefile.global which is
then installed. Hence, we must depend on perl when that file is installed.

Noticed by:	Paul Guyot [1]
PR:		192387 [2]
PR:		172110 [3]
PR:		206046 [4]
08 Oct 2015 21:25:01
Original commit files touched by this commit  9.3.10
Revision:398895 This port version is marked as vulnerable.
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
22 May 2015 23:22:20
Original commit files touched by this commit  9.3.7
Revision:387089 This port version is marked as vulnerable.
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.3.6_1
Revision:378604 This port version is marked as vulnerable.
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.3.6
Revision:378500 This port version is marked as vulnerable.
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
12 Nov 2014 09:53:42
Original commit files touched by this commit  9.3.5
Revision:372487 This port version is marked as vulnerable.
girgen search for other commits by this committer
Revert r247147.
We need -pthread in LDFLAGS for threaded extensions like plv8js to work.

PR:		175783
Submitted by:	Li-Wen Hsu <lwhsu@FreeBSD.org>
25 Aug 2014 17:53:27
Original commit files touched by this commit  9.3.5
Revision:366114 This port version is marked as vulnerable.
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.3.4
Revision:359941 This port version is marked as vulnerable.
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.3.3
Revision:346217 This port version is marked as vulnerable.
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.3.1
Revision:330414 This port version is marked as vulnerable.
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.3.0
Revision:329946 This port version is marked as vulnerable.
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.3.0
Revision:329729 This port version is marked as vulnerable.
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.3.0
Revision:329725 This port version is marked as vulnerable.
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.3.0
Revision:327717 This port version is marked as vulnerable.
bapt search for other commits by this committer
Add NO_STAGE all over the place in preparation for the staging support (cat:
databases)
18 Sep 2013 08:56:51
Original commit files touched by this commit  9.3.0
Revision:327537 This port version is marked as vulnerable.
girgen search for other commits by this committer
Install libpgcommon.a, required by extensions.

PR:	ports/182190
28 Jun 2013 10:50:52
Original commit files touched by this commit  9.3.b2
Revision:321954
girgen search for other commits by this committer
Update PostgreSQL 93 to beta 2.

URL:	http://www.postgresql.org/about/news/1471/
12 May 2013 22:28:38
Original commit files touched by this commit  9.3.b1_2
Revision:317984
girgen search for other commits by this committer
pkgconfig belongs under libdata
12 May 2013 21:09:39
Original commit files touched by this commit  9.3.b1
Revision:317978
girgen search for other commits by this committer
Update postgresql93-client to properly depend on pkgconfig
Reported by: Ports-QAT
12 May 2013 00:00:56
Original commit files touched by this commit  9.3.b1
Revision:317925
girgen search for other commits by this committer
Add postgresql 9.3 beta1
11 May 2013 23:46:30
Original commit files touched by this commit  9.2.4
Revision:317924
girgen search for other commits by this committer
Prepare for postgresql 9.3 beta 1 by svn cp postgresql92-* postgresql93-*

Number of commits found: 20

Login
User Login
Create account

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

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

Search
Enter Keywords:
 
more...

Latest Vulnerabilities
linux-c6-openssl*May 26
linux-c7-openssl*May 26
openssl*May 26
openssl-devel*May 26
vlcMay 26
vlc-qt4May 26
OpenEXRMay 25
samba42May 24
samba43May 24
samba44May 24
samba45May 24
samba46May 24
nvidia-driverMay 23
miniupnpcMay 22
wordpressMay 21

13 vulnerabilities affecting 47 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 29970
Broken 139
Deprecated 75
Ignore 430
Forbidden 0
Restricted 207
No CDROM 84
Vulnerable 142
Expired 37
Set to expire 71
Interactive 0
new 24 hours 1
new 48 hours26
new 7 days56
new fortnight97
new month248

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