| 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 9.3 workload consumes all of memory and swap
On pgsql-hackers
- Re: SELECT Query taking 200 ms on PostgreSQL compared to 4 ms on Oracle after migration.
- Re: recovery_target immediate timestamp
- Re: Performance Evaluation of Result Cache by using TPC-DS
- Re: [BUG?] SET TIME ZONE doesn't work with abbreviations
- RE: [PATCH] New default role allowing to change per-role/database settings