postgresql84-client PostgreSQL database (client)
8.4.22_1 databases =8

DEPRECATED: "EOL was reached in July 2014"
This port expired on: 2015-05-10
Maintainer: pgsql@FreeBSD.org
Port Added: 2009-07-08 06:45:16
Last Update: 2015-06-10 17:44:37
SVN Revision: 389040
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 : PortsMon

There is no configure plist information for this port.

Dependency line: postgresql84-client>0:databases/postgresql84-client

---

No installation instructions: this port has been deleted.

The package name of this deleted port was: postgresql84-client

PKGNAME: postgresql84-client

There is no flavor information for this port.

distinfo: There is no distinfo for this port.

---

Master port: databases/postgresql84-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. gmake : devel/gmake
3. 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

NOTE: dependencies for deleted ports are notoriously suspect

This port is required by:

for Build

1. databases/pg_filedump^*

for Libraries

1. databases/postgresql84-contrib^*
2. databases/postgresql84-docs^*
3. databases/postgresql84-server^*
4. databases/slony1^*

* - 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 postgresql84-client-8.4.22_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)
     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)
====> 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

---

USES:

readline tar:bzip2 gmake gettext

---

Master Sites:

1. ftp://ftp.postgresql.org/pub/source/v8.4.22/
2. http://distcache.FreeBSD.org/ports-distfiles/postgresql/
3. http://ftp.postgresql.org/pub/source/v8.4.22/
4. https://ftp.postgresql.org/pub/source/v8.4.22/

• port deleted on 2015-06-10
  REASON: Has expired: "EOL was reached in July 2014"
  

Remove expired ports:
2015-05-10 databases/postgresql84-client: "EOL was reached in July 2014"
2015-05-10 databases/postgresql84-contrib: "EOL was reached in July 2014"
2015-05-10 databases/postgresql84-docs: "EOL was reached in July 2014"
2015-05-10 databases/postgresql84-plperl: "EOL was reached in July 2014"
2015-05-10 databases/postgresql84-plpython: "EOL was reached in July 2014"
2015-05-10 databases/postgresql84-pltcl: "EOL was reached in July 2014"
2015-06-02 deskutils/deskbar-applet: Broken since update to gnome3
2015-06-02 deskutils/gimmie: Broken since update to gnome3
2015-06-02 deskutils/glipper: Broken since update to gnome3
2015-06-02 deskutils/gnochm: Broken since update to gnome3
2015-06-02 deskutils/hamster-applet: Broken since update to gnome3
2015-06-02 deskutils/kupfer: Broken since update to gnome3
2015-06-02 deskutils/ontv: Broken since update to gnome3
2015-06-02 deskutils/timer-applet: Broken since update to gnome3

Revert r247147.
We need -pthread in LDFLAGS for threaded extensions like plv8js to work.

PR:		175783
Submitted by:	Li-Wen Hsu <lwhsu@FreeBSD.org>

Convert pgsql ports to use USES+=pgsql

Reviewed by:	bapt

Fixes build with readline from ports

Stage support

Reviewed by:	postgresql@
Tested by:	miwi and me

- 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)

- Fix pkg name collision

Reviewed by: pgsql@
With hat: pgsql@

- revert r329725

Reported by: qat@
With hat: pgsql@

- Fix pkg name collision

Reviewed by: crees@
With hat: pgsql@

Add NO_STAGE all over the place in preparation for the staging support (cat:
databases)

Fix pkg-list for postgresql84-server

Approved by:	portmgr (miwi)

PostgreSQL 9.2.3, 9.1.8, 9.0.12, 8.4.16 and 8.3.23 released

This update fixes a denial-of-service (DOS) vulnerability.  All users
should update their PostgreSQL installations as soon as possible.

The security issue fixed in this release, CVE-2013-0255, allows a
previously authenticated user to crash the server by calling
an internal function with invalid arguments.

URL:	http://www.postgresql.org/about/news/1446/
Security: http://cve.mitre.org/cgi-bin/cvename.cgi?name=CVE-2013-0255

Fix a problem with creating the postgresql user when using a package.

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

- Update to 8.4.1
- Set INTDATE on as default (this is default by PostgreSQL)

PR:             ports/139277
Submitted by:   Olli Hauer <ohauer@gmx.de>
Approved by:    maintainer timeout (2 months)

Fix broken pkg-plist for gettext files.

Also, inform about pg_standby rather than autovacuum. [1]

PR:     136468 [1]

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

12 vulnerabilities affecting 85 ports have been reported in the past 14 days

^* - modified, not new

All vulnerabilities

Last updated:
2019-02-15 15:06:58