| 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
- Spring jpa send "SET SESSION TIME ZONE UTC" on every database session
- How does PostgreSQL know if I currently use DST in TimeZone 'CET'?
- Postgres highload. 20000 requests per min causes resource request timed out
- Postgres 9.3 workload consumes all of memory and swap
- PostgreSQL query written millions of times to the log file when using temp files