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

I am looking for an LTO tape library. Do you have one to spare?
Port details
postgresql84-server 8.4.22 databases on this many watch lists=13 search for ports that depend on this port An older version of this port was marked as vulnerable.
The most advanced open-source database available anywhere
Maintained by: pgsql@FreeBSD.org search for ports maintained by this maintainer
Port Added: 07 Jul 2009 22:30:32
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 : Main Web Site : Distfiles Availability : PortsMon
Slave ports
  1. databases/postgresql84-client
  2. databases/postgresql84-contrib
  3. databases/postgresql84-docs
  4. databases/postgresql84-plperl
  5. databases/postgresql84-plpython
  6. databases/postgresql84-pltcl

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

Required To Build:
  1. security/openssl
  2. devel/gmake
Required To Run:
  1. security/openssl
Required Libraries:
  1. textproc/libxml2
  2. databases/postgresql84-client
  3. devel/gettext

This port is required by:

for Build 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/postgresql84-server/ && make install clean
To add the package: pkg install databases/postgresql84-server


Configuration Options
===> The following configuration options are available for postgresql84-server-8.4.22:
     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

Master Sites:
  1. ftp://ftp.ee.postgresql.org/mirrors/postgresql/source/v8.4.22/
  2. ftp://ftp.gr.postgresql.org/pub/databases/postgresql/source/v8.4.22/
  3. ftp://ftp.ie.postgresql.org/mirrors/ftp.postgresql.org/pub/source/v8.4.22/
  4. ftp://ftp.lv.postgresql.org/pub/postgresql/source/v8.4.22/
  5. ftp://ftp.postgresql.org/pub/source/v8.4.22/
  6. ftp://ftp.se.postgresql.org/pub/databases/relational/postgresql/source/v8.4.22/
  7. ftp://ftp2.cz.postgresql.org/pub/postgresql/source/v8.4.22/
  8. ftp://ftp2.it.postgresql.org/mirrors/postgres/source/v8.4.22/
  9. ftp://ftp2.nl.postgresql.org/mirror/postgresql/source/v8.4.22/
  10. ftp://ftp3.de.postgresql.org/pub/Mirrors/ftp.postgresql.org/source/v8.4.22/
  11. ftp://ftp3.ru.postgresql.org/pub/mirror/postgresql/pub/source/v8.4.22/
  12. ftp://ftp3.tw.postgresql.org/pub/postgresql/source/v8.4.22/
  13. ftp://ftp5.es.postgresql.org/mirror/postgresql/source/v8.4.22/
  14. ftp://ftp6.pl.postgresql.org/pub/postgresql/source/v8.4.22/
  15. ftp://ftp6.ro.postgresql.org/pub/mirrors/ftp.postgresql.org/source/v8.4.22/
  16. ftp://ftp7.pl.postgresql.org/pub/mirror/ftp.postgresql.org/source/v8.4.22/
  17. http://distcache.FreeBSD.org/ports-distfiles/postgresql/
  18. http://ftp2.jp.postgresql.org/pub/postgresql/source/v8.4.22/
  19. http://ring.nict.go.jp/archives/misc/db/postgresql/source/v8.4.22/
Notes from UPDATING
These upgrade notes are taken from /usr/ports/UPDATING
  • 2012-05-30
    Affects: users of databases/postgresql*-server
    Author: jgh@FreeBSD.org
    Reason: 
      Affected users are those who use the crypt(text, text) function with
      DES encryption in the optional pg_crypto module. Passwords affected
      are those that contain characters that cannot be represented with
      7-bit ASCII. If a password contains a character that has the most
      significant bit set (0x80), and DES encryption is used, that character
      and all characters after it will be ignored.
    
    

Number of commits found: 110 (showing only 10 on this page)

«  1 | 2 

Commit History - (may be incomplete: see SVNWeb link above for full details)
DateByDescription
03 Feb 2010 15:09:09
Original commit files touched by this commit  8.4.2_1
 This port version is marked as vulnerable.
girgen search for other commits by this committer
Reintegrate the patch for ICU (unicode support).
04 Jan 2010 20:37:30
Original commit files touched by this commit  8.4.2_1
 This port version is marked as vulnerable.
ale search for other commits by this committer
PTHREAD_[CFLAGS|LDFLAGS] are already set in CONFIGURE_ENV.

Approved by:    portmgr and maintainer timeout (1 month)
04 Jan 2010 20:29:37
Original commit files touched by this commit  8.4.2_1
 This port version is marked as vulnerable.
ale search for other commits by this committer
Don't link unneeded PTHREAD_LIBS. This fixes php extensions and apache modules.

Approved by:    portmgr and maintainer timeout (1 month)
17 Dec 2009 16:07:12
Original commit files touched by this commit  8.4.2
 This port version is marked as vulnerable.
mm search for other commits by this committer
- 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)
02 Dec 2009 22:21:27
Original commit files touched by this commit  8.4.1
 This port version is marked as vulnerable.
mm search for other commits by this committer
- 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)
19 Sep 2009 22:06:02
Original commit files touched by this commit  8.4.0_1
 This port version is marked as vulnerable.
pav search for other commits by this committer
- 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
15 Jul 2009 16:56:10
Original commit files touched by this commit  8.4.0_1
 This port version is marked as vulnerable.
dougb search for other commits by this committer
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.
08 Jul 2009 20:31:53
Original commit files touched by this commit  8.4.0_1
 This port version is marked as vulnerable.
girgen search for other commits by this committer
Fix broken pkg-plist for gettext files.

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

PR:     136468 [1]
08 Jul 2009 06:57:26
Original commit files touched by this commit  8.4.0
 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
07 Jul 2009 22:30:06
Original commit files touched by this commit  8.4.0
 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

Number of commits found: 110 (showing only 10 on this page)

«  1 | 2 

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
chromiumAug 26
fileAug 21
py-djangoAug 21
py-django-develAug 21
py-django14Aug 21
py-django15Aug 21
php53Aug 18
phpmyadminAug 17
chromiumAug 13
serfAug 11
subversionAug 11
subversion17Aug 11
nginxAug 09
nginx-develAug 09
mingw32-opensslAug 06

6 vulnerabilities affecting 9 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 24039
Broken 144
Deprecated 178
Ignore 415
Forbidden 17
Restricted 212
No CDROM 94
Vulnerable 23
Expired 95
Set to expire 167
Interactive 0
new 24 hours 3
new 48 hours8
new 7 days33
new fortnight89
new month260

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