| From: | James Cloos <cloos(at)jhcloos(dot)com> |
|---|---|
| To: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
| Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: localtime ? |
| Date: | 2015-06-15 17:55:02 |
| Message-ID: | m38ubkc0w9.fsf@carbon.jhcloos.org |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
The full results on that cluster of select * from pg_settings where name =
'TimeZone' is:
-[ RECORD 1 ]---------------------------------------------------------------
name | TimeZone
setting | localtime
unit |
category | Client Connection Defaults / Locale and Formatting
short_desc | Sets the time zone for displaying and interpreting time stamps.
extra_desc |
context | user
vartype | string
source | configuration file
min_val |
max_val |
enumvals |
boot_val | GMT
reset_val | localtime
sourcefile | /etc/postgresql/9.3/main/postgresql.conf
sourceline | 508
The 9.3 vs 9.4 in sourcefile is the only difference between the two
clusters on that box.
-JimC
--
James Cloos <cloos(at)jhcloos(dot)com> OpenPGP: 0x997A9F17ED7DAEA6
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Adrian Klaver | 2015-06-15 18:25:07 | Re: localtime ? |
| Previous Message | Anton | 2015-06-15 15:05:59 | Re: pg_last_xact_replay_timestamp lies |