重庆思庄Oracle、Redhat认证学习论坛

 找回密码
 注册

QQ登录

只需一步,快速开始

搜索
查看: 1092|回复: 0

PGDATA 数据目录结构

[复制链接]
发表于 2021-10-12 12:35:23 | 显示全部楼层 |阅读模式
本帖最后由 郑全 于 2021-10-12 12:46 编辑

ItemDescription
01.文件
PG_VERSION包含 PostgreSQL 主版本号的文件
postgresql.auto.conf配置文件,使用 ALTER SYSTEM命令 修改后的参数写入该文件
postmaster.optsA file recording the command-line options the server was last started with
postmaster.pid主进程PID文件
02.目录
baseSubdirectory containing per-database subdirectories
current_logfilesFile recording the log file(s) currently written to by the logging collector
globalSubdirectory containing cluster-wide tables, such as pg_database
pg_commit_tsSubdirectory containing transaction commit timestamp data
pg_dynshmemSubdirectory containing files used by the dynamic shared memory subsystem
pg_logicalSubdirectory containing status data for logical decoding
pg_multixactSubdirectory containing multitransaction status data (used for shared row locks)
pg_notifySubdirectory containing LISTEN/NOTIFY status data
pg_replslotSubdirectory containing replication slot data
pg_serialSubdirectory containing information about committed serializable transactions
pg_snapshotsSubdirectory containing exported snapshots
pg_statSubdirectory containing permanent files for the statistics subsystem
pg_stat_tmpSubdirectory containing temporary files for the statistics subsystem
pg_subtransSubdirectory containing subtransaction status data
pg_tblspcSubdirectory containing symbolic links to tablespaces
pg_twophaseSubdirectory containing state files for prepared transactions
pg_walSubdirectory containing WAL (Write Ahead Log) files
pg_xactSubdirectory containing transaction commit status data


回复

使用道具 举报

您需要登录后才可以回帖 登录 | 注册

本版积分规则

QQ|手机版|小黑屋|重庆思庄Oracle、Redhat认证学习论坛 ( 渝ICP备12004239号-4 )

GMT+8, 2024-2-28 23:12 , Processed in 0.096439 second(s), 20 queries .

重庆思庄学习中心论坛-重庆思庄科技有限公司论坛

© 2001-2020

快速回复 返回顶部 返回列表