Content #
The main files are as follows:
- postgresql.conf
the main configuration file, used by default when the service is started.
- postgresql.auto.conf
the automatically included configuration file used to store dynamically changed settings via SQL instructions.
- pg_hba.conf
the HBA file that provides the configuration regarding available database connections.
- PG_VERSION
a text file that contains the major version number (useful when inspecting the directory to understand which version of the cluster has managed the PGDATA directory).
- postmaster.pid
the PID of the postmaster process, the first launched process in the cluster.
The main directories available in PGDATA are as follows:
- base
a directory that contains all the users’ data, including databases, tables, and other objects.
- global
a directory containing cluster-wide objects.
- pg_wal
the directory containing the WAL files.
- pg_stat and pg_stat_tmp
the storage of permanent and temporary statistical information about the status and health of the cluster.