Release notes

Release notes

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 buikd 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

Last updated