NOTICE: This package has been removed from pkgsrc

./databases/postgresql90-docs, PostgreSQL database documentation

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


Branch: CURRENT, Version: 9.0.22, Package name: postgresql90-docs-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 documentation.


Required to build:
[textproc/dsssl-docbook-modular] [textproc/docbook-xml] [textproc/docbook-xsl] [textproc/iso8879] [textproc/libxslt] [textproc/openjade]

Master sites:

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

Version history: (Expand)


CVS history: (Expand)


   2015-06-18 16:46:14 by Adam Ciarcinski | Files touched by this commit (25) | Package updated
Log message:
Changes:
This release primarily fixes issues not successfully fixed in prior releases. It \ 
should be applied as soon as possible all users of major versions 9.3 and 9.4. \ 
Other users should apply at the next available downtime.

Crash Recovery Fixes:
Earlier update releases attempted to fix an issue in PostgreSQL 9.3 and 9.4 with \ 
"multixact wraparound", but failed to account for issues doing \ 
multixact cleanup during crash recovery. This could cause servers to be unable \ 
to restart after a crash. As such, all users of 9.3 and 9.4 should apply this \ 
update as soon as possible.
   2015-06-12 12:52:19 by Thomas Klausner | Files touched by this commit (3152)
Log message:
Recursive PKGREVISION bump for all packages mentioning 'perl',
having a PKGNAME of p5-*, or depending such a package,
for perl-5.22.0.
   2015-06-08 14:52:08 by Adam Ciarcinski | Files touched by this commit (12)
Log message:
Changes:
* File Permissions Fix
* Have pg_get_functiondef() show the LEAKPROOF property
* Make pushJsonbValue() function push jbvBinary type
* Allow building with threaded Python on OpenBSD
   2015-05-27 15:27:28 by Adam Ciarcinski | Files touched by this commit (20) | Package updated
Log message:
The PostgreSQL Global Development Group has released an update with multiple \ 
functionality and security fixes to all supported versions of the PostgreSQL \ 
database system, which includes minor versions 9.4.2, 9.3.7, 9.2.11, 9.1.16, and \ 
9.0.20. The update contains a critical fix for a potential data corruption issue \ 
in PostgreSQL 9.3 and 9.4; users of those versions should update their servers \ 
at the next possible opportunity.
   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.
   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-05-30 01:38:20 by Thomas Klausner | Files touched by this commit (3049)
Log message:
Bump for perl-5.20.0.
Do it for all packages that
* mention perl, or
* have a directory name starting with p5-*, or
* depend on a package starting with p5-
like last time, for 5.18, where this didn't lead to complaints.
Let me know if you have any this time.
   2014-03-27 21:57:55 by Adam Ciarcinski | Files touched by this commit (16) | Package updated
Log message:
This minor release fixes a data corruption issue with replication and crash \ 
recovery in version 9.3, as well as several other minor issues in all versions. \ 
All users of version 9.3 are urged to update their installations at the next \ 
possible downtime. Users of older versions should update at their convenience.

The data corruption issue in PostgreSQL 9.3 affects binary replication standbys, \ 
servers being recovered from point-in-time-recovery backup, and standalone \ 
servers which recover from a system crash. The bug causes unrecoverable index \ 
corruption during recovery due to incorrect replay of row locking operations. \ 
This can then cause query results to be inconsistent depending on whether or not \ 
an index is used, and eventually lead to primary key violations and similar \ 
issues. For this reason, users are encouraged to replace each of their standby \ 
databases with a new base backup after applying the update.

Other PostgreSQL 9.3-only fixes in this update include:

Make sure that statistics files for dropped databases get deleted
Allow materialized views to be referenced in UPDATE and DELETE queries
Add read-only data_checksum parameter
Prevent erroneous operator push-down in postgres_fdw

This release resolves some other issues in all versions of PostgreSQL, including:
Fix timing consistency issue with NOTIFY
Allow regular expression execution to be cancelled
Improve performance of index checks for newly added rows
Prevent premature walsender disconnection
Prevent memory errors on newer Windows versions
Update timezone files