| Port details |
- postgresql84-server The most advanced open-source database available anywhere
- 8.4.22_2 databases
 =9       8.4.22_2Version of this port present on the latest quarterly branch.  DEPRECATED: "EOL was reached in July 2014"
 This port expired on: 2015-05-10
- Maintainer: pgsql@FreeBSD.org
- Port Added: 2009-07-07 22:30:32
- Last Update: 2015-06-10 17:38:23
- SVN Revision: 389108
- People watching this port, also watch:: clamav
- 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/
 cgit ¦ GitHub ¦ GitHub ¦ GitLab ¦ 
- 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:
-
- postgresql84-server>0:databases/postgresql84-server
- No installation instructions:
- This port has been deleted.
- PKGNAME: postgresql84-server
- 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. Perhaps there is a build error. Check the fallout link:
- Dependencies
- NOTE: FreshPorts displays only information on required and default dependencies. Optional dependencies are not covered.
- Build dependencies:
-
- libcrypto.so.8 : security/openssl
- gmake : devel/gmake
- msgfmt : devel/gettext-tools
- Runtime dependencies:
-
- libcrypto.so.8 : security/openssl
- Library dependencies:
-
- libxml2.so : textproc/libxml2
- libpq.so.5 : databases/postgresql84-client
- libintl.so : devel/gettext-runtime
- NOTE: dependencies for deleted ports are notoriously suspect
- This port is required by:
- for Build
-
Deleted ports which required this port:
- for Run
-
Deleted ports which required this port:
- * - 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-server-8.4.22_2:
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
- Options name:
- N/A
- USES:
- tar:bzip2 gmake pgsql:8.4 gettext
- FreshPorts was unable to extract/find any pkg message
- Master Sites:
|
| Commit History - (may be incomplete: for full details, see links to repositories near top of page) |
| Commit | Credits | Log message |
|---|
8.4.4_2
05 Jun 2010 11:04:02
  |
girgen |
Fix package list |
8.4.4_1
02 Jun 2010 10:16:03
|
girgen |
Fix broken plist
PR: ports/147312 |
8.4.4_1
31 May 2010 02:01:56
|
ade |
Bounce PORTREVISION for gettext-related ports. Have fun, ya'll. |
8.4.4
30 May 2010 18:00:47
|
pav |
- Mark client port broken - leaves files behind on deinstall
Reported by: pointyhat |
8.4.4
20 May 2010 15:43:39
|
girgen |
Update all PostgreSQL ports to latest version.
Remove postgresql-contrib in favour for postgresqlNN-contrib.
This way we will get packages built, which is nice.
Security: CVE-2010-1169
Security: CVE-2010-1170
The PostgreSQL Project today released minor versions updating all active
branches of the PostgreSQL object-relational database system, including
versions 8.4.4, 8.3.11, 8.2.17, 8.1.21, 8.0.25, and 7.4.29. This release
fixes moderate-risk security issues with PL/perl and PL/tcl, as well as
a data corruption issue with standby databases. Users of any of these
three features should update their PostgreSQL installations immediately.
(Only the first 15 lines of the commit message are shown above  ) |
8.4.3_1
27 Mar 2010 00:15:24
|
dougb |
Begin the process of deprecating sysutils/rc_subr by
s#. %%RC_SUBR%%#. /etc/rc.subr# |
8.4.3_1
25 Mar 2010 22:58:11
|
mm |
- Add ICU 4.x support
- Bump PORTREVISION
PR: ports/143841
Submitted by: Andrei Lavreniyuk <andy.lavr@reactor-xg.kiev.ua>
Approved by: maintainer (timeout) |
8.4.3
25 Mar 2010 21:47:52
|
delphij |
Update to 8.4.3.
PR: ports/144863
Submitted by: Alexander <alp rsu ru>
Security: e050119b-3856-11df-b2b2-002170daae37
With hat: ports-security@ |
8.4.2_1
03 Feb 2010 15:09:09
|
girgen |
Reintegrate the patch for ICU (unicode support). |
8.4.2_1
04 Jan 2010 20:37:30
|
ale |
PTHREAD_[CFLAGS|LDFLAGS] are already set in CONFIGURE_ENV.
Approved by: portmgr and maintainer timeout (1 month) |
8.4.2_1
04 Jan 2010 20:29:37
|
ale |
Don't link unneeded PTHREAD_LIBS. This fixes php extensions and apache modules.
Approved by: portmgr and maintainer timeout (1 month) |
8.4.2
17 Dec 2009 16:07:12
|
mm |
- Update to 8.4.2
Security: CVE-2009-4034
Security: CVE-2009-4136
Security:
http://portaudit.freebsd.org/e7bc5600-eaa0-11de-bd9c-00215c6a37bb.html
PR: ports/141639
Submitted by: Alexander Pyhalov <alp@rsu.ru>
Approved by: ports-security (delphij) |
8.4.1
02 Dec 2009 22:21:27
|
mm |
- 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) |
8.4.0_1
19 Sep 2009 22:06:02
|
pav |
- Fix plist for contrib
PR: ports/136654, ports/136962
Reported by: YAMAMOTO Takao <takao@oakat.org>,
Gergely Czuczy <gergely.czuczy@harmless.hu>
Approved by: maintainer timeout (girgen; 2 months)
Feature safe: yes |
8.4.0_1
15 Jul 2009 16:56:10
|
dougb |
Fix a few "bad example" problems in the rc.d scripts that have been
propogated by copy and paste.
1. Primarily the "empty variable" default assignment, which is mostly
${name}_flags="", but fix a few others as well.
2. Where they are not already documented, add the existence of the _flags
(or other deleted empties) option to the comments, and in some cases add
comments from scratch.
3. Replace things that look like:
prefix=%%PREFIX%%
command=${prefix}/sbin/foo
to just use %%PREFIX%%. In many cases the $prefix variable is only used
once, and in some cases it is not used at all.
4. In a few cases remove ${name}_flags from command_args
5. Remove a long-stale comment about putting the port's rc.d script in
/etc/rc.d (which is no longer necessary).
No PORTREVISION bumps because all of these changes are noops. |
8.4.0_1
08 Jul 2009 20:31:53
|
girgen |
Fix broken pkg-plist for gettext files.
Also, inform about pg_standby rather than autovacuum. [1]
PR: 136468 [1] |
8.4.0
08 Jul 2009 06:57:26
|
girgen |
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.4.0
07 Jul 2009 22:30:06
|
girgen |
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 |
As an Amazon Associate I earn from qualifying purchases.