notbugAs an Amazon Associate I earn from qualifying purchases.
Want a good read? Try FreeBSD Mastery: Jails (IT Mastery Book 15)
Want a good monitor light? See my photosAll times are UTC
Ukraine
This referral link gives you 10% off a Fastmail.com account and gives me a discount on my Fastmail account.

Get notified when packages are built

A new feature has been added. FreshPorts already tracks package built by the FreeBSD project. This information is displayed on each port page. You can now get an email when FreshPorts notices a new package is available for something on one of your watch lists. However, you must opt into that. Click on Report Subscriptions on the right, and New Package Notification box, and click on Update.

FInally, under Watch Lists, click on ABI Package Subscriptions to select your ABI (e.g. FreeBSD:14:amd64) & package set (latest/quarterly) combinatio for a given watch list. This is what FreshPorts will look for.

Port details
postgresql83-client PostgreSQL database (client)
8.3.23,1 databases Deleted on this many watch lists=5 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 View this port on Repology. pkg-fallout 8.3.23,1Version of this port present on the latest quarterly branch.
Deprecated DEPRECATED: End-of-life is coming up
Expired This port expired on: 2013-03-01
Maintainer: pgsql@FreeBSD.org search for ports maintained by this maintainer
Port Added: 2007-10-15 23:35:05
Last Update: 2013-06-04 18:07:02
SVN Revision: 319888
People watching this port, also watch:: nagios
License: not specified in port
WWW:
http://www.postgresql.org/
Description:
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/
Homepage    cgit ¦ GitHub ¦ GitHub ¦ GitLab ¦ SVNWeb

Manual pages:
FreshPorts has no man page information for this port.
pkg-plist: as obtained via: make generate-plist
There is no configure plist information for this port.
Dependency lines:
  • postgresql-client>0:databases/postgresql83-client
No installation instructions:
This port has been deleted.
PKGNAME: postgresql-client
Flavors: there is no flavor information for this port.
distinfo:
There is no distinfo for this port.

No package information for this port in our database
Sometimes this happens. Not all ports have packages.
Master port: databases/postgresql83-server
Dependencies
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
Runtime dependencies:
  1. libcrypto.so.8 : security/openssl
Library dependencies:
  1. xml2.5 : textproc/libxml2
  2. intl : devel/gettext
NOTE: dependencies for deleted ports are notoriously suspect
This port is required by:
for Libraries

Deleted ports which required this port:

Expand this list of 16 deleted ports
  1. databases/gdl2*
  2. databases/ksqlshell*
  3. databases/php4-pgsql*
  4. databases/postgresql-libpqxx30*
  5. databases/postgresql-tcltk*
  6. databases/postgresql83-contrib*
  7. databases/postgresql83-docs*
  8. databases/postgresql83-plpython*
  9. databases/postgresql83-server*
  10. devel/etoile-coreobject*
  11. dns/sqldjbdns*
  12. editors/koffice-kde4*
  13. japanese/postgresql-tcltk*
  14. net/samba-pdbsql*
  15. net/yate-devel*
  16. www/openbravoerp*
  17. Collapse this list of deleted ports.
* - 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 postgresql-client-8.3.23,1: DEBUG=off: Builds with debugging symbols ICU=off: Use ICU for unicode collation (server) INTDATE=off: Builds with 64-bit date/time type (server) KRB5=off: Build with kerberos provider support LDAP=off: Build with LDAP authentication support NLS=on: Use internationalized messages OPTIMIZED_CFLAGS=off: Builds with compiler optimizations (-O3) PAM=off: Build with PAM support (server only) SSL=on: Build with OpenSSL support TZDATA=on: Use internal timezone database (server) XML=on: Build with XML data type (server) ====> Options available for the single KRB5: you have to select exactly one of them MIT_KRB5=off: Build with MIT's kerberos support HEIMDAL_KRB5=off: Builds with Heimdal kerberos ===> Use 'make config' to modify these settings
Options name:
N/A
FreshPorts was unable to extract/find any pkg message
Master Sites:
Expand this list (19 items)
Collapse this list.
  1. ftp://ftp.FreeBSD.org/pub/FreeBSD/ports/distfiles/postgresql/
  2. ftp://ftp.ee.postgresql.org/mirrors/postgresql/source/v8.3.23/
  3. ftp://ftp.gr.postgresql.org/pub/databases/postgresql/source/v8.3.23/
  4. ftp://ftp.ie.postgresql.org/mirrors/ftp.postgresql.org/pub/source/v8.3.23/
  5. ftp://ftp.lv.postgresql.org/pub/postgresql/source/v8.3.23/
  6. ftp://ftp.postgresql.org/pub/source/v8.3.23/
  7. ftp://ftp.se.postgresql.org/pub/databases/relational/postgresql/source/v8.3.23/
  8. ftp://ftp2.cz.postgresql.org/pub/postgresql/source/v8.3.23/
  9. ftp://ftp2.it.postgresql.org/mirrors/postgres/source/v8.3.23/
  10. ftp://ftp2.nl.postgresql.org/mirror/postgresql/source/v8.3.23/
  11. ftp://ftp3.de.postgresql.org/pub/Mirrors/ftp.postgresql.org/source/v8.3.23/
  12. ftp://ftp3.ru.postgresql.org/pub/mirror/postgresql/pub/source/v8.3.23/
  13. ftp://ftp3.tw.postgresql.org/pub/postgresql/source/v8.3.23/
  14. ftp://ftp5.es.postgresql.org/mirror/postgresql/source/v8.3.23/
  15. ftp://ftp6.pl.postgresql.org/pub/postgresql/source/v8.3.23/
  16. ftp://ftp6.ro.postgresql.org/pub/mirrors/ftp.postgresql.org/source/v8.3.23/
  17. ftp://ftp7.pl.postgresql.org/pub/mirror/ftp.postgresql.org/source/v8.3.23/
  18. http://ftp2.jp.postgresql.org/pub/postgresql/source/v8.3.23/
  19. http://ring.nict.go.jp/archives/misc/db/postgresql/source/v8.3.23/
Collapse this list.

Number of commits found: 8

Commit History - (may be incomplete: for full details, see links to repositories near top of page)
This is a slave port. You may also want to view the commits to the master port: databases/postgresql83-server
CommitCreditsLog message
04 Jun 2013 18:07:02
Revision:319888Original commit files touched by this commit Sanity Test Failure Refresh
crees search for other commits by this committer
Remove postgresql83-*; it expired at the beginning of March.

While here, fix flo's typo...
8.3.23,1
04 Apr 2013 13:21:23
Revision:315718Original commit files touched by this commit
girgen search for other commits by this committer
The PostgreSQL Global Development Group has released a security
update to all current versions of the PostgreSQL database system,
including versions 9.2.4, 9.1.9, 9.0.13, and 8.4.17. This update
fixes a high-exposure security vulnerability in versions 9.0 and
later. All users of the affected versions are strongly urged to apply
the update *immediately*.

A major security issue (for versions 9.x only) fixed in this release,
[CVE-2013-1899](http://cve.mitre.org/cgi-bin/cvename.cgi?name=CVE-2013-1899),
makes it possible for a connection request containing a database name
that begins with "-" to be crafted that can damage or destroy files
within a server's data directory. Anyone with access to the port the
PostgreSQL server listens on can initiate this request. This issue was
discovered by Mitsumasa Kondo and Kyotaro Horiguchi of NTT Open Source
Software Center.
(Only the first 15 lines of the commit message are shown above View all of this commit message)
8.3.7,1
08 Jul 2009 06:41:14
Original commit files touched by this commit
girgen search for other commits by this committer
Fix bad commit, accidentally copied the CVS directoy from 83 to 84 and
committed. Yikes. :-(
8.4.0
07 Jul 2009 22:30:06
Original commit files touched by this commit This port version is marked as vulnerable.
girgen search for other commits by this committer
Welcome PostgreSQL 8.4

After many years of development, PostgreSQL has become feature-complete in many
areas.
This release shows a targeted approach to adding features (e.g., authentication,
monitoring, space reuse), and adds capabilities defined in the later SQL
standards.
The major areas of enhancement are:

Windowing Functions
Common Table Expressions and Recursive Queries
Default and variadic parameters for functions
Parallel Restore
Column Permissions
Per-database locale settings
Improved hash indexes
Improved join performance for EXISTS and NOT EXISTS queries
Easier-to-use Warm Standby
Automatic sizing of the Free Space Map
Visibility Map (greatly reduces vacuum overhead for slowly-changing tables)
Version-aware psql (backslash commands work against older servers)
Support SSL certificates for user authentication
Per-function runtime statistics
Easy editing of functions in psql
New contrib modules: pg_stat_statements, auto_explain, citext, btree_gin

URL: http://www.postgresql.org/docs/8.4/interactive/release-8-4.html
8.3.3
12 Jun 2008 23:46:07
Original commit files touched by this commit This port version is marked as vulnerable.
girgen search for other commits by this committer
Updates of the PostgreSQL ports

Updates for all maintained versions of PostgreSQL are available today:
8.3.3, 8.2.9, 8.1.13, 8.0.17 and 7.4.21.  These releases fix more than
two dozen minor issues reported and patched over the last few months.
All PostgreSQL users should plan to update at their earliest
convenience. People in affected time zones, in particular, should
upgrade as soon as possible.

Release Notes:
        http://www.postgresql.org/docs/8.3/static/release.html

Also, fix umask error in periodic script [1].

PR:             ports/124457 [1]
Submitted by:   Alexandre Perrin
8.3.1_1
06 Jun 2008 13:17:10
Original commit files touched by this commit This port version is marked as vulnerable.
edwin search for other commits by this committer
Bump portrevision due to upgrade of devel/gettext.

The affected ports are the ones with gettext as a run-dependency
according to ports/INDEX-7 (5007 of them) and the ones with USE_GETTEXT
in Makefile (29 of them).

PR:             ports/124340
Submitted by:   edwin@
Approved by:    portmgr (pav)
8.3.1
19 Apr 2008 17:56:05
Original commit files touched by this commit Sanity Test Failure This port version is marked as vulnerable.
miwi search for other commits by this committer
- Remove unneeded dependency from gtk12/gtk20 [1]
- Remove USE_XLIB/USE_X_PREFIX/USE_XPM in favor of USE_XORG
- Remove X11BASE support in favor of LOCALBASE or PREFIX
- Use USE_LDCONFIG instead of INSTALLS_SHLIB
- Remove unneeded USE_GCC 3.4+

Thanks to all Helpers:
        Dmitry Marakasov, Chess Griffin, beech@, dinoex, rafan, gahr,
        ehaupt, nox, itetcu, flz, pav

PR:             116263
Tested on:      pointyhat
Approved by:    portmgr (pav)
8.3beta1
15 Oct 2007 23:34:53
Original commit files touched by this commit This port version is marked as vulnerable.
girgen search for other commits by this committer
Introducing the first beta of PostgreSQL 8.3

Note that this is a BETA VERSION of the PostgreSQL server.
Use it only for testing.

Number of commits found: 8