May 2018
Intermediate to advanced
576 pages
30h 25m
English
The server log is just a file that records messages from the server. Each message has a severity level, the most typical of them being LOG, though there are others, as shown in the following table:
| PostgreSQL severity | Meaning | Syslog severity | Windows Event Log |
| DEBUG 1 to DEBUG 5 | This comprises the internal diagnostics | DEBUG | INFORMATION |
| INFO | This is the command output for the user | INFO | INFORMATION |
| NOTICE | This is helpful information | NOTICE | INFORMATION |
| WARNING | This warns of likely problems | NOTICE | WARNING |
| ERROR | This is the current command that is aborted | WARNING | ERROR |
| LOG | This is useful for sysadmins | INFO | INFORMATION |
| FATAL | This is the event that disconnects one session only | ERR | ERROR |
| PANIC | This is the event that ... |