Publishing details
Changelog
postgresql-9.5 (9.5.24-0ubuntu0.16.04.1) xenial-security; urgency=medium
* New upstream version.
+ Block DECLARE CURSOR ... WITH HOLD and firing of deferred triggers
within index expressions and materialized view queries (Noah Misch)
This is essentially a leak in the security restricted operation sandbox
mechanism. An attacker having permission to create non-temporary SQL
objects could parlay this leak to execute arbitrary SQL code as a
superuser.
The PostgreSQL Project thanks Etienne Stalmans for reporting this
problem. (CVE-2020-25695)
+ Fix usage of complex connection-string parameters in pg_dump,
pg_restore, clusterdb, reindexdb, and vacuumdb (Tom Lane)
The -d parameter of pg_dump and pg_restore, or the --maintenance-db
parameter of the other programs mentioned, can be a connection string
containing multiple connection parameters rather than just a database
name. In cases where these programs need to initiate additional
connections, such as parallel processing or processing of multiple
databases, the connection string was forgotten and just the basic
connection parameters (database name, host, port, and username) were
used for the additional connections. This could lead to connection
failures if the connection string included any other essential
information, such as non-default SSL or GSS parameters. Worse, the
connection might succeed but not be encrypted as intended, or be
vulnerable to man-in-the-middle attacks that the intended connection
parameters would have prevented. (CVE-2020-25694)
+ When psql's \connect command re-uses connection parameters, ensure that
all non-overridden parameters from a previous connection string are
re-used (Tom Lane)
This avoids cases where reconnection might fail due to omission of
relevant parameters, such as non-default SSL or GSS options. Worse, the
reconnection might succeed but not be encrypted as intended, or be
vulnerable to man-in-the-middle attacks that the intended connection
parameters would have prevented. This is largely the same problem as
just cited for pg_dump et al, although psql's behavior is more complex
since the user may intentionally override some connection parameters.
(CVE-2020-25694)
+ Prevent psql's \gset command from modifying specially-treated variables
(Noah Misch)
\gset without a prefix would overwrite whatever variables the server
told it to. Thus, a compromised server could set specially-treated
variables such as PROMPT1, giving the ability to execute arbitrary shell
code in the user's session.
The PostgreSQL Project thanks Nick Cleaton for reporting this problem.
(CVE-2020-25696)
+ Details about these and many further changes can be found at:
https://www.postgresql.org/docs/9.5/static/release-9-5-24.html
-- Christian Ehrhardt <email address hidden> Thu, 12 Nov 2020 12:13:20 +0100
Builds
Built packages
-
libecpg-compat3
older version of run-time library for ECPG programs
-
libecpg-compat3-dbgsym
debug symbols for package libecpg-compat3
-
libecpg-dev
development files for ECPG (Embedded PostgreSQL for C)
-
libecpg-dev-dbgsym
debug symbols for package libecpg-dev
-
libecpg6
run-time library for ECPG programs
-
libecpg6-dbgsym
debug symbols for package libecpg6
-
libpgtypes3
shared library libpgtypes for PostgreSQL 9.5
-
libpgtypes3-dbgsym
debug symbols for package libpgtypes3
-
libpq-dev
header files for libpq5 (PostgreSQL library)
-
libpq-dev-dbgsym
debug symbols for package libpq-dev
-
libpq5
PostgreSQL C client library
-
libpq5-dbgsym
debug symbols for package libpq5
-
postgresql-9.5
object-relational SQL database, version 9.5 server
-
postgresql-9.5-dbg
debug symbols for postgresql-9.5
-
postgresql-9.5-dbgsym
debug symbols for package postgresql-9.5
-
postgresql-client-9.5
front-end programs for PostgreSQL 9.5
-
postgresql-client-9.5-dbgsym
debug symbols for package postgresql-client-9.5
-
postgresql-contrib-9.5
additional facilities for PostgreSQL
-
postgresql-contrib-9.5-dbgsym
debug symbols for package postgresql-contrib-9.5
-
postgresql-doc-9.5
documentation for the PostgreSQL database management system
-
postgresql-plperl-9.5
PL/Perl procedural language for PostgreSQL 9.5
-
postgresql-plperl-9.5-dbgsym
debug symbols for package postgresql-plperl-9.5
-
postgresql-plpython-9.5
PL/Python procedural language for PostgreSQL 9.5
-
postgresql-plpython-9.5-dbgsym
debug symbols for package postgresql-plpython-9.5
-
postgresql-plpython3-9.5
PL/Python 3 procedural language for PostgreSQL 9.5
-
postgresql-plpython3-9.5-dbgsym
debug symbols for package postgresql-plpython3-9.5
-
postgresql-pltcl-9.5
PL/Tcl procedural language for PostgreSQL 9.5
-
postgresql-pltcl-9.5-dbgsym
debug symbols for package postgresql-pltcl-9.5
-
postgresql-server-dev-9.5
development files for PostgreSQL 9.5 server-side programming
-
postgresql-server-dev-9.5-dbgsym
debug symbols for package postgresql-server-dev-9.5
Package files