./databases/postgresql10, Robust, next generation, object-relational DBMS

[ CVSweb ] [ Homepage ] [ RSS ] [ Required by ] [ Add to tracker ]


Branch: CURRENT, Version: 10.5nb2, Package name: postgresql10-10.5nb2, 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 is the meta-package for the PostgreSQL database system.


Required to run:
[textproc/libxml2] [databases/postgresql10-server] [databases/postgresql10-client] [databases/postgresql10-docs]

Required to build:
[pkgtools/cwrappers]

Package options: gssapi

Master sites:

SHA1: 8c7b4406b0ba2987f4170657f89908ad47947429
RMD160: 2427223152e54ba048b3881380091530f4887b58
Filesize: 19809.158 KB

Version history: (Expand)


CVS history: (Expand)


   2018-08-22 11:48:07 by Thomas Klausner | Files touched by this commit (3558)
Log message:
Recursive bump for perl5-5.28.0
   2018-08-10 13:56:10 by Adam Ciarcinski | Files touched by this commit (27) | Package updated
Log message:
postgresql: updated to 10.5, 9.6.10, 9.5.14, 9.4.19, 9.3.24

The PostgreSQL Global Development Group has released an update to all supported \ 
versions of our database system, including 10.5, 9.6.10, 9.5.14, 9.4.19, 9.3.24. \ 
This release fixes two security issues as well as bugs reported over the last \ 
three months.

SECURITY ISSUES:
CVE-2018-10915: CERTAIN HOST CONNECTION PARAMETERS DEFEAT CLIENT-SIDE SECURITY \ 
DEFENSES
CVE-2018-10925: MEMORY DISCLOSURE AND MISSING AUTHORIZATION IN INSERT ... ON \ 
CONFLICT DO UPDATE

BUG FIXES AND IMPROVEMENTS
Several fixes related to VACUUM, including an issue that could lead to data \ 
corruption in certain system catalog tables
Several fixes for replaying write-ahead logs, including a case where a \ 
just-promoted standby server would not restart if it crashed before its first \ 
post-recovery checkpoint
Several performance improvements for replaying write-ahead logs
Several fixes for logical replication and logical decoding, including ensuring \ 
logical WAL senders are reporting the streaming state correctly
Allow replication slots to be dropped in single-user mode
Fix to have variance and similar aggregate functions return accurate results \ 
when executed using parallel query
Fix SQL-standard FETCH FIRST syntax to allow parameters ($n), as the standard expects
Fix to ensure that a process doing a parallel index scan will respond to \ 
signals, such as one to abort a query
Fix EXPLAIN's accounting for resource usage, particularly buffer accesses, in \ 
parallel workers
Several fixes for the query planner including improving the cost estimates for \ 
hash-joins and choosing to use indexes for mergejoins on composite type columns
Fix performance regression related to POSIX semaphores for multi-CPU systems \ 
running Linux or FreeBSD
Fix for GIN indexes that could lead to an assertion failure after a pg_upgrade \ 
from a version before PostgreSQL 9.4
Fix for SHOW ALL to display superuser configuration settings to roles that are \ 
allowed to read all settings
Fix issue where COPY FROM .. WITH HEADER would drop a line after every \ 
4,294,967,296 lines processed
Several fixes for XML support, including using the document node as the context \ 
for XPath queries as defined in the SQL standard, which affects the xpath and \ 
xpath_exists functions, as well as XMLTABLE
Fix libpq for certain cases where hostaddr is used
Several ecpg fixes for Windows
Fix password prompting in Windows client programs so that echo is properly disabled
Several pg_dump fixes, including correctly outputting REPLICA IDENTITY \ 
properties for constraint indexes
Make pg_upgrade check that the old server was shut down cleanly
   2018-07-20 05:34:33 by Ryo ONODERA | Files touched by this commit (705)
Log message:
Recursive revbump from textproc/icu-62.1
   2018-05-13 10:16:00 by Adam Ciarcinski | Files touched by this commit (1)
Log message:
postgresql10: reset PKGREVISION
   2018-05-13 10:13:47 by Adam Ciarcinski | Files touched by this commit (17) | Package updated
Log message:
postgresql: updated to 10.4, 9.6.9, 9.5.13, 9.4.18, 9.3.23

SECURITY ISSUES
One security vulnerability has been closed by this release:

CVE-2018-1115: Too-permissive access control list on function pg_logfile_rotate()
Please see the "Updating" section below for post-update steps.

BUG FIXES AND IMPROVEMENTS
This update also fixes over 50 bugs reported in the last several months. Some of \ 
these issues affect only version 10, but many affect all supported versions.

These fixes include:
Fix incorrect volatility and parallel-safety markings on several built-in \ 
functions to ensure correct query planning optimizations
Several fixes for partitioning, including potential crashes as well as allowing \ 
TRUE and FALSE to be used as partition bounds
Fix where a new TOAST value could be assigned to a dead-but-not-yet-vacuumed \ 
TOAST OID, which would result in an error similar to "unexpected chunk \ 
number 0 (expected 1) for toast value nnnnn"
Fix "CREATE TABLE ... LIKE" with bigint identity columns on 32-bit \ 
platforms
Fix memory leak within the runtime of a query that repeatedly executes hash joins
Several crash fixes around queries using GROUPING SET
Avoid failure if a query-cancel or session-termination interrupt occurs while \ 
committing a prepared transaction
Reduce locking during autovacuum worker scheduling, which prevents loss of \ 
potential worker concurrency
Fix possible slow execution of REFRESH MATERIALIZED VIEW CONCURRENTLY
Several fixes around query plans that use "index-only" scans
Avoid deadlocks in concurrent CREATE INDEX CONCURRENTLY commands that are run \ 
under SERIALIZABLE or REPEATABLE READ transaction isolation
Several fixes for SP-GiST indexes, including one collation-aware searches on \ 
text columns
Fixes related to counting the number of tuples in partial GiST, SP-GiST, and \ 
Bloom indexes
Several fixes for logical decoding and replication
Fix misquoting of values for list-valued GUC variables (e.g. \ 
local_preload_libraries, session_preload_libraries, shared_preload_libraries, \ 
temp_tablespaces) in dumps
Several fixes for pg_stat_activity
Several fixes for ecpg
Fix for pg_recvlogical to ensure compatibility with PostgreSQL versions released \ 
before 10
Several fixes for pg_rewind
   2018-04-14 09:34:46 by Adam Ciarcinski | Files touched by this commit (681) | Package updated
Log message:
revbump after icu update
   2018-03-02 18:12:28 by Adam Ciarcinski | Files touched by this commit (1)
Log message:
Reset PKGREVISION
   2018-03-02 18:11:12 by Adam Ciarcinski | Files touched by this commit (24) | Package updated
Log message:
postgresqlNN: updated to 10.3, 9.6.8, 9.5.12, 9.4.17, 9.3.22

PostgreSQL 10.3, 9.6.8, 9.5.12, 9.4.17, and 9.3.22:
The purpose of this release is to address CVE-2018-1058, which describes how a \ 
user can create like-named objects in different schemas that can change the \ 
behavior of other users' queries and cause unexpected or malicious behavior, \ 
also known as a "trojan-horse" attack. Most of this release centers \ 
around added documentation that describes the issue and how to take steps to \ 
mitigate the impact on PostgreSQL databases.