openGauss每日一练第 1 天

S: 在2022年12月6日发现“21天养成好习惯| 第二届openGauss每日一练活动”。

T:

• 从操作系统层面查看数据库进程和线程,判断数据库是否启动    
• 使用gs_ctl工具查看数据库状态,判断数据库是否启动
  
• 使用gs_ctl 查看数据文件的目录
  
• 从环境变量查看数据文件的目录
  
• 在gsql中查看数据文件目录、数据库版本
  

// 查询gauss进程信息
ps -ef | grep gaussomm          1     0  0 14:44 ?        00:00:15 gaussdb
omm        652   648  0 15:43 pts/0    00:00:00 grep gauss
// 查询gauss线程信息
ps -Tp 1PID  SPID PSR TTY      STAT   TIME COMMAND
    1     1   6 ?        Ssl    0:00 gaussdb
    1   293   5 ?        Ssl    0:00 gaussdb
    1   299   7 ?        Ssl    0:00 gaussdb
    1   300   5 ?        Ssl    0:00 gaussdb
    1   302   4 ?        Ssl    0:00 gaussdb
    1   301   3 ?        Ssl    0:00 gaussdb
    1   303  10 ?        Ssl    0:00 gaussdb
    1   304   9 ?        Ssl    0:00 gaussdb
    1   305  10 ?        Ssl    0:00 gaussdb
    1   349   9 ?        Ssl    0:00 gaussdb
    1   350   3 ?        Ssl    0:00 gaussdb
    1   351  10 ?        Ssl    0:02 gaussdb
    1   352   0 ?        Ssl    0:00 gaussdb
    1   353   9 ?        Ssl    0:00 gaussdb
    1   354   7 ?        Ssl    0:00 gaussdb
    1   355   4 ?        Ssl    0:00 gaussdb
    1   356   2 ?        Ssl    0:00 gaussdb
    1   357   0 ?        Ssl    0:00 gaussdb
    1   358   5 ?        Ssl    0:00 gaussdb
    1   359   4 ?        Ssl    0:00 gaussdb
    1   360   4 ?        Ssl    0:00 gaussdb
    1   361   6 ?        Ssl    0:00 gaussdb
    1   362   6 ?        Ssl    0:00 gaussdb
    1   363   3 ?        Ssl    0:00 gaussdb
    1   364   9 ?        Ssl    0:02 gaussdb
    1   365   8 ?        Ssl    0:07 gaussdb
    1   366   7 ?        Ssl    0:01 gaussdb
    1   367   4 ?        Ssl    0:00 gaussdb
    1   368   4 ?        Ssl    0:00 gaussdb
    1   369   8 ?        Ssl    0:00 gaussdb
    1   370   6 ?        Ssl    0:00 gaussdb
    1   371  10 ?        Ssl    0:00 gaussdb
    1   372   8 ?        Ssl    0:00 gaussdb
    1   373  10 ?        Ssl    0:00 gaussdb

2、通过gs_ctl status查询openGauss数据库的状态

omm@modb:~$ gs_ctl status
[2022-12-06 15:52:53.413][706][][gs_ctl]: gs_ctl status,datadir is /var/lib/opengauss/data 
gs_ctl: server is running (PID: 1)
/usr/local/opengauss/bin/gaussdb

3、通过gs_ctl notify查询数据文件目录或者

[2022-12-06 16:00:37.503][743][][gs_ctl]: gs_ctl notify ,datadir is /var/lib/opengauss/data 
[2022-12-06 16:00:37.503][743][][gs_ctl]: the parameter of notify must be specified

4 、通过grep -i PGDATA ~/.bashr    c从环境变量查询数据文件目录

omm@modb:~$ cat ~/.bashrc 
# ~/.bashrc: executed by bash(1) for non-login shells.
# see /usr/share/doc/bash/examples/startup-files (in the package bash-doc)
# for examples

# If not running interactively, don't do anything
case $- in
    *i*) ;;
      *) return;;
esac

# don't put duplicate lines or lines starting with space in the history.
# See bash(1) for more options
HISTCONTROL=ignoreboth

# append to the history file, don't overwrite it
shopt -s histappend

# for setting history length see HISTSIZE and HISTFILESIZE in bash(1)
HISTSIZE=1000
HISTFILESIZE=2000

# check the window size after each command and, if necessary,
# update the values of LINES and COLUMNS.
shopt -s checkwinsize

# If set, the pattern "**" used in a pathname expansion context will
# match all files and zero or more directories and subdirectories.
#shopt -s globstar

# make less more friendly for non-text input files, see lesspipe(1)
#[ -x /usr/bin/lesspipe ] && eval "$(SHELL=/bin/sh lesspipe)"

# set variable identifying the chroot you work in (used in the prompt below)
if [ -z "${debian_chroot:-}" ] && [ -r /etc/debian_chroot ]; then
    debian_chroot=$(cat /etc/debian_chroot)
fi

# set a fancy prompt (non-color, unless we know we "want" color)
case "$TERM" in
    xterm-color|*-256color) color_prompt=yes;;
esac

# uncomment for a colored prompt, if the terminal has the capability; turned
# off by default to not distract the user: the focus in a terminal window
# should be on the output of commands, not on the prompt
#force_color_prompt=yes

if [ -n "$force_color_prompt" ]; then
    if [ -x /usr/bin/tput ] && tput setaf 1 >&/dev/null; then
        # We have color support; assume it's compliant with Ecma-48
        # (ISO/IEC-6429). (Lack of such support is extremely rare, and such
        # a case would tend to support setf rather than setaf.)
        color_prompt=yes
    else
        color_prompt=
    fi
fi

if [ "$color_prompt" = yes ]; then
    PS1='${debian_chroot:+($debian_chroot)}\[\033[01;32m\]\u@\h\[\033[00m\]:\[\033[01;34m\]\w\[\033[00m\]\$ '
else
    PS1='${debian_chroot:+($debian_chroot)
# some more ls aliases
#alias ll='ls -l'
#alias la='ls -A'
#alias l='ls -CF'

# Alias definitions.
# You may want to put all your additions into a separate file like
# ~/.bash_aliases, instead of adding them here directly.
# See /usr/share/doc/bash-doc/examples in the bash-doc package.

if [ -f ~/.bash_aliases ]; then
    . ~/.bash_aliases
fi

# enable programmable completion features (you don't need to enable
# this, if it's already enabled in /etc/bash.bashrc and /etc/profile}\u@\h:\w\$ '
fi
unset color_prompt force_color_prompt

# If this is an xterm set the title to user@host:dir
case "$TERM" in
xterm*|rxvt*)
    PS1="\[\e]0;${debian_chroot:+($debian_chroot)}\u@\h: \w\a\]$PS1"
    ;;
*)
    ;;
esac

# enable color support of ls and also add handy aliases
if [ -x /usr/bin/dircolors ]; then
    test -r ~/.dircolors && eval "$(dircolors -b ~/.dircolors)" || eval "$(dircolors -b)"
    alias ls='ls --color=auto'
    #alias dir='dir --color=auto'
    #alias vdir='vdir --color=auto'

    #alias grep='grep --color=auto'
    #alias fgrep='fgrep --color=auto'
    #alias egrep='egrep --color=auto'
fi

# colored GCC warnings and errors
#export GCC_COLORS='error=01;31:warning=01;35:note=01;36:caret=01;32:locus=01:quote=01'

# sources /etc/bash.bashrc).
if ! shopt -oq posix; then
  if [ -f /usr/share/bash-completion/bash_completion ]; then
    . /usr/share/bash-completion/bash_completion
  elif [ -f /etc/bash_completion ]; then
    . /etc/bash_completion
  fi
fi
export GAUSSHOME=/usr/local/opengauss
export PATH=$GAUSSHOME/bin:$PATH 
export LD_LIBRARY_PATH=$GAUSSHOME/lib:$LD_LIBRARY_PATH
export PGDATA=/var/lib/opengauss/data

# 通过grep -i PGDATA ~/.bashrc 从环境变量查询数据库目录
omm@modb:~$ grep -i PGDATA ~/.bashrc 
export PGDATA=/var/lib/opengauss/data

5 、查询数据文件目录和数据库版本步骤如下:

omm@modb:~$ gsql -r
gsql ((openGauss 3.0.0 build 02c14696) compiled at 2022-04-01 18:12:00 commit 0 last mr  )
Non-SSL connection (SSL connection is recommended when requiring high-security)
Type "help" for help.

# 查看数据文件的目录
omm=# show data_directory
omm-# ;
     data_directory      
-------------------------
 /var/lib/opengauss/data
(1 row)

# 查询数据库版本
omm=# select version();
                                                                        version                               
                                         
--------------------------------------------------------------------------------------------------------------
-----------------------------------------
 (openGauss 3.0.0 build 02c14696) compiled at 2022-04-01 18:12:00 commit 0 last mr   on aarch64-unknown-linux-
gnu, compiled by g++ (GCC) 7.3.0, 64-bit
(1 row)

命令输入完成后需要添加分号`;`作为命令结束符号