Shulou(Shulou.com)05/31 Report--

This article mainly explains "What data does Postgresql database have". The explanation content in this article is simple and clear, easy to learn and understand. Please follow the idea of Xiaobian to study and learn "What data does Postgresql database have" together.

directory purpose base subdirectory for each database global subdirectory containing cluster-wide tables, such as pg_databasepg_commit_ts subdirectory containing transaction commit timestamp data pg_xact subdirectory containing transaction commit status data pg_dynshmem

pg_logical subdirectory containing files used by the dynamic shared memory subsystem

Subdirectory pg_multixact containing state data for logical replication

Subdirectories containing multi-transaction state data (user-shared row locks) pg_notify

Subdirectory pg_repslot containing LISTEN/NOTIFY status data

pg_serial subdirectory containing replication slot data

Subdirectory pg_snapshots containing committed serializable transaction information

Subdirectory pg_stat containing snapshots everywhere

Subdirectory pg_stat_tmp containing permanent files for the statistics subsystem

Subdirectory pg_subtrans containing temporary files for the statistics subsystem

Subdirectory pg_tblspc containing subtransaction state data

Subdirectory pg_twophase containing symbolic links to tablespaces

Subdirectory pg_wal for preparing transaction state files

Save pre-written log pg_xact

Record transaction commit status data file

use

pg_version

pg database major version number file pg_hba.conf

Client authentication control file postgresql.conf

parameter file postgresql.auto.conf

parameter file, save only the parameter postmaster.opts modified by alter system command

Record the command line parameters used when the server was last started Thank you for reading, the above is the content of "Postgresql database has what data", after learning this article, I believe everyone has a deeper understanding of what data Postgresql database has, the specific use of the situation also needs to be verified by practice. Here is, Xiaobian will push more articles related to knowledge points for everyone, welcome to pay attention!

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.