Release notes

Release notes

DMK for PostgreSQL 2.5.0

New features

• The CIS script is now written in Go (it was written in Python in previous releases)

• Added pgHero exmaple ( this can be found here: containers/pghero/ )

Updated templates

• Switch the Patroni and ETCD templates to use SSL by default

• Added a new template to create a self signe CA and the certificates ( ssl_cert_gen.txt )

• Updated the pgBackRest commands template to include examples for "restore" operations

• Updated the Prometheus and Grafane template to the latest version and fixed some commands

• Updated the PostGIS installation template for RHEL9

• Set jit=off in the postgresql.auto.conf template

New SQL scripts

• Added a script to describe a page/block: get_page_descipription.sql

DMK for PostgreSQL 2.4.0

New features

• Add a script to list the SWAP usage per process (swap_usage.sh)

• Add a script to list tables which are close to wraparound (how_tables_close_to_wraparound.sql)

• Add a script which loads the PostgreSQL log file into a table (create_and_load_log_tables.sql)

• Add a script to set the SELinux context (set_selinux_context.sh)

Updated templates

• Adapt package list for SLES / openSUSE 16

• Adapt package list for RHEL 10

• Add an example for ldap authentication (ldap.txt)

• Add allowlist to Patroni template

• Add new Patroni 4.1.0 parameters to the template

• Add missing packages for Debian 13

• Remove wal_keep_segments from postgresql.auto.conf and patroni.yml

• Aligned patroni.yml and postgresql.auto.conf

DMK for PostgreSQL 2.3.0

New features

Updated templates

• The tuning profile comes with new and adjusted parameters

• The package list for SLES15 based systems has been updated

• The package list for the upcoming Debian 13 has been added

• The ectd template now comes with instructions how to handle proxied environments

• The ectd template comes with adjusted compaction parameters to handle larger etcd databases by default

• Update the PostGIS build instructions with the latest minor releases

• Enable new features for PostgreSQL 18: io_uring, oauth and NUMA

• Move the autoconf way of building PostgreSQL into a separate template

• Extend the postgresql.auto.conf template: Enable io_uring, set io_combine_limit, set min_dynamic_shared_memory

DMK for PostgreSQL 2.2.x

The 2.2.0 release was an internal maintenance release due to changes in the build pipelines.

DMK for PostgreSQL 2.1.x

# New features

# Give more control how to display the instance overview

Traditionaly the instance overview looks like this:

 PostgreSQL Clusters up and running on this host: 
 ---------------------------------------------------------------------------------------------- 
    pgdev       ->  /u02/pgdata/PGDEV                                        ->  5432  ==> OPEN     
 
 PostgreSQL Clusters NOT running on this host: 
 ---------------------------------------------------------------------------------------------- 
    pg94        ->  /u02/pgdata/94                                           ->  3998  ==> CLOSED       
    pg95        ->  /u02/pgdata/95                                           ->  3999  ==> CLOSED       
    pg96        ->  /u02/pgdata/96                                           ->  4000  ==> CLOSED       
    pg10        ->  /u02/pgdata/10                                           ->  4001  ==> CLOSED       
    pg11        ->  /u02/pgdata/11                                           ->  4002  ==> CLOSED       
    pg12        ->  /u02/pgdata/12                                           ->  4003  ==> CLOSED       
    pg13        ->  /u02/pgdata/13                                           ->  4004  ==> CLOSED       
    pg14        ->  /u02/pgdata/14                                           ->  4005  ==> CLOSED       
    pg15        ->  /u02/pgdata/15                                           ->  4006  ==> CLOSED       
    pg16        ->  /u02/pgdata/16                                           ->  4007  ==> CLOSED  

With the release of DMK for PostgreSQL 2.1.0 the user has more control about how to display this overview. There are two additional switches to "dmk-run-pl" which is behind the "u" and "ser" aliases:

postgres@pgbox:/home/postgres/ [pgxxx] alias u
alias u='dmk-run.pl'
postgres@pgbox:/home/postgres/ [pgxxx] alias ser
alias ser='dmk-run.pl -l y'

1. Display the PostgreSQL installation binary path, instead of PGDATA:

postgres@pgbox:/home/postgres/ [pgxxx] dmk-run.pl -d PGBIN


 PostgreSQL Clusters up and running on this host: 
 ---------------------------------------------------------------------------------------------- 
    pgdev       ->  /u01/app/postgres/product/DEV/db_0/                      ->  5432  ==> OPEN     
 
 PostgreSQL Clusters NOT running on this host: 
 ---------------------------------------------------------------------------------------------- 
    pg94        ->  /u01/app/postgres/product/9.4/db_26                      ->  3998  ==> CLOSED       
    pg95        ->  /u01/app/postgres/product/9.5/db_25                      ->  3999  ==> CLOSED       
    pg96        ->  /u01/app/postgres/product/9.6/db_24                      ->  4000  ==> CLOSED       
    pg10        ->  /u01/app/postgres/product/10/db_23                       ->  4001  ==> CLOSED       
    pg11        ->  /u01/app/postgres/product/11/db_22                       ->  4002  ==> CLOSED       
    pg12        ->  /u01/app/postgres/product/12/db_18                       ->  4003  ==> CLOSED       
    pg13        ->  /u01/app/postgres/product/13/db_14                       ->  4004  ==> CLOSED       
    pg14        ->  /u01/app/postgres/product/14/db_11                       ->  4005  ==> CLOSED       
    pg15        ->  /u01/app/postgres/product/15/db_6                        ->  4006  ==> CLOSED       
    pg16        ->  /u01/app/postgres/product/16/db_2                        ->  4007  ==> CLOSED    

1. Display a cluster's startup time

postgres@pgbox:/home/postgres/ [pgxxx] dmk-run.pl -s y


 PostgreSQL Clusters up and running on this host: 
 ---------------------------------------------------------------------------------------------- 
    pgdev       ->  /u02/pgdata/PGDEV                                        ->  5432  ==> OPEN     
                     Startup Time: 13-MAY-2024 07:46:49                                             
 
 PostgreSQL Clusters NOT running on this host: 
 ---------------------------------------------------------------------------------------------- 
    pg94        ->  /u02/pgdata/94                                           ->  3998  ==> CLOSED       
    pg95        ->  /u02/pgdata/95                                           ->  3999  ==> CLOSED       
    pg96        ->  /u02/pgdata/96                                           ->  4000  ==> CLOSED       
    pg10        ->  /u02/pgdata/10                                           ->  4001  ==> CLOSED       
    pg11        ->  /u02/pgdata/11                                           ->  4002  ==> CLOSED       
    pg12        ->  /u02/pgdata/12                                           ->  4003  ==> CLOSED       
    pg13        ->  /u02/pgdata/13                                           ->  4004  ==> CLOSED       
    pg14        ->  /u02/pgdata/14                                           ->  4005  ==> CLOSED       
    pg15        ->  /u02/pgdata/15                                           ->  4006  ==> CLOSED       
    pg16        ->  /u02/pgdata/16                                           ->  4007  ==> CLOSED       

Fixes

Release 2.1.3

• Add build instructions for Meson

• Add SSL related parameters to our Patroni template

• Add Meson and Ninja to the package lists

Release 2.1.2

• Update the documentation and release notes

Release 2.1.1

• Ensure that the environment variable PGBASE is set before PATH

• Ensure that PGBASE is also set when an PostgreSQL alias is set