PostgreSQL数据库的物理存储结构主要是指硬盘上存储的文件，包括：数据文件、日志文件、参数文件、控制文件、WAL预写日志文件等等。下面重点讨论一下PostgreSQL的服务器日志文件。
| 视频讲解如下 |
|---|
|
【赵渝强老师】PostgreSQL的服务器日志文件 |
通过使用pg_ctl命令启动PostgreSQL数据库实例时，通过指定-l参数来指定PostgreSQL的服务器日志文件。如果不知道该日志文件，错误可能会输出到cmd前台。下图展示了在启动数据库服务器时，使用“-l”参数生成的服务器日志文件，它记录了数据库实例在启动和关闭过程中的重要信息。
服务器日志文件的内容如下：
2024-12-02 16:51:10.955 CST [87485] LOG: starting PostgreSQL 15.3 on x86_64-pc-linux-gnu,
compiled by gcc (GCC) 4.8.5 20150623 (Red Hat 4.8.5-44),
64-bit
2024-12-02 16:51:10.956 CST [87485] LOG: listening on IPv4 address "0.0.0.0", port 5432
2024-12-02 16:51:10.956 CST [87485] LOG: listening on IPv6 address "::", port 5432
2024-12-02 16:51:10.958 CST [87485] LOG: listening on Unix socket "/tmp/.s.PGSQL.5432"
2024-12-02 16:51:10.965 CST [87488] LOG: database system was shut down at 2024-11-28 09:35:18 CST
2024-12-02 16:51:10.982 CST [87485] LOG: database system is ready to accept connections
2024-12-02 16:51:15.919 CST [87485] LOG: received fast shutdown request
2024-12-02 16:51:15.920 CST [87485] LOG: aborting any active transactions
2024-12-02 16:51:15.921 CST [87485] LOG: background worker "logical replication launcher" (PID 87491)
exited with exit code 1
2024-12-02 16:51:15.922 CST [87486] LOG: shutting down
2024-12-02 16:51:15.922 CST [87486] LOG: checkpoint starting: shutdown immediate
2024-12-02 16:51:15.927 CST [87486] LOG: checkpoint complete: wrote 3 buffers (0.0%);
0 WAL file(s) added, 0 removed, 0 recycled; write=0.002 s,
sync=0.001 s, total=0.006 s; sync files=2, longest=0.001 s,
average=0.001 s; distance=0 kB, estimate=0 kB
2024-12-02 16:51:15.932 CST [87485] LOG: database system is shut down
