postgresql91-server 9.1.3 databases =13

The most advanced open-source database available anywhere
Maintained by: pgsql@FreeBSD.org
Port Added: 28 Apr 2011 07:47:27
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/postgresql91-client

databases/postgresql91-contrib

databases/postgresql91-docs

databases/postgresql91-plperl

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

Required by:
for Build

databases/postgresql91-pltcl

for Run

databases/postgresql91-plperl databases/postgresql91-pltcl www/thundersnarf

---

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

---

Configuration Options

===> The following configuration options are available for postgresql-server-9.1.3:
     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.1.3/

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Break postgresql-pltcl up into versioned ports; now we will have packages

Fix plist for 9.1

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

Don't clobber do-build from slave ports

PR:             ports/165265
Submitted by:   Ben Morrow <ben@morrow.me.uk>

Over to new team, pgsql@FreeBSD.org

Fix plist.

Pointyhat:      pav --> girgen

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

Fix -plperl plist for 9.1

Install new pg_basebackup tool by default

Submitted by:   kuriyama

Minor changes for UNIQUENAME; remove excessive hyphens

Apologies for the noise here; I'm getting used to the consequences of
slaving ports like this-- postgresql has an unusual arrangement here.

Submitted by:   Neil Darlow (neil@darlow.co.uk)

- Stop clobbering postgresql-server/-client OPTIONS with -contrib OPTIONS
- Minor optimisation (stop testing for !SLAVE_ONLY twice)

PR:             ports/164662

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

- do not conflict with postgresql 7.x (we don't have them in a tree anymore)
- remove not-supported FreeBSD versions
- whitespace fixes in pkg-descr
- remove empty pkg-plist (portlint doesn't seems care)

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

- Fix plist when postgresql-plpython installed for postgresql 9.1 and
  postgresql-plpython built with python 3+

PR:             ports/161822
Submitted by:   sunpoet
Approved by:    Ruslan Mahmatkhanov <cvs-src@yandex.ru> (maintainer), girgen
(maintainer implicit)

- 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 ICU support to PostgreSQL 9.1 server
- Make SSL available as an option
- Make portlint happier
- Fix some typos

PR:             ports/160915
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 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

Update to PostgreSQL version 9.1.0
SITE: http://www.postgresql.org/docs/9.1/static/release-9-1.html

- Unbreak slaves

Reported by:    Portsnap buildbox

- Make those OPTIONS actually working at all

Reported by:    pointyhat

Update to 9.1 beta 3
Fix broken plist for the postgres user's home directory
Release notes at http://www.postgresql.org/about/news.1331

- Mark BROKEN: leave a directory behind on deinstall

Reported by:    pointyhat

Update to 9.1beta2
Fix proken plists wrt NLS

Add postgresql 9.1 beta1.

See http://www.postgresql.org/about/news.1313 for more info.

Also, use USERS knob instead of explicitally creating the pgsql user
while still accepting alternative names, using [1] with some added
magic.

PR:     157667 [1]

Forced commit to document that repocopy from postgresql90-server was made.
PR:  ports/156485

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

^* - modified, not new

All vulnerabilities