PostgreSQL 16 includes a set of features related to JSON to make the engine more compliant with the SQL standard. One of these features has been introduced by the following commit:

PostgreSQL lightweight-lock manager, with its interface in src/include/storage/lwlock.h, is a facility aimed at controlling the access to shared memory data structures. One set of routines is at the center of this post:

A feature has been committed in Postgres 16 for libpq to bring more filtering capabilities over the authentication methods authorized on a new connection. Here is the commit:

The SCRAM-SHA-256 authentication protocol, defined by RFC 7677 and available since PostgreSQL 10, uses SCRAM secrets. There are used during authentication as equivalents of passwords and stored in pg_authid, shaped based on RFC 5803 for LDAP. This format can be described as a string made of:

The third and last phase of the improvements done in PostgreSQL 16 for authentication configuration involves both pg_hba.conf and pg_ident.conf, mainly with this commit: