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