Release notes

This are the release notes for 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.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