openGauss每日一练第 1 天|数据库状态及数据文件目录查看

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

root@modb:~# ps -ef |grep  gauss
omm          1     0  0 10:37 ?        00:00:00 gaussdb
root       385   380  0 10:39 pts/0    00:00:00 grep gauss

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

su - omm
omm@modb:~$ gs_ctl status
[2022-11-24 10:41:21.138][401][][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 查看数据文件的目录

omm@modb:~$ gs_ctl notify
[2022-11-24 10:42:38.313][410][][gs_ctl]: gs_ctl notify ,datadir is /var/lib/opengauss/data 
[2022-11-24 10:42:38.313][410][][gs_ctl]: the parameter of notify must be specified

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

omm@modb:~$  grep -i PGDATA ~/.bashrc
export PGDATA=/var/lib/opengauss/data

5.在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_directory ;
     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)

omm=#