WIN
PostgreSQL - Windows
PostgreSQL Global Development GroupLogs
C:\Program Files\PostgreSQL\<version>\data\log\PostgreSQL
3 log locations · Windows, Linux
PostgreSQL Global Development Group
- From SQL: SHOW log_directory; gives the live path.
- psql client keeps no log. Record a session with: psql -d mydatabase -U username -L /path/to/log.log
Where PostgreSQL keeps its logs
PostgreSQL logs to C:\Program Files\PostgreSQL\<version>\data\log\ on Windows.
PostgreSQL logs to /var/log/postgresql/postgresql-<version>-main.log on Linux. 1 other Linux log location is recorded below.
Paths are printed exactly as PostgreSQL writes them. Environment variables like %LOCALAPPDATA% and $XDG_STATE_HOME are never expanded, so a path can be pasted straight into a shell. Where a path differs between installer types or shipping flavours, each one is racked as its own card below - why that happens.
LNX
PostgreSQL - Linux
PostgreSQL Global Development GroupUbuntu/Debian
/var/log/postgresql/postgresql-<version>-main.logRHEL/CentOS
/var/lib/pgsql/<version>/data/log/