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

标题: PGDATA 数据目录结构 [打印本页]

作者: 郑全    时间: 2021-10-12 12:35
标题: PGDATA 数据目录结构
本帖最后由 郑全 于 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







欢迎光临 重庆思庄Oracle、Redhat认证学习论坛 (http://bbs.cqsztech.com/) Powered by Discuz! X3.2