概述

本文档记录openGauss 3.0.0数据库每日一练第1天课程作业，从操作系统层面和使用openGauss工具查看数据库的状态、版本和数据文件目录。

课程练习

查看数据库进程和线程

进程存在，查看进程对应线程正常。

[omm@ogauss1 ~]$ ps -ef|grep gauss
omm      13241     1 99 Nov05 ?        21-06:54:22 /opt/huawei/install/app/bin/gaussdb -D /opt/huawei/install/data/db1 -M primary
omm      32675 32461  0 10:36 pts/1    00:00:00 grep --color=auto gauss
[omm@ogauss1 ~]$ ps -Tp 13241
  PID  SPID TTY          TIME CMD
13241 13241 ?        00:00:14 gaussdb
13241 13242 ?        00:00:00 jemalloc_bg_thd
13241 13245 ?        00:00:00 gaussdb
13241 13246 ?        00:00:06 syslogger
13241 13247 ?        00:03:43 alarm
13241 13248 ?        00:00:00 jemalloc_bg_thd
13241 13249 ?        00:00:03 reaper
13241 13250 ?        00:00:00 jemalloc_bg_thd
13241 13251 ?        00:00:00 jemalloc_bg_thd
13241 32176 ?        00:01:00 checkpointer
13241 32179 ?        00:14:50 pagewriter
13241 32182 ?        00:00:12 pagewriter
13241 32183 ?        00:00:07 bgwriter
13241 32184 ?        00:00:06 bgwriter
13241 32185 ?        00:00:00 rpcservice
13241 32186 ?        00:00:00 WALwriteraux
13241 32187 ?        00:00:00 rpcservice
13241 32188 ?        00:00:00 rpcservice
13241 32189 ?        00:00:24 rpcservice
13241 32190 ?        00:00:03 statscollector
13241 32191 ?        00:00:00 auditor
13241 32193 ?        00:00:03 rpcservice
13241 32194 ?        00:00:00 rpcservice
13241   325 ?        6-22:54:33 WALwriter
13241   326 ?        00:00:01 AVClauncher
13241   327 ?        00:01:07 Jobscheduler
13241   328 ?        00:07:39 snapshotworker
13241   329 ?        17:54:35 percentworker
13241   330 ?        02:13:36 ashworker
13241   331 ?        00:58:55 TrackStmtWorker
13241   332 ?        00:01:20 2pccleaner
13241   333 ?        00:00:00 faultmonitor
13241   334 ?        00:00:51 WalSender
13241   351 ?        00:01:04 heartbeat

gs_ctl工具查看数据库状态

状态为running，正常。

[omm@ogauss1 ~]$ gs_ctl status
[2022-11-24 10:38:04.315][32701][][gs_ctl]: gs_ctl status,datadir is /opt/huawei/install/data/db1 
gs_ctl: server is running (PID: 13241)
/opt/huawei/install/app/bin/gaussdb "-D" "/opt/huawei/install/data/db1" "-M" "primary"

gs_ctl 查看数据文件的目录

数据目录获取正常。

[omm@ogauss1 ~]$ gs_ctl notify
[2022-11-24 10:39:34.706][32728][][gs_ctl]: gs_ctl notify ,datadir is /opt/huawei/install/data/db1 
[2022-11-24 10:39:34.706][32728][][gs_ctl]: the parameter of notify must be specified

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

PGDATA配置正确。

[omm@ogauss1 ~]$ env|grep PG
PGHOST=/opt/huawei/tmp
PGDATA=/opt/huawei/install/data/db1

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

gsql客户端进入正常，获取版本正常。

omm@local:/opt/huawei/tmp [db1]=#\q
[omm@ogauss1 ~]$ gsql -d postgres -p 15400 -r
gsql ((openGauss 2.0.0 build 78689da9) compiled at 2021-03-31 21:04:03 commit 0 last mr  )
Non-SSL connection (SSL connection is recommended when requiring high-security)
Type "help" for help.

omm@local:/opt/huawei/tmp [postgres]=#show data_directory ;
        data_directory        
------------------------------
 /opt/huawei/install/data/db1
(1 row)

omm@local:/opt/huawei/tmp [postgres]=#select version();
                                                                                version                                         
                                       
--------------------------------------------------------------------------------------------------------------------------------
---------------------------------------
 PostgreSQL 9.2.4 (openGauss 2.0.0 build 78689da9) compiled at 2021-03-31 21:04:03 commit 0 last mr   on x86_64-unknown-linux-gn
u, compiled by g++ (GCC) 7.3.0, 64-bit
(1 row)

omm@local:/opt/huawei/tmp [postgres]=#

注：本地环境之前安装为openGauss 2.0.0，故版本显示为2.0.0。