PostgreSQL 数据目录结构

根目录介绍 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 global目录介绍 根目录介绍 data ├── base # use to sto