postgresql 编码_一文看懂PostgreSQL数据目录结构

概述

我们一般解压PG后可以看到有很多个目录，那么这些目录都代表什么意思呢?

---

1、根目录介绍

data├── base # use to store database file(SELECT oid, datname FROM pg_database;)├── global # under global, all the filenode is hard-code(select oid,relname,relfilenode from pg_class where relfilenode=0 order by oid;)├── pg_clog # dir of transaction commit log│ └── 0000├── pg_commit_ts├── pg_dynshmem├── pg_hba.conf # client authentication config file├── pg_ident.conf # user ident map file├── pg_logical│ ├── mappings│ └── snapshots├── pg_multixact│ ├── members│ │ └── 0000│ └── offsets│ └── 0000├── pg_notify│ └── 0000├── pg_replslot├── pg_serial├── pg_snapshots # dir of snapshot file├── pg_stat├── pg_stat_tmp # dir of tmp stat file│ ├── db_0.stat│ ├── db_12407.stat│ ├── db_16384.stat│ └── global.stat├── pg_subtrans│ └── 0000├── pg_tblspc├── pg_twophase├── PG_VERSION # version file├── pg_xlog # dir of xlog file│ ├── 000000010000000000000001│ └── archive_status # status info of xlog archive├── postgresql.auto.conf├── postgresql.conf # config file of postmaster progress├── postmaster.opts└── postmaster.pid # pid file of postmaster progress

可以看到有这么多的根目录，下面对每个目录做一下简单介绍。