postgresql82-server 8.2.9 databases =31

The most advanced open-source database available anywhere
Maintained by: girgen@FreeBSD.org
Port Added: 06 Nov 2006 09:03:46

---

---

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/

CVSWeb : Sources : Main Web Site : Distfiles Availability : PortsMon

---

Slave ports

databases/p5-postgresql-plperl

databases/postgresql-contrib

databases/postgresql-docs

databases/postgresql-plpython

databases/postgresql-pltcl

databases/postgresql82-client

---

Required To Build: devel/gmake
Required Libraries: devel/gettext, databases/postgresql82-client

---

To install the port: cd /usr/ports/databases/postgresql82-server/ && make install clean
To add the package: pkg_add -r postgresql82-server

---

Configuration Options

===> The following configuration options are available for postgresql-server-8.2.9:
     NLS=on (default) "Use internationalized messages"
     PAM=off (default) "Build with PAM support (server only)"
     LDAP=off (default) "Build with LDAP authentication support"
     MIT_KRB5=off (default) "Build with MIT's kerberos support"
     HEIMDAL_KRB5=off (default) "Builds with Heimdal kerberos support"
     OPTIMIZED_CFLAGS=off (default) "Builds with compiler optimizations (-O3)"
     TESTS=off (default) "Allows the use of a "check" target (server)"
     DEBUG=off (default) "Builds with debugging symbols"
     INTDATE=off (default) "Builds with 64-bit date/time type (server)"
===> Use 'make config' to modify these settings

---

Master Sites:

ftp://ftp8.us.postgresql.org/postgresql/source/v8.2.9/

ftp://ftp9.us.postgresql.org/pub/mirrors/postgresql/source/v8.2.9/

ftp://ftp10.us.postgresql.org/pub/postgresql/source/v8.2.9/

http://ring.nict.go.jp/archives/misc/db/postgresql/source/v8.2.9/

http://ring.sakura.ad.jp/archives/misc/db/postgresql/source/v8.2.9/

http://ring.riken.jp/archives/misc/db/postgresql/source/v8.2.9/

ftp://ftp.au.postgresql.org/pub/postgresql/source/v8.2.9/

ftp://ftp.at.postgresql.org/db/www.postgresql.org/pub/source/v8.2.9/

ftp://ftp.be.postgresql.org/postgresql/source/v8.2.9/

ftp://ftp.ba.postgresql.org/pub/postgresql/source/v8.2.9/

ftp://ftp.cz.postgresql.org/DATA/postgresql/source/v8.2.9/

ftp://ftp2.cz.postgresql.org/pub/postgresql/source/v8.2.9/

ftp://ftp.ee.postgresql.org/mirrors/postgresql/source/v8.2.9/

ftp://ftp.fr.postgresql.org/source/v8.2.9/

ftp://ftp.de.postgresql.org/mirror/postgresql/source/v8.2.9/

ftp://ftp3.de.postgresql.org/pub/Mirrors/ftp.postgresql.org/source/v8.2.9/

ftp://ftp.gr.postgresql.org/pub/databases/postgresql/source/v8.2.9/

ftp://ftp.hk.postgresql.org/postgresql/source/v8.2.9/

ftp://ftp.ie.postgresql.org/mirrors/ftp.postgresql.org/pub/source/v8.2.9/

ftp://ftp2.it.postgresql.org/mirrors/postgres/source/v8.2.9/

ftp://ftp.kr.postgresql.org/postgresql/source/v8.2.9/

ftp://ftp.lv.postgresql.org/pub/postgresql/source/v8.2.9/

ftp://ftp2.nl.postgresql.org/mirror/postgresql/source/v8.2.9/

ftp://ftp4.nl.postgresql.org/postgresql.zeelandnet.nl/source/v8.2.9/

ftp://ftp6.pl.postgresql.org/pub/postgresql/source/v8.2.9/

ftp://ftp7.pl.postgresql.org/pub/mirror/ftp.postgresql.org/source/v8.2.9/

ftp://ftp6.ro.postgresql.org/pub/mirrors/ftp.postgresql.org/source/v8.2.9/

ftp://ftp.ru.postgresql.org/pub/unix/database/pgsql/source/v8.2.9/

ftp://ftp2.ru.postgresql.org/pub/databases/postgresql/source/v8.2.9/

ftp://ftp3.ru.postgresql.org/pub/mirror/postgresql/pub/source/v8.2.9/

ftp://ftp5.es.postgresql.org/mirror/postgresql/source/v8.2.9/

ftp://ftp.se.postgresql.org/pub/databases/relational/postgresql/source/v8.2.9/

ftp://ftp3.tw.postgresql.org/pub/postgresql/source/v8.2.9/

ftp://ftp.postgresql.org/pub/source/v8.2.9/

ftp://ftp.FreeBSD.org/pub/FreeBSD/ports/distfiles/postgresql/

• 2007-01-09

  Affects: users of databases/postgresql*

  Author: girgen@FreeBSD.org

  Reason: 
    The server-side utilities of postgresql (initdb, initlocation,
    ipcclean, pg_controldata, pg_ctl, pg_id and pg_resetxlog) are now
    installed by the respective postgresql*-server port (previously
    they where installed with the client). If you update the client, you
    should also update the server to make sure you are not left without
    the server-side tools. Do something like:
  
  	portupgrade postgresql-client postgresql-server
  
  



• 2006-11-08

  Affects: users of databases/postgresql*-server

  Author: Palle Girgensohn <girgen@FreeBSD.org>

  Reason: 
    With the latest patch release of the PostgreSQL ports, the rc script
    is renamed `postgresql'.
  
  

Conversion from (now defunct) autoconf-2.61 to autoconf-2.62

Tested by:      exp build run (erwin)

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

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)

- Remove USE_GETOPT_LONG which is a no-op since March 200

Update to 8.2.7

Release notes:
http://developer.postgresql.org/pgdocs/postgres/release-8-2-7.html

Remove HIER patch option, since it is not available anymore. The site
is down and original author responses that he does not maintain it
anymore.

PR:     ports/116423
Remove option to build and link with thread safety, and always build
thread safe instead. Decided after a discussion with postgresql
hackers, and tested for a while in postgresql83. This helps when
for example linking with openldap, or for using certain programming
languages as postgresql functions.

Update all PostgreSQL ports to latest versions.

This includes a bunch of security fixes: CVE-2007-6067, CVE-2007-4772,
CVE-2007-6601, CVE-2007-6600 and CVE-2007-4769.

Security: http://www.postgresql.org/about/news.905

Migration from bison 1.x to 2.x

PR:             117086
Tested by:      -exp runs

Remove always-false/true conditions based on OSVERSION 500000

Fix plist

Approved by:    maintainer

Update PostgreSQL ports to the latest patch releases.

PR: ports/104075

- Welcome X.org 7.2 \o/.
- Set X11BASE to ${LOCALBASE} for recent ${OSVERSION}.
- Bump PORTREVISION for ports intalling files in ${X11BASE}.

Update PostgreSQL to 7.3.19, 7.4.17, 8.0.13, 8.1.9 and 8.2.4 respectively:

 The PostgreSQL Global Development Group has released updated versions
 for PostgreSQL 8.2 and all back versions to patch a privilege
 escalation exploit in SECURITY DEFINER functions.  All users of this
 feature are urged to update to the latest minor version and follow
 instructions on securing these functions as soon as possible.  This
 minor release also contains other fixes, so all users should plan to
 deploy it.

 Once you have updated, additional steps are required to secure your
 database against the exploit.  Please read the release notes at
 http://www.postgresql.org/docs/8.2/static/release.html and the
 TechDocs article at http://www.postgresql.org/docs/techdocs.77 on how
 to lock down your security definer functions, if you use them.

Respect PTHREAD_CFLAGS/PTHREAD_LIBS.

Approved by:    maintainer timeout (1 month)

Update PostgreSQL 8.x to 8.0.12, 8.1.8 and 8.2.3 respectively:

  The recent security release (8.0.11, 8.1.7, 8.2.2) has been withdrawn.
  It contained an issue which causes error with custom data types, type
  constraints and expression indexes. These upgrades fix the problem.

Add option to build with LDAP authentication

Suggested by: Ederson de Moura

Update PostgreSQL with, amongst other things, two security fixes:

  A vulnerability allows suppressing the normal checks that a SQL
  function returns the data type it's declared to do. These errors can
  easily be exploited to cause a backend crash, and in principle might
  be used to read database content that the user should not be able to
  access. [CVE-2007-0555]

  A vulnerability involving changing the data type of a table column
  can easily be exploited to cause a backend crash, and in principle
  might be used to read database content that the user should not be
  able to access. [CVE-2007-0556]

The release includes a set of other fixes as well. Please see the
release information at
http://www.postgresql.org/docs/8.2/static/release-8-2-2.html

Security: http://cve.mitre.org/cgi-bin/cvename.cgi?name=CVE-2007-0555
Security: http://cve.mitre.org/cgi-bin/cvename.cgi?name=CVE-2007-0556

Update postgresql to 8.2.1, 8.1.6, 8.0.10, 7.4.15 and 7.3.17.

Release notes:
http://www.postgresql.org/docs/7.3/static/release.html#RELEASE-7-3-17
http://www.postgresql.org/docs/7.4/static/release.html#RELEASE-7-4-15
http://www.postgresql.org/docs/8.0/static/release.html#RELEASE-8-0-10
http://www.postgresql.org/docs/8.1/static/release.html#RELEASE-8-1-6
http://www.postgresql.org/docs/8.2/static/release-8-2-1.html

The server-side utilities of postgresql (initdb, initlocation,
ipcclean, pg_controldata, pg_ctl, pg_id and pg_resetxlog) are now
installed by the respective postgresql*-server port (previously they
where installed with the client). If you update the client, you should
also update the server to make sure you are not left without the
server-side tools. Do something like:

    portupgrade postgresql-client postgresql-server

Fix build problems when using WITH_THREADSAFE

Welcome new release of the world's most advanced open source database:
PostgreSQL 8.2.0

Complete release notes are available at
http://www.postgresql.org/docs/current/static/release-8-2.html

Mark as work in progress

2 vulnerabilities affecting 3 ports have been reported in the past 14 days

^* - modified, not new

All vulnerabilities