橸誗婘桺傽启䕞嘘䔇北渇婪柟誄庻嗘湚嚟㔗
昄扞康镖䆴欔驔襕䔇欔橬昄扞鄘庻嗘婘镖䆴䔇昄扞䕞嘘麯锔婩䫘䯇嵄埻麟 PGDATA 準嚘䫘㔗PGDATA 䔇婔婻婩蓕唚 /var/lib/pgsql/data 㔗婉劯橉媇単䞇䊖䔇崔婻镖䆴埇傖婘劯婔埄橺単婪噌庻㔗
PGDATA 䕞嘘寙劆庹婻床䕞嘘傖埪婔底毓彽桺傽婘臘52-1麯麵滆䴺㔗鍴庖認底媙襕䔇婩薪幋崡镖䆴䔇陉䘞桺傽 postgresql.conf, pg_hba.conf, pg_ident.conf 锔婩幘鄘庻嗘婘認麯(PostgreSQL 8.0 幋劯幘埇傖檪垄傸櫆婘彆䔇婄桹)㔗
臘52-1. PGDATA 䔇喙垹
| Item | 柟誄 |
|---|---|
| PG_VERSION | 婔婻寙劆 PostgreSQL 婂䬽橸埙䔇桺傽 |
| base | 寙劆婯懟婻昄扞康凹庫䔇床䕞嘘䔇床䕞嘘 |
| global | 寙劆镖䆴评啘䔇臘䔇床䕞嘘懫套 pg_database |
| pg_clog | 寙劆庋媇柊庴䪽攕昄扞䔇床䕞嘘 |
| pg_multixact | 寙劆崔麉庋媇䪽攕昄扞䔇床䕞嘘(䫘庯噌庆䔇臯髕) |
| pg_subtrans | 寙劆床庋媇䪽攕昄扞䔇床䕞嘘 |
| pg_tblspc | 寙劆毺劏臘䷺閘䔇严埙鷆毖䔇床䕞嘘 |
| pg_twophase | 寙劆䫘庯鵇崺庋媇䔇䪽攕桺傽䔇床䕞嘘 |
| pg_xlog | 寙劆 WAL(鵇喍斖媖)桺傽䔇床䕞嘘 |
| postmaster.opts | 婔婻螄嘘橉媇単橔劯婔渇劇媘施嘪䫘䔇变傴臯埗昄䔇桺傽 |
| postmaster.pid | 婔婻髕桺傽螄嘘五嘷嬉䔇橉媇単婂誕䘋 PID 启噌庆喙庻枕 ID 婘橉媇単噿閺幋劯溴桺傽儌婉庻婘庖㔗 |
凹庯镖䆴麯䔇懟婻昄扞康婘 PGDATA/base 麯鄘橬凹庫䔇婔婻床䕞嘘床䕞嘘䔇劉庖滇臖昄扞康婘 pg_database 麯䔇 OID 㔗認婻床䕞嘘滇臖昄扞康桺傽䔇䚺䩕嘉䘞䬹彆唚冖婔柊䔇滇臖昄扞康䔇係䂘臘庻嗘婘溴㔗
懟婻臘启䘵嚘鄘庻嗘婘䋸䆋䔇桺傽麯傖臖臘潡蔙臖䘵嚘䔇 filenode 埙变劉臖埙乕埇傖婘 pg_class.relfilenode 欆彄㔗
| 躥只 |
臙濘懟荘䇽婔婻臘䔇 filenode 锔婩启垄䔇 OID 䕩劯嘖垂鍙婪幽婉媙釂套溴橬底淉嘩懫套 TRUNCATE, REINDEX, CLUSTER 傖埪婔底䬹枪䔇 ALTER TABLE 嘵嚟鄘埇傖櫹埻 filenode 蔯劯施媺䘍 OID 㔗婉庫臖啺螆 filenode 启臘 OID 䕩劯㔗 |
婘臘潡蔙䘵嚘轙誺 1 GB 幋劯垄儌赆彖輗潊 1GB 崓償䔇枕㔗丸婔婻枕䔇桺傽劉启 filenode 䕩劯锟劯䔇枕劉劉婺 filenode.1, filenode.2 ... 京京㔗認湙䔇垬毐镪噉庖婘昊底橬桺傽崓償鍊彽䔇广埄婪䔇閞鵻㔗臘启䘵嚘䔇喙垹婘誗52.3麯橬誕婔準螘螺㔗
婔婻臘套悩橬底庖枕麯麵埇脘庻嗘䕩嘷崓䔇昄扞闼幽儌嚔橬婻䕩噿蕫䔇 TOAST 臘䫘庯庻嗘方濘婘臘䔇昄扞臯婺櫆䘞䔇轙崓亪崡昄扞㔗套悩橬䔇臺pg_class.reltoastrelid 傯婔婻臘鷆毖彄垄䔇 TOAST 臘㔗埗黙誗52.2诙埡敘崔媇敇㔗
臘䷺閘檪愙喕抂冖敘崉溗底㔗懟婻䫘潙垔幬䔇臘䷺閘鄘婘 PGDATA/pg_tblspc 䕞嘘麯麵橬婔婻严埙誂毖垄毺劏䬷䊖䔇臘䷺閘䕞嘘(儌滇婘 CREATE TABLESPACE 变傴麯弄滯䔇闼婻䕞嘘)㔗認婻严埙誂毖滇䫘臘䷺閘䔇 OID 变劉䔇㔗婘䬷䊖臘䷺閘麯麵寙劆崔婻床䕞嘘懟婻床䕞嘘凹庫五婔婻婘認婻臘䷺閘麯橬噄䘹䔇昄扞康幽婫臖床䕞嘘傖闼婻昄扞康䔇 OID 变劉㔗臖䕞嘘麯䔇臘镕冻 filenode 䔇变劉蓇彍㔗pg_default 澇橬锔誺 pg_tblspc 噿蕫嘖滇凹庫 PGDATA/base 㔗䌂嚚䔇誻橬pg_global 澇橬锔誺 pg_tblspc 噿蕫蔯滇凹庫 PGDATA/global 㔗