pg（HGDB）在非默认位置创建表空间

最新推荐文章于 2024-09-19 22:51:10 发布

lk_db

最新推荐文章于 2024-09-19 22:51:10 发布

阅读量695

点赞数

分类专栏： Highgo DB PostgreSQL

本文链接：https://blog.youkuaiyun.com/lk_db/article/details/78199698

版权

Highgo DB 同时被 2 个专栏收录

171 篇文章

订阅专栏

PostgreSQL

162 篇文章

订阅专栏

创建完表空间后，会在表精简的跟目录下生成带有“Catalog version”的子目录，如：
highgo=# create tablespace tbs01 location '/data/highgo/4.1.0/1';
CREATE TABLESPACE

[highgo@db1 1]$ ll
total 0
drwx------ 2 highgo highgo 6 Jul 14 10:03 PG_9.5_201510051

[highgo@db1 bin]$ ./pg_controldata
pg_control version number: 942
Catalog version number: 201510051 <------
Database system identifier: 6440206338596970075
Database cluster state: in production
pg_control last modified: Fri Jul 14 10:03:52 2017

在PG_9.5_201510051子目录下，又会有一些子目录，这些子目录的名称就是数据库的oid

highgo=# create database osdba tablespace tbs01;
CREATE DATABASE
highgo=# \q
[highgo@db1 PG_9.5_201510051]$ ll
total 12
drwx------ 2 highgo highgo 8192 Jul 14 10:05 46886
[highgo@db1 PG_9.5_201510051]$ psql
psql (4.1.0)
Type "help" for help.

highgo=# select oid,datname from pg_database;
oid | datname
-------+-----------
13345 | template0
13350 | highgo
46638 | template1
46886 | osdba
(4 rows)

[highgo@db1 46886]$ pwd
/data/highgo/4.1.0/1/PG_9.5_201510051/46886
[highgo@db1 46886]$ ls
112 13183 13201 174 2603 2609 2616_fsm 2654 2673 2692 2831 2841 3258 3502 3600 3609
113 13185 13201_fsm 175 2603_fsm 2609_fsm 2616_vm 2655 2674 2693 2832 2995 3350 3503 3600_fsm 3712
1247 13186 13201_vm 2187 2603_vm 2609_vm 2617 2656 2675 2696 2832_vm 2995_vm 3350_vm 3534 3600_vm 3764
1247_fsm 13186_fsm 13203 2328 2604 2610 2617_fsm 2657 2678 2699 2833 2996 3351 3541 3601 3764_fsm
1247_vm 13186_vm 13205 2328_vm 2604_vm 2610_fsm 2617_vm 2658 2679 2701 2834 3079 3353 3541_fsm 3601_fsm 3764_vm
1249 13188 13206 2336 2605 2610_vm 2618 2659 2680 2702 2834_vm 3079_fsm 3353_vm 3541_vm 3601_vm 3766
1249_fsm 13190 13206_fsm 2336_vm 2605_fsm 2611 2618_fsm 2660 2681 2703 2835 3079_vm 3354 3542 3602 3767
1249_vm 13191 13206_vm 2337 2605_vm 2611_vm 2618_vm 2661 2682 2704 2836 3080 3455 3574 3602_fsm 548
1255 13191_fsm 13208 2600 2606 2612 2619 2662 2683 2753 2836_vm 3081 3456 3575 3602_vm 549
1255_fsm 13191_vm 13210 2600_fsm 2606_fsm 2612_fsm 2619_fsm 2663 2684 2753_fsm 2837 3085 3456_fsm 3576 3603 826
1255_vm 13193 13211 2600_vm 2606_vm 2612_vm 2619_vm 2664 2685 2753_vm 2838 3118 3456_vm 3576_vm 3603_fsm 826_vm
1259 13195 13213 2601 2607 2613 2620 2665 2686 2754 2838_fsm 3118_vm 3466 3596 3603_vm 827
1259_fsm 13196 13215 2601_fsm 2607_fsm 2613_vm 2620_vm 2666 2687 2755 2838_vm 3119 3466_vm 3596_vm 3604 828
1259_vm 13196_fsm 1417 2601_vm 2607_vm 2615 2650 2667 2688 2756 2839 3164 3467 3597 3605 PG_VERSION
13181 13196_vm 1417_vm 2602 2608 2615_fsm 2651 2668 2689 2757 2840 3256 3468 3598 3606 pg_filenode.map
13181_fsm 13198 1418 2602_fsm 2608_fsm 2615_vm 2652 2669 2690 2830 2840_fsm 3256_vm 3501 3598_vm 3607
13181_vm 13200 1418_vm 2602_vm 2608_vm 2616 2653 2670 2691 2830_vm 2840_vm 3257 3501_vm 3599 3608

*******************************************************************************************************

[highgo@db1 pg_tblspc]$ ll
total 0
lrwxrwxrwx 1 highgo highgo 20 Jul 14 10:03 46885 -> /data/highgo/4.1.0/1 <---46885

[highgo@db1 pg_tblspc]$ cd /data/highgo/4.1.0/1
[highgo@db1 1]$ ls
PG_9.5_201510051
[highgo@db1 1]$ cd PG_9.5_201510051/
[highgo@db1 PG_9.5_201510051]$ ls
46886 <--- 46886
[highgo@db1 PG_9.5_201510051]$

highgo=# create database osdba2 tablespace tbs01; <--46887
CREATE DATABASE
highgo=# select oid,datname from pg_database;
oid | datname
-------+-----------
13345 | template0
13350 | highgo
46638 | template1
46886 | osdba
46887 | osdba2
(5 rows)

highgo=# \q
[highgo@db1 PG_9.5_201510051]$ pwd
/data/highgo/4.1.0/1/PG_9.5_201510051
[highgo@db1 PG_9.5_201510051]$ ls
46886 46887
[highgo@db1 PG_9.5_201510051]$

[highgo@db1 PG_9.5_201510051]$ pwd
/data/highgo/4.1.0/data/pg_tblspc/46885/PG_9.5_201510051
[highgo@db1 PG_9.5_201510051]$ ls
46886 46887
[highgo@db1 PG_9.5_201510051]$