On 7th of March 2017, Heikki Linnakangas committed patch: Support SCRAM-SHA-256 authentication (RFC 5802 and 7677). This introduces a new generic SASL authentication method, similar to the GSS and SSPI methods. The server first tells the client which SASL authentication mechanism to use, and ...

On 15th of May, Peter Eisentraut committed patch: Add pg_settings.pending_restart column with input from David G. Johnston, Robert Haas, Michael Paquier

On 2nd of September, Fujii Masao committed patch: Support ALTER SYSTEM RESET command. This patch allows us to execute ALTER SYSTEM RESET command to remove the configuration entry from postgresql.auto.conf. Vik Fearing, reviewed by Amit Kapila and me.

On 29th of June, Andres Freund committed patch: Add cluster_name GUC which is included in process titles if set. When running several postgres clusters on one OS instance it's often inconveniently hard to identify which "postgres" process belongs to which postgres instance. Add the cluster_name ...

On 18th of December, Tatsuo Ishii committed patch: Add ALTER SYSTEM command to edit the server configuration file. Patch contributed by Amit Kapila. Reviewed by Hari Babu, Masao Fujii, Boszormenyi Zoltan, Andres Freund, Greg Smith and others. On the next day, Fujii Masao committed ...

While there are some docs on it, I decided to write about it, in perhaps more accessible language - not as a developer, but as PostgreSQL user. Some parts (quite large parts) were described in one of my earlier posts, but ...

For todays post in Understanding postgresql.conf series, I chose work_mem parameter.

Starting new blog series - explanation of various configuration parameters. I will of course follow no schedule or order - if I'd had to - it would be my job, and in this way - it's fun. First configuration parameter to write ...

On 28th of November Tom Lane committed patch by Dave Page, which adds new capability to system monitoring and logging: Log Message: ----------- Add support for an application_name parameter, which is displayed in pg_stat_activity and recorded in log entries.   Dave Page, reviewed by Andres Freund

On 7th of October Alvaro Herrera committed his own patch, which adds quite interesting possibilty: Log Message: ----------- Make it possibly to specify GUC params per user and per database.   Create a new catalog pg_db_role_setting where they are now stored, and better encapsulate the code ...