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: commit: 3a465cc6783f586096d9f885c3fc544d82eb8f19 author: Michael Paquier <michael@paquier.xyz> date: Tue, 14 Mar 2023 14:00:05 +0900 libpq: Add support for require_auth to control authorized auth methods The new connection parameter require_auth allows a libpq client to define a list of comma-separated acceptable authent...| Michael Paquier - PostgreSQL committer
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: <SCRAM mechanisms>$<iterations>:<salt>$<stored key>:<server key> For all the details regarding that, feel free to look at the RFCs quoted above. When it comes to SCRAM-SHA-256 in PostgreSQL, the mechanism...| Michael Paquier - PostgreSQL committer
This post begins with this commit added to Postgres 16: commit: daa8365a900729fe2a8d427fbeff19e763e35723 author: Michael Paquier <michael@paquier.xyz> date: Wed, 8 Mar 2023 15:00:50 +0900 Reflect normalization of query strings for utilities in pg_stat_statements Applying normalization changes how the following query strings are reflected in pg_stat_statements, by showing Const nodes with a dollar-signed parameter as this is how such queries are structured internally once parsed: - DECLARE - E...| Michael Paquier - PostgreSQL committer
27.2. The Cumulative Statistics System # 27.2.1. Statistics Collection Configuration 27.2.2. Viewing Statistics 27.2.3. pg_stat_activity 27.2.4. pg_stat_replication 27.2.5. pg_stat_replication_slots 27.2.6. pg_stat_wal_receiver …| PostgreSQL Documentation
Unicode® Technical Standard #10| unicode.org
We continue to follow the news of the PostgreSQL 16 release, and today, the results of the fourth CommitFest are on the table. Let’s have a look. If you missed the previous CommitFests, check out our reviews for 2022-07 , 2022-09 and 2022-11 . Here are the patches I want to talk about this time: New function: random_normal Input formats for integer literals Goodbye, postmaster Parallel execution for string_agg and array_agg New parameter: enable_presorted_aggregate Planner support function ...| postgrespro.com
We continue to follow the news of the upcoming PostgreSQL 16. The third CommitFest concluded in early December. Let's look at the results. If you missed the previous CommitFests, check out our reviews: 2022-07 , 2022-09 . Here are the patches I want to talk about: meson: a new source code build system Documentation: a new chapter on transaction processing psql: \d+ indicates foreign partitions in a partitioned table psql: extended query protocol support Predicate locks on materialized views T...| postgrespro.com
It’s official! PostgreSQL 15 is out, and the community is abuzz discussing all the new features of the fresh release. Meanwhile, the October CommitFest for PostgreSQL 16 had come and gone, with its own notable additions to the code. If you missed the July CommitFest, our previous article will get you up to speed in no time. Here are the patches I want to talk about: SYSTEM_USER function Frozen pages/tuples information in autovacuum's server log pg_stat_get_backend_idset returns the actual b...| postgrespro.com
August is a special month in PostgreSQL release cycle. PostgreSQL 15 isn't even officially out yet, but the first CommitFest for the 16th release has already been held. Let's compile the server and check out the cool new stuff!| postgrespro.com
We talk about querying system wide I/O statistics in Postgres, show several use cases for pg_stat_io, and talk about the future of I/O observability in Postgres.| pganalyze