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:
Read more...2023-05-07 07:52:22 +0000
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:
Read more...2023-04-20 03:59:22 +0000
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:
Read more...2023-04-13 03:30:15 +0000
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:
Read more...2023-04-05 05:15:15 +0000
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:
Read more...2023-03-29 03:35:15 +0000
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:
Read more...Unless otherwise specified, the contents of this website are (C)Copyright Michael Paquier 2010-2025 and are licensed for use under CC BY-NC-ND 4.0.