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

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

$ ps -ef|grep guass|grep -v grep
--没有guass进程，启动数据库
$ su - omm
$ gs_ctl start -D $PGDATA
...
server started (/opt/opengauss/install/data/dn)
--查看进程和线程
$ ps -ef|grep gauss|grep -v grep
omm         1827       1  4 11:09 ?        00:00:08 /opt/opengauss/install/app/bin/gaussdb

$ ps -Tp 1827
    PID    SPID TTY          TIME CMD
   1827    1827 ?        00:00:02 gaussdb
   1827    1828 ?        00:00:00 jemalloc_bg_thd
   1827    1833 ?        00:00:00 gaussdb
   1827    1834 ?        00:00:00 syslogger
   1827    1835 ?        00:00:00 alarm
   1827    1836 ?        00:00:00 reaper
   1827    1861 ?        00:00:00 checkpointer
   1827    1862 ?        00:00:00 Spbgwriter
   1827    1863 ?        00:00:00 pagewriter
   1827    1864 ?        00:00:00 pagewriter
   1827    1865 ?        00:00:00 pagewriter
   1827    1866 ?        00:00:00 pagewriter
   1827    1867 ?        00:00:00 pagewriter
   1827    1868 ?        00:00:00 WALwriter
   1827    1869 ?        00:00:00 WALwriteraux
   1827    1870 ?        00:00:00 AVClauncher
   1827    1871 ?        00:00:00 Jobscheduler
   1827    1872 ?        00:00:00 asyncundolaunch
   1827    1873 ?        00:00:00 globalstats
   1827    1874 ?        00:00:00 applylauncher
   1827    1875 ?        00:00:00 statscollector
   1827    1876 ?        00:00:00 percentworker
   1827    1877 ?        00:00:05 ashworker
   1827    1878 ?        00:00:01 TrackStmtWorker
   1827    1879 ?        00:00:00 auditor
   1827    1880 ?        00:00:00 2pccleaner
   1827    1881 ?        00:00:00 faultmonitor
   1827    1883 ?        00:00:00 undorecycler

2. 查看数据库状态

$ gs_ctl status
[2022-11-24 11:15:23.274][2662][][gs_ctl]: gs_ctl status,datadir is /opt/opengauss/install/data/dn
gs_ctl: server is running (PID: 1827)
/opt/opengauss/install/app/bin/gaussdb

3. 查看数据文件的目录

$ gs_ctl notify
[2022-11-24 11:17:17.611][2674][][gs_ctl]: gs_ctl notify ,datadir is /opt/opengauss/install/data/dn
[2022-11-24 11:17:17.611][2674][][gs_ctl]: the parameter of notify must be specified

4. 查看omm用户的环境变量

$ cat ~/.bashrc
# Source default setting
[ -f /etc/bashrc ] && . /etc/bashrc

# User environment PATH
PATH="$HOME/.local/bin:$HOME/bin:$PATH"
export PATH
export GPHOME=/opt/opengauss/install/om
export PATH=$GPHOME/script/gspylib/pssh/bin:$GPHOME/script:$PATH
export LD_LIBRARY_PATH=$GPHOME/lib:$LD_LIBRARY_PATH
export PYTHONPATH=$GPHOME/lib
export GAUSSHOME=/opt/opengauss/install/app
export PATH=$GAUSSHOME/bin:$PATH
export LD_LIBRARY_PATH=$GAUSSHOME/lib:$LD_LIBRARY_PATH
export S3_CLIENT_CRT_FILE=$GAUSSHOME/lib/client.crt
export GAUSS_VERSION=3.0.0
export PGHOST=/opt/opengauss/tmp
export GAUSSLOG=/var/log/omm/omm
umask 077
export GAUSS_ENV=2
export GS_CLUSTER_NAME=Cluster_template
export PGDATA=/opt/opengauss/install/data/dn

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

$ grep -i PGDATA ~/.bashrc
export PGDATA=/opt/opengauss/install/data/dn

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

$ gsql -d postgres -p 15400 -r
gsql ((openGauss 3.0.0 build 02c14696) compiled at 2022-04-01 18:12:19 commit 0 last mr  )
Non-SSL connection (SSL connection is recommended when requiring high-security)
Type "help" for help.

openGauss=#
openGauss=# show data_directory ;
         data_directory
--------------------------------
 /opt/opengauss/install/data/dn
(1 row)


openGauss=# select version();
                                                                       version

----------------------------------------------------------------------------------------------------------------
--------------------------------------
 (openGauss 3.0.0 build 02c14696) compiled at 2022-04-01 18:12:19 commit 0 last mr   on x86_64-unknown-linux-gnu
, compiled by g++ (GCC) 7.3.0, 64-bit
(1 row)