NOTICE: This package has been removed from pkgsrc

./databases/postgresql90-server, PostgreSQL database server programs

[ CVSweb ] [ Homepage ] [ RSS ] [ Required by ]


Branch: CURRENT, Version: 9.0.22, Package name: postgresql90-server-9.0.22, Maintainer: adam

PostgreSQL is a robust, next-generation, Object-Relational DBMS (ORDBMS),
derived from the Berkeley Postgres database management system. While
PostgreSQL retains the powerful object-relational data model, rich data types
and easy extensibility of Postgres, it replaces the PostQuel query language
with an extended subset of SQL.

PostgreSQL is free and the complete source is available.

This package contains the database server programs.

DEINSTALL [+/-]

Required to run:
[databases/postgresql90-client]

Master sites:

SHA1: 0600cce0ac2e7d28be6b094d0c7b955c129c6461
RMD160: 28fd591e44651c167575c0c4de6a20bc8bb65885
Filesize: 14693.974 KB

Version history: (Expand)


CVS history: (Expand)


   2015-02-14 13:39:52 by Adam Ciarcinski | Files touched by this commit (5)
Log message:
Changes 9.0.19:
Security Fixes
* CVE-2015-0241 Buffer overruns in "to_char" functions.
* CVE-2015-0242 Buffer overrun in replacement printf family of functions.
* CVE-2015-0243 Memory errors in functions in the pgcrypto extension.
* CVE-2015-0244 An error in extended protocol message reading.
* CVE-2014-8161 Constraint violation errors can cause display of values in \ 
columns which the user would not normally have rights to see.

JSON and JSONB Unicode Escapes

Other Fixes and Improvements
* Cope with the non-ASCII Norwegian Windows locale name.
* Avoid data corruption when databases are moved to new tablespaces and back again.
* Ensure that UNLOGGED tables are correctly copied during ALTER DATABASE operations.
* Avoid deadlocks when locking recently modified rows.
* Fix two SELECT FOR UPDATE query issues.
* Prevent false negative for shortest-first regular expression matches.
* Fix false positives and negatives in tsquery contains operator.
* Fix namespace handling in xpath().
* Prevent row-producing functions from creating empty column names.
* Make autovacuum use per-table cost_limit and cost_delay settings.
* When autovacuum=off, limit autovacuum work to wraparound prevention only.
* Multiple fixes for logical decoding in 9.4.
* Fix transient errors on hot standby queries due to page replacement.
* Prevent duplicate WAL file archiving at end of recovery or standby promotion.
* Prevent deadlock in parallel restore of schema-only dump.
   2015-01-01 10:48:59 by David A. Holland | Files touched by this commit (5)
Log message:
If postgres really still doesn't have mips atomics, it should be fixed
(which is easy enough for all but archaic mips) so use BROKEN_ON_PLATFORM.
   2014-12-10 15:05:42 by Filip Hajny | Files touched by this commit (5)
Log message:
Set PATH for postgresql SMF, helps 3rd party software invoked via
modules like PL/Perl.
   2014-07-26 00:14:57 by Adam Ciarcinski | Files touched by this commit (44) | Package updated
Log message:
The PostgreSQL Global Development Group has released an update to all supported \ 
version of the database system, including versions 9.3.5, 9.2.9, 9.1.14, 9.0.18, \ 
and 8.4.22. This minor release fixes a number of issues discovered and reported \ 
by users over the last four months, including some data corruption issues, and \ 
is the last update of version 8.4. Users of version 9.3 will want to update at \ 
the earliest opportunity; users of version 8.4 will want to schedule an upgrade \ 
to a supported PostgreSQL version.
   2014-03-26 14:19:13 by Filip Hajny | Files touched by this commit (2)
Log message:
Fix SMF manifests that had stale placeholders.
   2014-03-12 18:01:57 by Greg Troxel | Files touched by this commit (5)
Log message:
Drop redundant variable setting from postgresql*-server.

PGUSER, PGGROUP, and PGHOME are all in mk/defaults/mk.conf.  They are
also set (?=) in each server Makefile.  Worse, PGHOME is set to
varying values.  However, the versions in defaults prevail.
Therefore, remove the extra/confusing settings, leaving this as a
user-settable variable with a default.  pkg_info -B before and after
shows no related changes, so no PKGREVISION++.

Pointed out by Richard Palo, and ok adam@.

There's a related issue lurking, which is that PGHOME ends up being
/usr/pkg/pgsql, which is not under VARBASE, but I'm letting that be
because a change would be disruptive.
   2014-03-11 15:34:41 by Jonathan Perkin | Files touched by this commit (99)
Log message:
Import initial SMF support for individual packages.
   2014-03-11 15:05:19 by Jonathan Perkin | Files touched by this commit (350)
Log message:
Remove example rc.d scripts from PLISTs.

These are now handled dynamically if INIT_SYSTEM is set to "rc.d", or
ignored otherwise.