2022-11-27
opengauss gsql登录设置、登录后用户切换基础配置、命令
opengauss gsql登录设置、登录后用户切换基础配置、命令
我来答
添加附件
收藏
分享
问题补充
5条回答
默认
最新
omm=# create user user1 identified by 'abcd@1234';
NOTICE: The encrypted password contains MD5 ciphertext, which is not secure.
CREATE ROLE
omm=# \c ---查看当前用户和数据库是哪个
Non-SSL connection (SSL connection is recommended when requiring high-security)
You are now connected to database "omm" as user "omm". -----omm和omm
omm=# \c omm user1
Password for user user1:
Non-SSL connection (SSL connection is recommended when requiring high-security)
You are now connected to database "omm" as user "user1".
omm=> \c omm omm ----重新用omm用户连接omm数据库
Non-SSL connection (SSL connection is recommended when requiring high-security)
You are now connected to database "omm" as user "omm".
omm=#
评论
有用 0
是想问，\c 切换到一个新的用户，怎么能切换成上一个session么？
不能
窗口1：
[om302@node1 ~]$ gsql -d postgres -r
gsql ((openGauss 3.0.2 build ed8c0638) compiled at 2022-10-10 09:49:49 commit 0 last mr )
Non-SSL connection (SSL connection is recommended when requiring high-security)
Type "help" for help.
窗口2查看：
（12:58:48开始的session是当前窗口2的session）
openGauss=# select datname,sessionid,usename,application_name,backend_start from pg_stat_activity where application_name='gsql';
datname | sessionid | usename | application_name | backend_start
----------+-----------------+---------+------------------+-------------------------------
postgres | 139915364857600 | om302 | gsql | 2022-11-28 12:58:48.58299+08
postgres | 139915404764928 | om302 | gsql | 2022-11-28 13:02:08.775003+08
(2 rows)
窗口1执行切换用户：
openGauss=# \c - utest
Password for user utest:
Non-SSL connection (SSL connection is recommended when requiring high-security)
You are now connected to database "postgres" as user "utest".
openGauss=>
窗口2查看：
openGauss=# select datname,sessionid,usename,application_name,backend_start from pg_stat_activity where application_name='gsql';
datname | sessionid | usename | application_name | backend_start
----------+-----------------+---------+------------------+-------------------------------
postgres | 139915364857600 | om302 | gsql | 2022-11-28 12:58:48.58299+08
postgres | 139915697780480 | utest | gsql | 2022-11-28 13:02:39.438296+08
(2 rows)
可以发现，当\c切换用户时，会建立新的连接，同时释放上个session。
即使使用\c 切换回之前的用户也不会沿用之前已经释放的session，只能重新建立一个新的会话。下面继续进行测试：
窗口1切换回om302用户：
openGauss=> \c - om302
Non-SSL connection (SSL connection is recommended when requiring high-security)
You are now connected to database "postgres" as user "om302".
openGauss=#
窗口2查看：
openGauss=# select datname,sessionid,usename,application_name,backend_start from pg_stat_activity where application_name='gsql';
datname | sessionid | usename | application_name | backend_start
----------+-----------------+---------+------------------+-------------------------------
postgres | 139915364857600 | om302 | gsql | 2022-11-28 12:58:48.58299+08
postgres | 139915404764928 | om302 | gsql | 2022-11-28 13:09:17.452008+08
(2 rows)
回答交流
提交
问题信息
请登录之后查看
邀请回答
暂无人订阅该标签，敬请期待~~
墨值悬赏