postgresql84-server 8.4.11 databases =18

The most advanced open-source database available anywhere
Maintained by: pgsql@FreeBSD.org
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/

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

---

Slave ports

databases/postgresql84-client

databases/postgresql84-contrib

databases/postgresql84-docs

databases/postgresql84-plperl

databases/postgresql84-pltcl

---

NOTE: FreshPorts displays only required dependencies information. Optional dependencies are not covered.
Required To Build: devel/gmake
Required Libraries: textproc/libxml2, devel/gettext, databases/postgresql84-client

Required by:
for Build

databases/postgresql84-pltcl

for Run

databases/postgresql84-plperl databases/postgresql84-pltcl www/thundercache

---

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

---

Configuration Options

===> The following configuration options are available for postgresql-server-8.4.11:
     NLS=on (default) "Use internationalized messages"
     DTRACE=off (default) "Build with DTrace probes (server only)"
     GSSAPI=off (default) "Build with GSSAPI support"
     XML=on (default) "Build with XML data type (server)"
     TZDATA=on (default) "Use internal timezone database (server)"
     ICU=off (default) "Use ICU for unicode collation (server)"
     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)"
     DEBUG=off (default) "Builds with debugging symbols"
     INTDATE=on (default) "Builds with 64-bit date/time type (server)"
     SSL=on (default) "Build with OpenSSL support"
===> Use 'make config' to modify these settings

---

Master Sites:

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

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

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

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

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

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

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

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

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

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

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

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

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

http://ftp2.jp.postgresql.org/pub/postgresql/source/v8.4.11/

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

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

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

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

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

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

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

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

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

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

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

Various tidiness patches:
 - Compact -plperl ports
 - Portlint for 90-plperl
 - Update version numbers in pkg-install-server
 - s/spaces/tabs/
 - Use ${} instead of $()
 - s/YES/yes/
 - Tidy IGNORE values

Submitted by:   sunpoet

Over to new team, pgsql@FreeBSD.org

The PostgreSQL Global Development Group today released security updates for all
active branches of the PostgreSQL object-relational database system, including
versions 9.1.3, 9.0.7, 8.4.11 and 8.3.18.

Users of pg_dump, users of SSL certificates for validation or users of triggers
using SECURITY DEFINER should upgrade their installations immediately. All
other database administrators are urged to upgrade your version of PostgreSQL
at the next scheduled downtime. More details on the security fixes here:

URL:    http://www.postgresql.org/about/news/1377/

Security: http://cve.mitre.org/cgi-bin/cvename.cgi?name=CVE-2012-0866
Security: http://cve.mitre.org/cgi-bin/cvename.cgi?name=CVE-2012-0867
Security: http://cve.mitre.org/cgi-bin/cvename.cgi?name=CVE-2012-0868

Remove p5- from postgresql*-plperl 's mention in pkg-message-client

Look for the correct ICU patchfile

Submitted by:   Jaime Bozza <jbozza@mindsites.com>

Use DISTVERSION instead of PORTVERSION to generate UNIQUENAME; options
don't work correctly otherwise.

http://lists.freebsd.org/pipermail/freebsd-ports/2012-January/072756.html

Pointyhat:      crees

- To preserve my sanity, slave 82 and 83 to 84, and 90 to 91, resulting in
  three fewer Makefiles to maintain

- Switch patch master site

- Various cleanups

- Add profile support for PostgreSQL servers
- re-assign LOCALBASE to PREFIX
- add PG_GROUP to SUB_PLIST for packaging fix
- fix permissions for package installations

PR:     ports/162776
Submitted by:   jgh, Phil Phillips < pphillips at experts-exchange.com >
Reviewed by: rene (mentor)
Approved by: crees (maintainer, mentor)

fix typo %%PG_GROUP%% in pkg-plist-server

Spotted by: decke
Approved by:    crees, rene (mentors,implicit)

- Reset ports due to maintainer timeouts and lack of response to emails

With hat:       portmgr

Fix plist to create directory with proper ownerships PostgreSQL database
may start.

PR:     ports/164273 (critical)
Submitted by: Alexander Yerenkow <yerenkow at gmail.com>
Approved by:    maintainer-timeout: girgen (1 day), portmgr (linimon)

In the rc.d scripts, change assignments to rcvar to use the
literal name_enable wherever possible, and ${name}_enable
when it's not, to prepare for the demise of set_rcvar().

In cases where I had to hand-edit unusual instances also
modify formatting slightly to be more uniform (and in
some cases, correct). This includes adding some $FreeBSD$
tags, and most importantly moving rcvar= to right after
name= so it's clear that one is derived from the other.

The PostgreSQL Global Development Group today released updates for all
active branches of the PostgreSQL object-relational database system,
including versions 9.1.2, 9.0.6, 8.4.10, 8.3.17 and 8.2.23.

This release contains 52 fixes to version 9.1, and a smaller number of
fixes to older versions, including:

- Fix bugs in information_schema.referential_constraints view**
- Correct collations for citext columns and indexes**
- Prevent possible crash when joining to a scalar function
- Prevent transitory data corruption of GIN indexes after a crash
- Prevent data corruption on TOAST columns when copying data
- Fix failures during hot standby startup
- Correct another "variable not found in subplan target list" bug
- Fix bug with sorting on aggregate expressions in windowing functions

Add DTRACE option for postgresql84-server

PR:             ports/150431
Submitted by:   rpaulo

Fix compilation with GSSAPI

PR:             ports/161786
Submitted by:   rea
Reviewed by:    mandree, John Marshall <john.marshall@riverwillow.com.au>

Mark IGNORE if DTRACE enabled for FreeBSD < 900021 without userland dtrace

PR:             ports/152502
Submitted by:   Sevan Janiyan <venture37@geeklan.co.uk>

Approved by:    maintainer timeout (girgen, at least 2 months)
Feature safe:   yes

Actually add the pgsql users on install

PR:             ports/162239
Approved by:    portmgr (pav)

Make SSL available as an option

PR:             ports/161330
Approved by:    maintainer (timeout)

- Fix packaging issue (missed %%PG_USER%% in pkg-plist-server)
- Remove extra bsd.port.pre.mk include from postgresql82-server

PR:             ports/161816 ports/161824 ports/161821
Submitted by:   Jason Helfman (jhelfman@e-e.com)
Approved by:    portmgr (pav)

This time remember to bump PORTREVISION

Fix SUB_LIST issue by deconditionalising it.

Temporary fix, but will stop the flurry of incoming PRs related.

PR:             ports/161779 ports/161774 ports/161791 ports/161771 ports/161769
Submitted by:   Many people, original fix suggested by Jason Helfman
(jhelfman@e-e.com)
Approved by:    portmgr (pav)

The PostgreSQL Global Development Group today released minor version updates
for all active branches of the PostgreSQL object-relational database system,
including versions 9.1.1, 9.0.5, 8.4.9, 8.3.16 and 8.2.22.

All users are strongly urged to update their installations at the next
scheduled downtime.

URL:    http://www.postgresql.org/about/news.1355

Cleanup ports. Better handling of the knob PG_USER.
Also add uuid to 9.0 and 9.1 contrib ports.

- Unbreak postgresql-plpython: allow build with threaded python
- Pass maintainership to submitter

PR:             ports/159843
Submitted by:   Ruslan Mahmatkhanov <cvs-src@yandex.ru>

PostgreSQL: unbreak 'make describe'

It was a really bad idea to include bsd.port.pre.mk
inside a conditional expression.

Detected by: portsnap buildbox
Pointyhat to: rea

PostgreSQL: unbreak GSSAPI support

The problem with GSSAPI without Kerberos is that configure.in has
very funny logics of choosing GSSAPI libraries:
{{{
if test "$with_gssapi" = yes ; then
  if test "$PORTNAME" != "win32"; then
    AC_SEARCH_LIBS(gss_init_sec_context, [gssapi_krb5 gss 'gssapi -lkrb5
-lcrypto'], [],
                                  [AC_MSG_ERROR([could not find function
'gss_init_sec_context' required for GSSAPI])])
  else
    LIBS="$LIBS -lgssapi32"
  fi
fi
}}}

- Add LDFLAGS to CONFIGURE_ENV and MAKE_ENV (as it was done with LDFLAGS)
- Fix all ports that add {CPP,LD}FLAGS to *_ENV to modify flags instead

PR:             157936
Submitted by:   myself
Exp-runs by:    pav
Approved by:    pav

- Hack to allow building of -client port.  The OPTIONS handling is still broken.

Submitted by:   Ruslan Mahmatkhanov <cvs-src@yandex.ru>

Revert previous commit -- appears to cause rc problems as I missed some subs

freebsd-ports@freebsd.org/msg35324.html">http://www.mail-archive.com/freebsd-ports@freebsd.org/msg35324.html

PR:             ports/157558 ports/157559 ports/157666 ports/157669
Submitted by:   rihad@mail.ru
Approved by:    maintainer (girgen; implicit -- this reverts a commit I did
after maintainer timeout)

- Fix databases/p5-postgresql-plperl build with Perl 5.14

This patch is for PostgreSQL 8.2, 8.3, 8.4 and 9.0.
PostgreSQL 9.1 has it already.

PR:             ports/158727
Submitted by:   sunpoet (myself)
Approved by:    girgen (maintainer timeout, 5 weeks)

Use USERS and GROUPS

PR:             ports/157666
Submitted by:   me
Approved by:    maintainer timeout (girgen, 8 weeks)

- update ICU to 4.8
- chase library bump
- add an entry in UPDATING for instructions
- remove old conflict lines

- Mark BROKEN on FreeBSD 9.X: does not link

  libpq/auth.o: In function `pg_GSS_error':
  auth.c:(.text+0x6e): undefined reference to `gss_display_status'
  [..]

Reported by:    pointyhat

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

Fix problem creating postgres user when PGUSER was set.

PR: 156662

Update PostgreSQL to 9.0.4, 8.4.8, 8.3.15 and 8.2.21.

This update contains a critical fix to the pg_upgrade utility
which prevents significant downtime issues. Do not use
pg_upgrade without installing this update first.

The issue with pg_upgrade and the fix are detailed on the PostgreSQL
wiki: http://wiki.postgresql.org/wiki/20110408pg_upgrade_fix
Users who have already used pg_upgrade should run the database repair
script given on that page on their databases as soon as possible.

See the release notes for each version at
http://www.postgresql.org/docs/current/static/release.html for a full
list of changes with details.

Allow the username of the postgresql user to configurable for 8.4 and 9.0.
Largely inspired by the work of Jason Helfman [153668, 153136].

Change PGUSER knob to PG_USER not to clash with PGUSER environment.

PR: 153668, 153136, 155493, 155137

Update to versions 9.0.3, 8.4.7, 8.3.14 and 8.2.20.

This update includes a security fix which prevents a buffer overrun in
the contrib module intarray's input function for the query_int type.
This bug is a security risk since the function's return address could
be overwritten by malicious code.

All supported versions of PostgreSQL are impacted. However, the
affected contrib module is optional. Only users who have installed the
intarray module in their database are affected. See the CVE Advisory
at http://cve.mitre.org/cgi-bin/cvename.cgi?name=CVE-2010-4015

This release includes 63 bugfixes, including:

- Avoid unexpected conversion overflow in planner for distant date values

Fix @dirrmtry since it already filter stderr and return true.

PR:             ports/153894
Submitted by:   az@
Approved by:    maintainer (timeout)
Feature safe:   yes

- Update to 8.4.6
- Unify ICU handling

PR:             ports/153245
Approved by:    maintainer (timeout)

- Prepare for devel/icu4 deletion
- fix py-icu with icu4.6
- fix portsgresql*server with icu 4.6
- remove now useless icu patch from webkit

Chase devel/icu upgrade
Add an updating note

- Fix build if WITH_ICU or WITH_ICU4 defined (bsd.autotools.mk update)

Approved by:    portmgr (pav)

Sync to new bsd.autotools.mk

- Use dirrmtry on share/postgresql/tsearch_data for postgresql{83|84|90}-server
- Bump PORTREVISION

PR:             ports/151882
Submitted by:   sunpoet (myself)
Approved by:    girgen (maintainer timeout, 20 days)

- Fix optional dependency on security/heimdal
- Bump PORTREVISION
PR:             ports/152029
Submitted by:   Joerg Pulz [Joerg.Pulz frm2.tum.de]
Approved by:    Ryan Steinmetz <rpsfa@rit.edu> (maintainer of net/freeradius*)
                girgen (maintainer of databases/postgresql*-server,
                        14 day timeout)

Punt autoconf267->autoconf268

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

- fix autoconf limitation in configure.in if WITH_ICU or WITH_ICU4 are used

PR:             ports/151066, ports/150635
Approved by:    maintainer (timeout in ports/150635)

Autotools update.   Read ports/UPDATING 20100915 for details.

Approved by:    portmgr (for Mk/bsd.port.mk part)
Tested by:      Multiple -exp runs

Fix build with ICU4 option after ICU 4.4 update

PR:             ports/148837
Approved by:    maintainer (timeout)

BROKEN should not be quoted.
No functional change.

Fix package list

Fix broken plist
PR: ports/147312

Bounce PORTREVISION for gettext-related ports.  Have fun, ya'll.

- Mark client port broken - leaves files behind on deinstall

Reported by:    pointyhat

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.

Begin the process of deprecating sysutils/rc_subr by
s#. %%RC_SUBR%%#. /etc/rc.subr#

- Add ICU 4.x support
- Bump PORTREVISION

PR:             ports/143841
Submitted by:   Andrei Lavreniyuk <andy.lavr@reactor-xg.kiev.ua>
Approved by:    maintainer (timeout)

Update to 8.4.3.

PR:             ports/144863
Submitted by:   Alexander <alp rsu ru>
Security:       e050119b-3856-11df-b2b2-002170daae37
With hat:       ports-security@

Reintegrate the patch for ICU (unicode support).

PTHREAD_[CFLAGS|LDFLAGS] are already set in CONFIGURE_ENV.

Approved by:    portmgr and maintainer timeout (1 month)

Don't link unneeded PTHREAD_LIBS. This fixes php extensions and apache modules.

Approved by:    portmgr and maintainer timeout (1 month)

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

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

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.

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

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 17 ports have been reported in the past 14 days

^* - modified, not new

All vulnerabilities