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

第一次体验在线的系统，感觉很新颖。学习进度无法完成的问题，后续也有解决，整体感觉不错。

查看进程服务，及主服务对应的子进程：

ps -ef|grep gauss

ps -Tp 1

omm@modb:~$ ps -Tp 1
PID SPID TTY TIME CMD
1 1 ? 00:00:00 gaussdb
1 300 ? 00:00:00 jemalloc_bg_thd
1 306 ? 00:00:00 gaussdb
1 308 ? 00:00:00 jemalloc_bg_thd
1 307 ? 00:00:00 syslogger
1 309 ? 00:00:00 alarm
1 310 ? 00:00:00 reaper
1 311 ? 00:00:00 jemalloc_bg_thd
1 312 ? 00:00:00 jemalloc_bg_thd
1 356 ? 00:00:00 checkpointer
1 357 ? 00:00:00 Spbgwriter
1 358 ? 00:00:00 pagewriter
1 359 ? 00:00:00 pagewriter
1 360 ? 00:00:00 pagewriter
1 361 ? 00:00:00 pagewriter
1 362 ? 00:00:00 pagewriter
1 363 ? 00:00:00 WALwriter
1 364 ? 00:00:00 WALwriteraux
1 365 ? 00:00:00 AVClauncher
1 366 ? 00:00:00 Jobscheduler
1 367 ? 00:00:00 asyncundolaunch
1 368 ? 00:00:00 globalstats
1 369 ? 00:00:00 applylauncher
1 370 ? 00:00:00 statscollector
1 371 ? 00:00:00 percentworker
1 372 ? 00:00:00 ashworker
1 373 ? 00:00:00 TrackStmtWorker
1 374 ? 00:00:00 auditor
1 375 ? 00:00:00 2pccleaner
1 376 ? 00:00:00 faultmonitor
1 377 ? 00:00:00 WLMworker
1 378 ? 00:00:00 WLMmonitor
1 379 ? 00:00:00 WLMarbiter
1 380 ? 00:00:00 undorecycler

使用gs_ctl status命令查看服务运行状态，也可以看到data目录路径：

omm@modb:~$ gs_ctl status
[2022-11-24 18:48:20.605][419][][gs_ctl]: gs_ctl status,datadir is /var/lib/opengauss/data
gs_ctl: server is running (PID: 1)
/usr/local/opengauss/bin/gaussdb

查看数据文件路径：

gs_ctl notify

使用环境变量查看数据库环境变量配置：

more ~/.bashrc

指定内容查看

grep -i PGDATA ~/.bashrc

查看数据文件的目录、数据库版本：

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