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
postgresql93-client PostgreSQL database (client)
9.3.9 databases on this many watch lists=12 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: 11 May 2013 23:46:44
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/postgresql93-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. pkgconf : devel/pkgconf
  3. gmake : devel/gmake
  4. msgfmt : devel/gettext-tools
Runtime dependencies:
  1. libcrypto.so.8 : security/openssl
Library dependencies:
  1. libxml2.so : textproc/libxml2
  2. libintl.so : devel/gettext-runtime

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/libdbi-drivers
  10. databases/libgda4-postgresql
  11. databases/libgda5-postgresql
  12. databases/libpqtypes
  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-22
  24. databases/pgpool-II-23
  25. databases/pgrouting
  26. databases/pgsphere
  27. databases/pgtcl
  28. databases/pgworksheet
  29. databases/php5-pdo_pgsql
  30. databases/php5-pgsql
  31. databases/php53-pdo_pgsql*
  32. databases/php53-pgsql*
  33. databases/php55-pdo_pgsql
  34. databases/php55-pgsql
  35. databases/php56-pdo_pgsql
  36. databases/php56-pgsql
  37. databases/postgis21
  38. databases/postgresql-libpgeasy
  39. databases/postgresql-libpqxx
  40. databases/postgresql-libpqxx3
  41. databases/postgresql-odbc
  42. databases/postgresql-plproxy
  43. databases/postgresql-plv8js
  44. databases/postgresql93-contrib
  45. databases/postgresql93-docs
  46. databases/postgresql93-pgtcl
  47. databases/postgresql93-plv8js*
  48. databases/postgresql93-server
  49. databases/proftpd-mod_sql_postgres
  50. databases/py-PyGreSQL
  51. databases/py-postgresql
  52. databases/py-psycopg
  53. databases/py-psycopg2
  54. databases/py-pyPgSQL
  55. databases/qt4-pgsql-plugin
  56. databases/qt5-sqldrivers-pgsql
  57. databases/rubygem-do_postgres
  58. databases/rubygem-pg
  59. databases/skytools
  60. databases/soci
  61. databases/sqlclient
  62. databases/tablelog
  63. databases/vfront
  64. databases/virtualpg
  65. devel/matreshka
  66. dns/powerdns
  67. editors/calligra
  68. finance/sql-ledger
  69. games/ldmud
  70. graphics/mapnik
  71. graphics/qgis
  72. lang/algol68g
  73. lang/modula3
  74. lang/smalltalk
  75. mail/archiveopteryx
  76. mail/archiveopteryx-devel
  77. mail/dspam
  78. mail/exim-postgresql
  79. math/octave-forge-database
  80. math/saga
  81. net/asterisk
  82. net/asterisk11
  83. net/asterisk13
  84. net/cyphesis
  85. net/turnserver
  86. net-mgmt/icinga2
  87. net-mgmt/nagios-check_postgres
  88. net-mgmt/netdisco
  89. security/pam-pgsql
  90. sysutils/bacula-server
  91. sysutils/bacula5-server
  92. textproc/refdb
  93. www/bacula-web
  94. www/calendarserver
  95. www/davical
  96. www/mod_auth_pgsql2
  97. 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/postgresql93-client/ && make install clean
To add the package: pkg install databases/postgresql93-client


Configuration Options
===> The following configuration options are available for postgresql93-client-9.3.9:
     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)
     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
     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

USES:
pkgconfig tar:bzip2 cpe gmake readline gettext

Master Sites:
  1. ftp://ftp.postgresql.org/pub/source/v9.3.9/
  2. http://distcache.FreeBSD.org/ports-distfiles/postgresql/
  3. http://ftp.postgresql.org/pub/source/v9.3.9/
  4. https://ftp.postgresql.org/pub/source/v9.3.9/

Number of commits found: 18

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.3.7
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.3.6_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.3.6
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
12 Nov 2014 09:53:42
Original commit files touched by this commit  9.3.5
Revision:372487
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
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
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
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
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
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
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
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
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
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: 18

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
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
libidnJul 23
opensaml2Jul 23

20 vulnerabilities affecting 50 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 25083
Broken 197
Deprecated 108
Ignore 498
Forbidden 1
Restricted 204
No CDROM 94
Vulnerable 44
Expired 3
Set to expire 96
Interactive 0
new 24 hours 1
new 48 hours1
new 7 days25
new fortnight60
new month169

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