May 2018
Intermediate to advanced
576 pages
30h 25m
English
Once you've located the data directory, you can look for the files that comprise the PostgreSQL database server. The layout is as follows:
| Subdirectory | Purpose |
| base | This is the main table storage. Beneath this directory, each database has its own directory, within which are the files for each database table or index. |
| global | Here are the tables that are shared across all databases, including the list of databases. |
| pg_commit_ts | Here we store transaction commit timestamp data (from 9.5 onwards). |
| pg_dynshmem | This includes dynamic shared memory information (from 9.4 onwards). |
| pg_logical | This includes the logical decoding status data. |
| pg_multixact | This includes files used for shared row-level locks. |
| pg_notify | This ... |