| Type: | string |
| Default: | GMT |
| Context: | sighup |
| Restart: | false |
Sets the time zone used for timestamps written in the server log. Unlike TimeZone, this value is cluster-wide, so that all sessions will report timestamps consistently. The built-in default is GMT, but that is typically overridden in postgresql.conf; initdb will install a setting there corresponding to its system environment. See datatype-timezones for more information. This parameter can only be set in the postgresql.conf file or on the server command line.
Recommendations
To avoid confusion, it's often useful to log to the timezone where the DBA or sysadmin lives.
On StackOverflow
- How does PostgreSQL know if I currently use DST in TimeZone 'CET'?
- Spring jpa send "SET SESSION TIME ZONE UTC" on every database session
- Time zone names with identical properties yield different result when applied to timestamp
- PostgreSQL query written millions of times to the log file when using temp files
- Postgres highload. 20000 requests per min causes resource request timed out