postgresql90-server 9.0.7_1 databases =13

The most advanced open-source database available anywhere
Maintained by: pgsql@FreeBSD.org
Port Added: 15 Sep 2010 19:06:48
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/postgresql90-client

databases/postgresql90-contrib

databases/postgresql90-docs

databases/postgresql90-plperl

databases/postgresql90-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/postgresql90-client

Required by:
for Build

databases/postgresql90-pltcl

for Run

databases/postgresql90-plperl databases/postgresql90-pltcl

---

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

---

Configuration Options

===> The following configuration options are available for postgresql-server-9.0.7_1:
     NLS=on (default) "Use internationalized messages"
     DTRACE=off (default) "Build with DTrace probes (server only)"
     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"
     GSSAPI=off (default) "Build with GSSAPI support"
     OPTIMIZED_CFLAGS=off (default) "Builds with compiler optimizations (-O3)"
     XML=on (default) "Build with XML data type (server)"
     TZDATA=on (default) "Use internal timezone database (server)"
     DEBUG=off (default) "Builds with debugging symbols"
     ICU=off (default) "Use ICU for unicode collation (server)"
     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/v9.0.7/

ftp://ftp9.us.postgresql.org/pub/mirrors/postgresql/source/v9.0.7/

ftp://ftp10.us.postgresql.org/pub/postgresql/source/v9.0.7/

http://ring.nict.go.jp/archives/misc/db/postgresql/source/v9.0.7/

ftp://ftp.at.postgresql.org/db/www.postgresql.org/pub/source/v9.0.7/

ftp://ftp.be.postgresql.org/postgresql/source/v9.0.7/

ftp://ftp2.cz.postgresql.org/pub/postgresql/source/v9.0.7/

ftp://ftp.ee.postgresql.org/mirrors/postgresql/source/v9.0.7/

ftp://ftp.de.postgresql.org/mirror/postgresql/source/v9.0.7/

ftp://ftp3.de.postgresql.org/pub/Mirrors/ftp.postgresql.org/source/v9.0.7/

ftp://ftp.gr.postgresql.org/pub/databases/postgresql/source/v9.0.7/

ftp://ftp.ie.postgresql.org/mirrors/ftp.postgresql.org/pub/source/v9.0.7/

ftp://ftp2.it.postgresql.org/mirrors/postgres/source/v9.0.7/

http://ftp2.jp.postgresql.org/pub/postgresql/source/v9.0.7/

ftp://ftp.lv.postgresql.org/pub/postgresql/source/v9.0.7/

ftp://ftp2.nl.postgresql.org/mirror/postgresql/source/v9.0.7/

ftp://ftp6.pl.postgresql.org/pub/postgresql/source/v9.0.7/

ftp://ftp7.pl.postgresql.org/pub/mirror/ftp.postgresql.org/source/v9.0.7/

ftp://ftp6.ro.postgresql.org/pub/mirrors/ftp.postgresql.org/source/v9.0.7/

ftp://ftp2.ru.postgresql.org/pub/databases/postgresql/source/v9.0.7/

ftp://ftp3.ru.postgresql.org/pub/mirror/postgresql/pub/source/v9.0.7/

ftp://ftp5.es.postgresql.org/mirror/postgresql/source/v9.0.7/

ftp://ftp3.tw.postgresql.org/pub/postgresql/source/v9.0.7/

ftp://ftp.postgresql.org/pub/source/v9.0.7/

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

Fix pkg-plist

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

- 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 OPTION to postgresql9[10]-contrib for building without uuid-ossp

Requested by:   sunpoet

- 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

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

- Add SSL to OPTIONS
- Make portlint happier
- Fix typo

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

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

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

Don't rebuild manual pages if configure was changed

Sometimes patches for PostgreSQL touch its configure script.  And the
logics inside current Makefiles for the documentation makes the manual
pages (and other stuff) to be dependent of the timestamp of the
top-level configure file.  This triggers the rebuild of the manual
pages, but since some additional XML-related tools are needed, this
rebuild can fail.

PR: 159844
Approved by: maintainer timeout (1 month)
Feature safe: yes

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

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/157669
Submitted by:   me
Approved by:    maintainer timeout (girgen, 7 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

Fix typo in 502.pgsql script

PR: 156515

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/153888
Submitted by:   az@
Approved by:    maintainer (timeout)
Feature safe:   yes

- Update to 9.0.2
- 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)

Obtained from:  mm
Approved by:    portmgr (linimon)

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)

Make postgresql90-client depend on libxml. Technically it does not depend on
libxml,
only postgresql90-server does, but since we don't want two different pg_config
setups,
one for client and one for server, I'm bringing the libxml dependency on board
until
I can find out a better way to solve this.

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

PostgreSQL 9.0 is here!  The PostgreSQL Global Development Group
announces the availability of our most eagerly awaited release.
PostgreSQL 9.0 includes built-in, binary replication, and over a dozen
other major features which will appeal to everyone from web developers
to database hackers.

9.0 includes more major features than any release before it, including:
* Hot standby
* Streaming replication
* In-place upgrades
* 64-bit Windows builds
* Easy mass permissions management
* Anonymous blocks and named parameter calls for stored procedures
* New windowing functions and ordered aggregates

Autotools update.   Read ports/UPDATING 20100915 for details.

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

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

^* - modified, not new

All vulnerabilities