Shulou(Shulou.com)06/01 Report--

Introduction to the postgre directory:

├── base # contains subdirectories of each database subdirectory

│ ├── 1

│ │ ├── 112

├── global # contains subdirectories of the cluster scope table, such as pg_database

│ ├── 1136

│ ├── 1136_fsm

│ ├── 1136_vm

.

│ ├── 6100_vm

│ ├── 6114

│ ├── 6115

│ ├── pg_control

│ ├── pg_filenode.map

│ └── pg_internal.init

├── pg_commit_ts # subdirectory containing transaction commit timestamp data

├── pg_dynshmem # contains subdirectories of files used by the dynamic shared memory subsystem

├── pg_hba.conf

├── pg_ident.conf # contains subdirectories of files used by the dynamic shared memory subsystem

├── pg_logical # subdirectories containing logically decoded state data

│ ├── mappings

│ ├── replorigin_checkpoint

│ └── snapshots

├── pg_multixact # subdirectories containing multiple transaction state data (for shared row locks)

│ ├── members

│ │ └── 0000

│ └── offsets

│ └── 0000

├── pg_notify # subdirectories containing LISTEN / NOTIFY status data

│ └── 0000

├── pg_replslot # subdirectory containing replication slot data

├── pg_serial # subdirectory containing information about committed serializable transactions

├── pg_snapshots # contains subdirectories for exported snapshots

├── pg_stat # subdirectory containing persistent files of the statistics subsystem

│ ├── db_0.stat

│ ├── db_13231.stat

│ ├── db_16384.stat

│ └── global.stat

├── pg_stat_tmp # subdirectory, which contains temporary files for the statistics subsystem

├── pg_subtrans # subdirectories containing subtransaction status data

│ └── 0000

├── pg_tblspc # subdirectories containing tablespace symbolic links

├── pg_twophase # subdirectory containing status files for prepared things

├── PG_VERSION # File containing the major version number of PostgreSQL

├── pg_wal # subdirectory containing WAL (prepaid log) files

│ ├── 000000010000000000000002

│ └── archive_status

├── pg_xact # subdirectory containing transaction commit status data

│ └── 0000

├── postgresql.auto.conf # files used to store configuration parameters set by ALTER SYSTEM

├── postgresql.conf

├── postmaster.opts # file that records the command line options that the server last started

└── tree.txt

Current_logfiles records the file of the log file currently written by the log collector

Postmaster.pid a locked file that records the current postmaster process ID (PID), cluster data directory path, postmaster start timestamp, port number, Unix domain socket directory path (empty on Windows), the first valid listen_address (IP address or *, or empty if not listening on TCP) and shared memory segment ID (the file does not exist after the server is shut down)

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.