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