ITPub博客

首页 > 数据库 > PostgreSQL > 1.2 Physiacel Structure of Database Cluster

1.2 Physiacel Structure of Database Cluster

翻译 PostgreSQL 作者:kakaxi9521 时间:2021-07-06 15:06:51 1 删除 编辑

1.2. Physical Structure of Database Cluster

A database cluster basically is one directory referred to as base directory, and it contains some subdirectories and lots of files. If you execute the  initdb utility to initialize a new database cluster, a base directory will be created under the specified directory. Though it is not compulsory, the path of the base directory is usually set to the environment variable PGDATA.

Figure 1.2 shows an example of database cluster in PostgreSQL. A database is a subdirectory under the base subdirectory, and each of the tables and indexes is (at least) one file stored under the subdirectory of the database to which it belongs. Also there are several subdirectories containing particular data, and configuration files. While PostgreSQL supports tablespaces, the meaning of the term is different from other RDBMS. A tablespace in PostgreSQL is one directory that contains some data outside of the base directory.


当使用initdb 工具初始化一个新的数据库集群时会创建base目录,具体结构可看下图:



参考文档:

http://www.interdb.jp/pg/pgsql01.html

来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/21374452/viewspace-2779888/ ,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2009-04-13

  • 博文量
    136
  • 访问量
    178983