第5天 | openGauss中一个用户可以访问多个数据库

Welcome to 墨天轮.
This is Web Terminal of modb.pro; Good Good Study, Day Day Up.


root@modb:~#
root@modb:~# su - omm
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=# drop DATABASE IF EXISTS musicdb;
NOTICE: database "musicdb" does not exist, skipping
DROP DATABASE
omm=# drop DATABASE IF EXISTS musicdb1;
DROP DATABASE
omm=# drop DATABASE IF EXISTS musicdb2;
DROP DATABASE
omm=# drop DATABASE IF EXISTS musicdb3;
DROP DATABASE
omm=# drop tablespace IF EXISTS music_tbs;
DROP TABLESPACE
omm=#
omm=# CREATE TABLESPACE music_tbs RELATIVE LOCATION 'tablespace/test_ts1';
CREATE TABLESPACE
omm=# CREATE DATABASE musicdb1 WITH TABLESPACE = music_tbs;
CREATE DATABASE musicdb2 WITH TABLESPACE = music_tbs;
CREATE DATABASE
omm=# CREATE DATABASE
omm=# CREATE DATABASE musicdb3 WITH TABLESPACE = music_tbs;

CREATE DATABASE
omm=#
omm=#
omm=#
omm=# CREATE USER user1 IDENTIFIED BY 'kunpeng@1234';
ERROR: role "user1" already exists
omm=# ALTER USER user1 SYSADMIN;
ALTER ROLE
omm=# \c musicdb1 user1
Password for user user1:
Non-SSL connection (SSL connection is recommended when requiring high-security)
You are now connected to database "musicdb1" as user "user1".
musicdb1=> create table t11(col1 char(20));
CREATE TABLE
musicdb1=> insert into t11 values ('hello openGauss! 11');
INSERT 0 1
musicdb1=> select * from t11;
col1
----------------------
hello openGauss! 11
(1 row)

musicdb1=> \c musicdb2 user1
Password for user user1:
Non-SSL connection (SSL connection is recommended when requiring high-security)
You are now connected to database "musicdb2" as user "user1".
musicdb2=>
musicdb2=> musicdb2=>

musicdb2=>
musicdb2=> create table t21(col1 char(20));
musicdb2=> CREATE TABLE

musicdb2=>
musicdb2=> insert into t21 values('Hello openGauss! 22');
INSERT 0 1
musicdb2=> select * from t21;
col1
----------------------
Hello openGauss! 22
(1 row)

musicdb2=> \c musicdb3 user1
Password for user user1:
Non-SSL connection (SSL connection is recommended when requiring high-security)
You are now connected to database "musicdb3" as user "user1".
musicdb3=> create table t31 (col1 char(20));
CREATE TABLE
musicdb3=> insert into t31 values('Hello openGauss! 22');
musicdb3=> INSERT 0 1

musicdb3=> select * from t31;
(1 row)

musicdb3=> col1
----------------------
Hello openGauss! 22

musicdb3=> insert into t31 values ('Hello openGauss! 33');
INSERT 0 1
musicdb3=> select * from t31;
col1
----------------------
Hello openGauss! 22
Hello openGauss! 33
(2 rows)

musicdb3=> \q
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=# cerate database musicdb10 with tablespace = music_tbs;
CREATE DATABASE
omm=# create user user10 ;
ERROR: The password could not be NULL.
omm=# creaet user user10 identified by 'kunpeng@1234';
ERROR: syntax error at or near "creaet"
LINE 1: creaet user user10 identified by 'kunpeng@1234';
^
omm=# create user user10 identified by 'kunpeng@1234';
NOTICE: The encrypted password contains MD5 ciphertext, which is not secure.
CREATE ROLE
omm=# alter user user10 sysadmin;
ALTER ROLE
omm=# \c postgres user10
Password for user user10:
Non-SSL connection (SSL connection is recommended when requiring high-security)
You are now connected to database "postgres" as user "user10".
openGauss=> create table test (col1 char(10));
CREATE TABLE
openGauss=> insert into test values('hello hello');
ERROR: value too long for type character(10)
CONTEXT: referenced column: col1
openGauss=> insert into test intovalues('hello!'
openGauss(>
openGauss(> create database musicdb10 with tablespace = music_tbs;
openGauss(> create database musicdb10 with tablespace = music_tbs;
openGauss(> create database musicdb10 with tablespace = music_;
openGauss(>
openGauss(> ;
openGauss(> ;
openGauss(> ;
openGauss(> );
openGauss=> ERROR: syntax error at or near "intovalues"
LINE 1: insert into test intovalues('hello!'
^

openGauss=> insert into test values('hello!');
INSERT 0 1
openGauss=> select * from test;
col1
------------
hello!
(1 row)

openGauss=> \c omm user10
Password for user user10:
Non-SSL connection (SSL connection is recommended when requiring high-security)
You are now connected to database "omm" as user "user10".
omm=> create table test (col1 char(20));
CREATE TABLE
omm=> insert into test values('123456');
INSERT 0 1
omm=> select * from test;
col1
----------------------
123456
(1 row)

omm=> \c musicdb10 user10
Password for user user10:
Non-SSL connection (SSL connection is recommended when requiring high-security)
You are now connected to database "musicdb10" as user "user10".
musicdb10=> create table test01 (col1 char(20));
CREATE TABLE
musicdb10=> insert into test01 values('test!123456!');
INSERT 0 1
musicdb10=> select * from test01;
col1
----------------------
test!123456!
(1 row)

musicdb10=>