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.
- 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
- 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