openGauss每日一练第9天 - 学习心得体会

课后作业

1.创建表空间newtbs1

drop tablespace IF EXISTS newtbs1;
复制

2.创建3个数据库newdb1、newdb2、newdb3，默认表空间为newtbs1

create database newdb1 with tablespace = newtbs1;
create database newdb2 with tablespace = newtbs1;
create database newdb3 with tablespace = newtbs1;
复制

3.使用sql查看表空间newtbs1上有几个数据库

select datname,dattablespace,spcname from pg_database d, pg_tablespace t where d.dattablespace=t.oid;        
复制

4.在文件系统中查看表空间newtbs1中的多个数据库

omm=# select oid,* from pg_tablespace ;
  oid  |   spcname    | spcowner | spcacl | spcoptions | spcmaxsize | relative 
-------+--------------+----------+--------+------------+------------+----------
  1663 | pg_default   |       10 |        |            |            | f
  1664 | pg_global    |       10 |        |            |            | f
 16389 | ds_location1 |       10 |        |            |            | t
 16390 | newtbs1      |       10 |        |            |            | t
复制

newtbs1 的oid是16390

cd /var/lib/opengauss/data/pg_tblspc/16390/
复制

omm@modb:/var/lib/opengauss/data/pg_tblspc/16390$ cd  PG_9.2* 
omm@modb:/var/lib/opengauss/data/pg_tblspc/16390/PG_9.2_201611171_gaussdb$ 
omm@modb:/var/lib/opengauss/data/pg_tblspc/16390/PG_9.2_201611171_gaussdb$ ls
16395  16399  16400  16401
omm@modb:/var/lib/opengauss/data/pg_tblspc/16390/PG_9.2_2016111
复制