Up to [cvs.NetBSD.org] / pkgsrc / databases / postgresql95-client
Request diff between arbitrary revisions
Keyword substitution: kv
Default branch: MAIN
postgresql95: removed; EOL
postgresql: updated to 13.1, 12.5, 11.10, 10.15, 9.6.20, and 9.5.24 PostgreSQL 13.1, 12.5, 11.10, 10.15, 9.6.20, and 9.5.24 Security Issues * CVE-2020-25695: Multiple features escape "security restricted operation" sandbox * CVE-2020-25694: Reconnection can downgrade connection security settings * CVE-2020-25696: psql's \gset allows overwriting specially treated variables Bug Fixes and Improvements This update also fixes over 65 bugs that were reported in the last several months. Some of these issues only affect version 13, but may also apply to other supported versions. Some of these fixes include: Fix a breakage in the replication protocol by ensuring that two "command completion" events are expected for START_REPLICATION. Ensure fsync is called on the SLRU caches that PostgreSQL maintains. This prevents potential data loss due to an operating system crash. Fix ALTER ROLE usage for users with the BYPASSRLS permission. ALTER TABLE ONLY ... DROP EXPRESSION is disallowed on partitioned tables when there are child tables. Ensure that ALTER TABLE ONLY ... ENABLE/DISABLE TRIGGER does not apply to child tables. Fix for ALTER TABLE ... SET NOT NULL on partitioned tables to avoid a potential deadlock in parallel pg_restore. Fix handling of expressions in CREATE TABLE LIKE with inheritance. DROP INDEX CONCURRENTLY is disallowed on partitioned tables. Allow LOCK TABLE to succeed on a self-referential view instead of throwing an error. Several fixes around statistics collection and progress reporting for REINDEX CONCURRENTLY. Ensure that GENERATED columns are updated when any columns they depend on are updated via a rule or an updatable view. Support hash partitioning with text array columns as partition keys. Allow the jsonpath .datetime() method to accept ISO 8601-format timestamps. During a "smart" shutdown, ensure background processes are not terminated until all foreground client sessions are completed, fixing an issue that broke the processing of parallel queries. Several fixes for the query planner and optimizer. Ensure that data is de-toasted before being inserted into a BRIN index. This could manifest itself with errors like "missing chunk number 0 for toast value NNN". If you have seen a similar error in an existing BRIN index, you should be able to correct it by using REINDEX on the index. Fix the output of EXPLAIN to have the correct XML tag nesting for incremental sort plans. Several fixes for memory leaks, including ones involving RLS policies, using CALL with PL/pgSQL, SIGHUP processing a configuration parameter that cannot be applied without a restart, and an edge-case for index lookup for a partition. libpq can now support arbitrary-length lines in the .pgpass file. On Windows, psql now reads the output of a backtick command in text mode, not binary mode, so it can now properly handle newlines. Fix how pg_dump, pg_restore, clusterdb, reindexdb, and vacuumdb use complex connection-string parameters. When the \connect command of psql reuses connection parameters, ensure that all non-overridden parameters from a previous connection string are also re-used. Ensure that pg_dump collects per-column information about extension configuration tables, avoiding crashes when specifying --inserts. Ensure that parallel pg_restore processes foreign keys referencing partitioned tables in the correct order. Several fixes for contrib/pgcrypto, including a memory leak fix.
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
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.
Pullup ticket #5434 - requested by sevan
databases/postgresql92: security fix
databases/postgresql93: security fix
databases/postgresql94: security fix
databases/postgresql95: security fix
databases/postgresql96: security fix
Revisions pulled up:
- databases/postgresql92-docs/PLIST 1.21
- databases/postgresql92-server/PLIST 1.13
- databases/postgresql92/Makefile.common 1.28
- databases/postgresql92/distinfo 1.23
- databases/postgresql93-docs/PLIST 1.18
- databases/postgresql93-server/PLIST 1.11
- databases/postgresql93/Makefile.common 1.24
- databases/postgresql93/distinfo 1.23
- databases/postgresql94-client/PLIST 1.3
- databases/postgresql94-docs/PLIST 1.13
- databases/postgresql94-server/PLIST 1.8
- databases/postgresql94/Makefile.common 1.16
- databases/postgresql94/distinfo 1.15
- databases/postgresql95-client/PLIST 1.4
- databases/postgresql95-docs/PLIST 1.7
- databases/postgresql95-server/PLIST 1.6
- databases/postgresql95/Makefile.common 1.9
- databases/postgresql95/distinfo 1.8
- databases/postgresql96-client/PLIST 1.2
- databases/postgresql96-docs/PLIST 1.3
- databases/postgresql96-server/PLIST 1.3
- databases/postgresql96/Makefile.common 1.3
- databases/postgresql96/distinfo 1.4
---
Module Name: pkgsrc
Committed By: adam
Date: Fri May 12 19:37:55 UTC 2017
Modified Files:
pkgsrc/databases/postgresql92: Makefile.common distinfo
pkgsrc/databases/postgresql92-docs: PLIST
pkgsrc/databases/postgresql92-server: PLIST
pkgsrc/databases/postgresql93: Makefile.common distinfo
pkgsrc/databases/postgresql93-docs: PLIST
pkgsrc/databases/postgresql93-server: PLIST
pkgsrc/databases/postgresql94: Makefile.common distinfo
pkgsrc/databases/postgresql94-client: PLIST
pkgsrc/databases/postgresql94-docs: PLIST
pkgsrc/databases/postgresql94-server: PLIST
pkgsrc/databases/postgresql95: Makefile.common distinfo
pkgsrc/databases/postgresql95-client: PLIST
pkgsrc/databases/postgresql95-docs: PLIST
pkgsrc/databases/postgresql95-server: PLIST
pkgsrc/databases/postgresql96: Makefile.common distinfo
pkgsrc/databases/postgresql96-client: PLIST
pkgsrc/databases/postgresql96-docs: PLIST
pkgsrc/databases/postgresql96-server: PLIST
Log Message:
The PostgreSQL Global Development Group has released an update to all
supported versions of our database system, including 9.6.3, 9.5.7,
9.4.12, 9.3.17, and 9.2.21. This release fixes three security
issues. It also patches a number of other bugs reported over the last
three months. Users who use the PGREQUIRESSL environment variable to
control connections, and users who rely on security
isolation between database users when using foreign servers, should
update as soon as possible. Other users should plan to update at the
next convenient downtime.
The PostgreSQL Global Development Group has released an update to all supported versions of our database system, including 9.6.3, 9.5.7, 9.4.12, 9.3.17, and 9.2.21. This release fixes three security issues. It also patches a number of other bugs reported over the last three months. Users who use the PGREQUIRESSL environment variable to control connections, and users who rely on security isolation between database users when using foreign servers, should update as soon as possible. Other users should plan to update at the next convenient downtime.
This release fixes a number of issues reported by users over the last two months. Most database administrators should plan to upgrade at the next available downtime, unless they have been affected directly by the fixed issues.
Pullup ticket #4964 - requested by sevan
databases/postgresql95: security fix
Revisions pulled up:
- databases/postgresql95-adminpack/Makefile 1.3
- databases/postgresql95-client/Makefile 1.3
- databases/postgresql95-client/PLIST 1.2
- databases/postgresql95-datatypes/Makefile 1.3
- databases/postgresql95-dblink/Makefile 1.3
- databases/postgresql95-docs/PLIST 1.2
- databases/postgresql95-fuzzystrmatch/Makefile 1.3
- databases/postgresql95-monitoring/Makefile 1.3
- databases/postgresql95-pgcrypto/Makefile 1.3
- databases/postgresql95-plperl/Makefile 1.3
- databases/postgresql95-plpython/Makefile 1.3
- databases/postgresql95-pltcl/Makefile 1.3
- databases/postgresql95-replicationtools/Makefile 1.3
- databases/postgresql95-server/Makefile 1.4
- databases/postgresql95-server/PLIST 1.2
- databases/postgresql95/Makefile 1.3
- databases/postgresql95/Makefile.common 1.2
- databases/postgresql95/distinfo 1.2
---
Module Name: pkgsrc
Committed By: adam
Date: Sat Apr 9 12:51:50 UTC 2016
Modified Files:
pkgsrc/databases/postgresql91: Makefile Makefile.common distinfo
pkgsrc/databases/postgresql91-adminpack: Makefile
pkgsrc/databases/postgresql91-client: Makefile
pkgsrc/databases/postgresql91-datatypes: Makefile
pkgsrc/databases/postgresql91-dblink: Makefile
pkgsrc/databases/postgresql91-docs: PLIST
pkgsrc/databases/postgresql91-fuzzystrmatch: Makefile
pkgsrc/databases/postgresql91-monitoring: Makefile
pkgsrc/databases/postgresql91-pgcrypto: Makefile
pkgsrc/databases/postgresql91-plperl: Makefile
pkgsrc/databases/postgresql91-plpython: Makefile
pkgsrc/databases/postgresql91-pltcl: Makefile
pkgsrc/databases/postgresql91-replicationtools: Makefile
pkgsrc/databases/postgresql91-server: Makefile PLIST
pkgsrc/databases/postgresql91-upgrade: Makefile
pkgsrc/databases/postgresql92: Makefile Makefile.common distinfo
pkgsrc/databases/postgresql92-adminpack: Makefile
pkgsrc/databases/postgresql92-client: Makefile
pkgsrc/databases/postgresql92-datatypes: Makefile
pkgsrc/databases/postgresql92-dblink: Makefile
pkgsrc/databases/postgresql92-docs: PLIST
pkgsrc/databases/postgresql92-fuzzystrmatch: Makefile
pkgsrc/databases/postgresql92-monitoring: Makefile
pkgsrc/databases/postgresql92-pgcrypto: Makefile
pkgsrc/databases/postgresql92-plperl: Makefile
pkgsrc/databases/postgresql92-plpython: Makefile
pkgsrc/databases/postgresql92-pltcl: Makefile
pkgsrc/databases/postgresql92-replicationtools: Makefile
pkgsrc/databases/postgresql92-server: Makefile PLIST
pkgsrc/databases/postgresql92-upgrade: Makefile
pkgsrc/databases/postgresql93: Makefile Makefile.common distinfo
pkgsrc/databases/postgresql93-adminpack: Makefile
pkgsrc/databases/postgresql93-client: Makefile
pkgsrc/databases/postgresql93-datatypes: Makefile
pkgsrc/databases/postgresql93-dblink: Makefile
pkgsrc/databases/postgresql93-docs: PLIST
pkgsrc/databases/postgresql93-fuzzystrmatch: Makefile
pkgsrc/databases/postgresql93-monitoring: Makefile
pkgsrc/databases/postgresql93-pgcrypto: Makefile
pkgsrc/databases/postgresql93-plperl: Makefile
pkgsrc/databases/postgresql93-plpython: Makefile
pkgsrc/databases/postgresql93-pltcl: Makefile
pkgsrc/databases/postgresql93-replicationtools: Makefile
pkgsrc/databases/postgresql93-server: Makefile PLIST
pkgsrc/databases/postgresql93-upgrade: Makefile
pkgsrc/databases/postgresql94: Makefile Makefile.common distinfo
pkgsrc/databases/postgresql94-adminpack: Makefile
pkgsrc/databases/postgresql94-client: Makefile
pkgsrc/databases/postgresql94-datatypes: Makefile
pkgsrc/databases/postgresql94-dblink: Makefile
pkgsrc/databases/postgresql94-docs: PLIST
pkgsrc/databases/postgresql94-fuzzystrmatch: Makefile
pkgsrc/databases/postgresql94-monitoring: Makefile
pkgsrc/databases/postgresql94-pgcrypto: Makefile
pkgsrc/databases/postgresql94-plperl: Makefile
pkgsrc/databases/postgresql94-plpython: Makefile
pkgsrc/databases/postgresql94-pltcl: Makefile
pkgsrc/databases/postgresql94-replicationtools: Makefile
pkgsrc/databases/postgresql94-server: Makefile PLIST
pkgsrc/databases/postgresql94-upgrade: Makefile
pkgsrc/databases/postgresql95: Makefile Makefile.common distinfo
pkgsrc/databases/postgresql95-adminpack: Makefile
pkgsrc/databases/postgresql95-client: Makefile PLIST
pkgsrc/databases/postgresql95-datatypes: Makefile
pkgsrc/databases/postgresql95-dblink: Makefile
pkgsrc/databases/postgresql95-docs: PLIST
pkgsrc/databases/postgresql95-fuzzystrmatch: Makefile
pkgsrc/databases/postgresql95-monitoring: Makefile
pkgsrc/databases/postgresql95-pgcrypto: Makefile
pkgsrc/databases/postgresql95-plperl: Makefile
pkgsrc/databases/postgresql95-plpython: Makefile
pkgsrc/databases/postgresql95-pltcl: Makefile
pkgsrc/databases/postgresql95-replicationtools: Makefile
pkgsrc/databases/postgresql95-server: Makefile PLIST
Log Message:
The PostgreSQL Global Development Group has released an update to all supported versions of our database system, including 9.5.2, 9.4.7, 9.3.12, 9.2.16, and 9.1.21. This release fixes two security
issues and one index corruption issue in version 9.5. It also contains a variety of bug fixes for earlier versions. Users of PostgreSQL 9.5.0 or 9.5.1 should update as soon as possible.
This release closes security hole CVE-2016-2193, where a query plan might get reused for more than one ROLE in the same session. This could cause the wrong set of Row Level Security (RLS) policies to
be used for the query.
The update also fixes CVE-2016-3065, a server crash bug triggered by using pageinspect with BRIN index pages. Since an attacker might be able to expose a few bytes of server memory, this crash is
being treated as a security issue.
The PostgreSQL Global Development Group has released an update to all supported versions of our database system, including 9.5.2, 9.4.7, 9.3.12, 9.2.16, and 9.1.21. This release fixes two security issues and one index corruption issue in version 9.5. It also contains a variety of bug fixes for earlier versions. Users of PostgreSQL 9.5.0 or 9.5.1 should update as soon as possible. This release closes security hole CVE-2016-2193, where a query plan might get reused for more than one ROLE in the same session. This could cause the wrong set of Row Level Security (RLS) policies to be used for the query. The update also fixes CVE-2016-3065, a server crash bug triggered by using pageinspect with BRIN index pages. Since an attacker might be able to expose a few bytes of server memory, this crash is being treated as a security issue.
Add postgresql95 packages, converted from corresponding postgresql94
packages. postgresql95-upgrade is gone, the pg_upgrade tool is shipped
with postgresql95-client now.
Major enhancements in PostgreSQL 9.5 include:
Allow INSERTs that would generate constraint conflicts to be turned into
UPDATEs or ignored
Add GROUP BY analysis features GROUPING SETS, CUBE and ROLLUP
Add row-level security control
Create mechanisms for tracking the progress of replication, including
methods for identifying the origin of individual changes during logical
replication
Add Block Range Indexes (BRIN)
Substantial performance improvements for sorting
Substantial performance improvements for multi-CPU machines