Openguasss数据库学习之链接数据库

最新推荐文章于 2024-04-15 17:14:44 发布

const向阳而生

最新推荐文章于 2024-04-15 17:14:44 发布

阅读量716

点赞数 7

分类专栏： OpenGuasss数据库学习文章标签：数据库学习

本文链接：https://blog.csdn.net/LiTuring/article/details/135943176

版权

OpenGuasss数据库学习专栏收录该内容

1 篇文章 0 订阅

订阅专栏

本文详细描述了在Linux环境下对OpenGauss3.0.0数据库进行登录、状态检查、集群启动以及解决警告问题的过程，涉及gs_om命令和数据库安全提示。

摘要由CSDN通过智能技术生成

1.环境准备

登录omm

[root@enmoedu ~]# su - omm
Last login: Mon Nov 28 22:29:58 CST 2022 on pts/0

登录数据库

[omm@enmoedu ~]$ gsql -d postgres -p 15400 -r
failed to connect /opt/huawei/tmp:15400.

查看当前状态

[omm@enmoedu ~]$ gs_om -t status --detail
[   Cluster State   ]

cluster_state   : Unavailable
redistributing  : No
current_az      : AZ_ALL

[  Datanode State   ]

    node   node_ip         port      instance                            state
----------------------------------------------------------------------------------------------
1  enmoedu 192.168.94.135  15400      6001 /opt/huawei/install/data/dn   P Primary Manually stopped

将数据库拉起来

[omm@enmoedu ~]$ gs_om -t start
Starting cluster.
=========================================
[SUCCESS] enmoedu
2022-11-29 17:43:18.778 6385d436.1 [unknown] 140169551084608 [unknown] 0 dn_6001 01000  0 [BACKEND] WARNING:  could not create any HA TCP/IP sockets
2022-11-29 17:43:18.778 6385d436.1 [unknown] 140169551084608 [unknown] 0 dn_6001 01000  0 [BACKEND] WARNING:  could not create any HA TCP/IP sockets
2022-11-29 17:43:18.804 6385d436.1 [unknown] 140169551084608 [unknown] 0 dn_6001 01000  0 [BACKEND] WARNING:  Failed to initialize the memory protect for g_instance.attr.attr_storage.cstore_buffers (1024 Mbytes) or shared memory (1894 Mbytes) is larger.
=========================================
Successfully started.

登录数据库

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