openGauss每日一练第1天 | 学习心得体会

学习目标

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

实操结果

1.从操作系统层面查看数据库进程和线程,判断数据库是否启动。

omm 1 0 0 14:58 ? 00:00:00 gaussdb  
omm 383 377 0 14:59 pts/0 00:00:00 grep gauss

2.使用gs_ctl工具查看数据库状态,判断数据库是否启动。

\[2022-11-24 14:59:34.641\]\[386\]\[\]\[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 查看数据文件的目录

\[2022-11-24 14:59:42.532\]\[390\]\[\]\[gs\_ctl\]: gs\_ctl notify ,datadir is /var/lib/opengauss/data  
\[2022-11-24 14:59:42.532\]\[390\]\[\]\[gs\_ctl\]: the parameter of notify must be specified

4.从环境变量查看数据文件的目录

\# ~/.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 chr3\[00m\\\]\\$ '  
else  
PS1='${debian\_chroot:+($debian\_chroot)}\\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'  
  
\# 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  
\# ~/.bashoot 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\\\[\\03\_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  
\# 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

在gsql中查看数据文件目录、数据库版本  

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\_directoryomm-#  
^C  
omm=# show data\_directory ;  
omm=# data\_directory  
\-------------------------  
/var/lib/opengauss/data  
(1 row)  
  
  
omm=# select 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)

熟练掌握通过gs_ctl的相关用法```language