DMK PostgreSQL - Manual
Release_2.1
Release_2.1
  • Introduction
  • Release notes
  • βš™οΈInstallation and configuration
    • Installation & Upgrade & De-Installation
    • Functionalities & Features
    • β€œAdvanced” Configuration
  • πŸ“‘Architecture
    • Structure
    • Scripts
    • Appendix
  • πŸ—ƒοΈPOFA
    • Introduction
    • PFA Naming guidelines
    • PFA directory structure
Powered by GitBook
On this page
  • Default aliases
  • Default variables
  • Support Matrix
  1. Architecture

Appendix

Default aliases

Name
Description

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

Name
Description

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

Operating System
Support Level
PostgreSQL Releases

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.

PreviousScriptsNextIntroduction

Last updated 12 months ago

πŸ“‘