高斯 硬盘丢失保存

1。

F:\guass300(集群成功)\guass300vm

2.资源占用

3.

密码应该是root

[root@GaussDB200 ]# su omm

切换到omm账号

刷环境变量

[omm@GaussDB200 ]$ source ${BIGDATA_HOME}/mppdb/.mppdbgs_profile

omm用户连接数据库

[omm@GaussDB200 ]$ gsql -d postgres -p 25308
gsql ((GaussDB Kernel V300R002C00 build 8a9c1eb6) compiled at 2019-08-01 18:47:38 commit 6093 last mr 10175 )
NOTICE : The password has been expired, please change the password. 
Non-SSL connection (SSL connection is recommended when requiring high-security)
Type "help" for help.

postgres=# 

4.简单的命令

[omm@GaussDB200 ]$ gs_dump -f /dev/目录/test.sql -p 25308 postgres -t test -F p

gs_dump[port='25308'][postgres][2024-07-17 23:57:23]: The total objects number is 337.
gs_dump[port='25308'][postgres][2024-07-17 23:57:23]: [100.00%] 337 objects have been dumped.
gs_dump[port='25308'][postgres][2024-07-17 23:57:23]: dump database postgres successfully
gs_dump[port='25308'][postgres][2024-07-17 23:57:23]: total time: 518  ms
[omm@GaussDB200 ]$ 
 

5.外表查询失败

postgres=# select count(1) from foreign_tpcds_reasons;
ERROR:  The peer GDS has performed an orderly shutdown on current connection.
HINT:  Please refer to GDS log for more details.
 

6.查询相关的版本信息

postgres=# select version();
                                                                                
         version                                                                
                          
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
--------------------------
 PostgreSQL 9.2.4 (GaussDB Kernel V300R002C00 build 8a9c1eb6) compiled at 2019-0
8-01 18:47:38 commit 6093 last mr 10175  on x86_64-unknown-linux-gnu, compiled b
y g++ (GCC) 5.4.0, 64-bit
(1 row)

7.登录管理后台

ens33: flags=4163<UP,BROADCAST,RUNNING,MULTICAST>  mtu 1500
        inet 192.168.211.144  netmask 255.255.255.0  broadcast 192.168.211.255
        inet6 fe80::20c:29ff:fef3:4e8f  prefixlen 64  scopeid 0x20<link>
        ether 00:0c:29:f3:4e:8f  txqueuelen 1000  (Ethernet)
        RX packets 1437  bytes 115969 (113.2 KiB)
        RX errors 0  dropped 0  overruns 0  frame 0
        TX packets 16434  bytes 1006066 (982.4 KiB)
        TX errors 0  dropped 0 overruns 0  carrier 0  collisions 0

参考

GaussDB 200单机实例安装使用教程【入门必看】_gaussdb教程-CSDN博客

https://blog.csdn.net/liuge36/article/details/106274921

8.搞了个乌龙密码忘记了  华为手册

http://192.168.211.144:8080/web/    默认密码admin/Admin@123

修改成了Admin@1234

后续补充