Appendix
Default aliases
c
Clear console
cda
Changes directory to ${PGBASE}/admin/${PGDATABASE}
cdal
Changes directory to pg_log directory
cdb
Changes directory to ${PGBASE}
cdd
Changes directory to ${DMK_BASE}
cddi
Changes directory to ${DMK_DIAG_DEST}
cdh
Changes directory to ${PGHOME}
cdl
Changes directory to ${PGBASE}/local
cdt
Changes directory to ${DMK_PG_ADMIN_DATABASE}/conf
dmkhelp
Displays all default aliases/variables categorized by the DMK package you are looking for. The help is available for all packages.
f
Executes fdisk.ksh
lsdb
Lists all databases for the current environments
lsexts
Lists all extension for the current environments
lstlbspc
Lists all tablespaces for the current environments
lsrole
Lists all roles/users for the current environments
sqh
psql with history
sq
psql without history
sta/ser/u
Print PostgreSQL components status:
“sta” by status
“ser” by service
“u” a faster variant of “ser”
(no differentiation between the database states OPEN/MOUNT/NOMOUNT)
taa/via
Tail/Edit the server log
vid
Edit the ${DMK_HOME}/etc/dmk.conf
vil
Edit the ${DMK_PG_ADMIN_DATABASE}/conf/pg_hba.conf
vio
Edit the PGTAB
Other aliases are created automatically for directories under the “${DMK_BASE}”.
Default variables
DMK_BASE
Match the directory level above “${DMK_HOME}”
Match typically the “${PG_BASE}/local”
DMK_HOME
Installation directory
PGBASE
P.F.A , Software root directory
DMK_PG_ADMIN
Match the directory “${PGBASE}/admin”
DMK_PG_ADMIN_DATABASE
Match the directory “${PGBASE }/admin/${PGDATABASE}”
Other variables are created automatically for directories under the “${DMK_BASE}”.
Support Matrix
Oracle Enterprise Linux
Certified
7.+
Red Hat Enterprise Linux
Certified
7.+
CentOS
Certified
7.x
SUSE Enterprise Linux
Certified
12.+
openSUSE
Certified
15.+
Ubuntu
Certified
18.+
Debian
Certified
9.+
FreeBSD
Certified
10.+
Rocky Linux
Certified
8.+
Alma Linux
Certified
8.+
Please contact the Support Team if your version is not available in the above matrix.
Last updated