Featured content is also available via:

PostgreSQL

PostgeSQL is a leading open-source SQL database server.

www.postgresql.org

Yesterday's Activity

Flush table's relcache during ALTER TABLE ADD PRIMARY KEY USING INDEX.
Tom Lane: Previously, unless we had to add a NOT NULL constraint to the column, this command resulted in updating only the index's relcache entry.

Other Activity This Week

Extend the options of pg_basebackup to control compression
Michael Paquier: The option --compress is extended to accept a compression method and an optional compression level, as of the grammar METHOD[:LEVEL].

Don't enable fsync in src/test/recovery/t/008_fsm_truncation.pl
Tom Lane: In adverse circumstances, the fsync calls cause this test to run for quite a long time (multiple minutes) and even suffer timeout failures.

Modify pg_basebackup to use a new COPY subprotocol for base backups
Robert Haas: In the new approach, all files across all tablespaces are sent in a single COPY OUT operation.

Replace use of deprecated Python module distutils.sysconfig
Peter Eisentraut: With Python 3.10, configure spits out warnings about the module distutils.sysconfig being deprecated and scheduled for removal in Python 3.12.

pg_upgrade: Preserve relfilenodes and tablespace OIDs
Robert Haas: Currently, database OIDs, relfilenodes, and tablespace OIDs can all change when a cluster is upgraded using pg_upgrade.

Add Boolean node
Peter Eisentraut: Before, SQL-level boolean constants were represented by a string with a cast, and internal Boolean values in DDL commands were usually represented by Integer nodes.

Add support for --no-table-access-method in pg_{dump,dumpall,restore}
Michael Paquier: The logic is similar to default_tablespace in some ways, so as no SET queries on default_table_access_method are generated before dumping or restoring an object (table or materialized view support table AMs) when specifying this new option.

Introduce log_destination=jsonlog
Michael Paquier: "jsonlog" is a new value that can be added to log_destination to provide logs in the JSON format, with its output written to a file, making it the third type of destination of this kind, after "stderr" and "csvlog".

PostgreSQL Release Tags

Require version 0.98 of Test::More for TAP tests
Andrew Dunstan: This means that the subtest feature will be available for use. We expect that this change will make prairiedog go red until it is updated, but other buildfarm animals should be fine. Discussion:

doc: Fix link reference for PGSSLMAXPROTOCOLVERSION
Michael Paquier: The link was pointing to the minimum protocol version.

nbtree: BTREE_[MIN|NOVAC]_VERSION comment tweaks
Peter Geoghegan: Author: Peter Geoghegan

Automate the maintenance of SO_MINOR_VERSION for our shared libraries
Tom Lane: Up to now we've manually adjusted these numbers in several different Makefiles at the start of each development cycle.

Advance PG_CONTROL_VERSION.
Tom Lane: This should have been done in commit 73c986adde5d73a5 which added several new fields to pg_control, and again in commit 5028f22f6eb05798 which changed the CRC algorithm, but it wasn't.

Tab complete CREATE EXTENSION .. VERSION.
Robert Haas: Jeff Janes

Bump PG_CONTROL_VERSION for previous 9.4 changes
Tom Lane: This should have been done in 6bc8ef0b7f1f1df3998745a66e1790e27424aa0c and/or 50e547096c4858a68abf09894667a542cc418315, but better late than never.

Most Popular In The Past Month

postgres_fdw: Allow postgres_fdw.application_name to include escape sequences
Fujii Masao: application_name that used when postgres_fdw establishes a connection to a foreign server can be specified in either or both a connection parameter of a server object and GUC postgres_fdw.application_name.

ci: Add continuous integration for github repositories via cirrus-ci
Andres Freund: Currently FreeBSD, Linux, macOS and Windows (Visual Studio) are tested. The main goal of this integration is to make it easier to test in-development patches across multiple platforms.

Improve error handling of cryptohash computations
Michael Paquier: The existing cryptohash facility was causing problems in some code paths related to MD5 (frontend and backend) that relied on the fact that the only type of error that could happen would be an OOM, as the MD5 implementation used in PostgreSQL ~13 (the in-core implementation is used when compiling with or without OpenSSL in those older versions), could fail only under this circumstance. The new cryptohash facilities can fail for reasons other than OOMs, like attempting MD5 when FIPS is enabled (upstream OpenSSL allows that up to 1.0.2, Fedora and Photon patch OpenSSL 1.1.1 to allow that), so this would cause incorrect reports to show up. This commit extends the cryptohash APIs so as callers of those routines can fetch more context when an error happens, by using a new routine called pg_cryptohash_error().

Add Boolean node
Peter Eisentraut: Before, SQL-level boolean constants were represented by a string with a cast, and internal Boolean values in DDL commands were usually represented by Integer nodes.

Add stxdinherit flag to pg_statistic_ext_data
Tomas Vondra: Add pg_statistic_ext_data.stxdinherit flag, so that for each extended statistics definition we can store two versions of data - one for the relation alone, one for the whole inheritance tree.

Add tab-completion for CREATE FOREIGN TABLE.
Fujii Masao: Unlike CREATE TABLE, CREATE FOREIGN TABLE is not allowed inside CREATE SCHEMA, so Matches() is used instead of TailMatches() for the tab-completion.

Modify pg_basebackup to use a new COPY subprotocol for base backups
Robert Haas: In the new approach, all files across all tablespaces are sent in a single COPY OUT operation.

Improve error handling of HMAC computations
Michael Paquier: This is similar to b69aba7, except that this completes the work for HMAC with a new routine called pg_hmac_error() that would provide more context about the type of error that happened during a HMAC computation:- The fallback HMAC implementation in hmac.c relies on cryptohashes, so in some code paths it is necessary to return back the error generated by cryptohashes.- For the OpenSSL implementation (hmac_openssl.c), the logic is very similar to cryptohash_openssl.c, where the error context comes from OpenSSL if one of its internal routines failed, with different error codes if something internal to hmac_openssl.c failed or was incorrect. Any in-core code paths that use the centralized HMAC interface are related to SCRAM, for errors that are unlikely going to happen, with only SHA-256.

Create foreign key triggers in partitioned tables too
Alvaro Herrera: While user-defined triggers defined on a partitioned table have a catalog definition for both it and its partitions, internal triggers used by foreign keys defined on partitioned tables only have a catalog definition for its partitions.

Enable routine running of regex.linux.utf8 regression test
Tom Lane: Up to now this has just sat there as a test you could invoke via EXTRA_TESTS, which of course nobody does.

Legal Disclaimer & Disclosure | Contact Us
Copyright © 2010 - 2022 by Phoronix Media. All rights reserved.
All trademarks and copyrights used are properties of their respective owners.
Powered by the Phoronix Content Management System (PHXCMS-8).