On 06/15/2015 11:44 AM, James Cloos wrote:
>>>>>> "AK" == Adrian Klaver <adrian.klaver@aklaver.com> writes:
>
> AK> So what is at line 508 in /etc/postgresql/9.3/main/postgresql.conf?
>
> timezone = 'localtime'
>
> That is the same in the 9.4 conf, where everything defaults to utc as I
> desire.
Went back to the beginning of the thread:
http://www.postgresql.org/message-id/m3616t3m5d.fsf@carbon.jhcloos.org
where you had:
"
But:
,----
| :; grep timezone /etc/postgresql/9.3/main/*
| /etc/postgresql/9.3/main/postgresql.conf:log_timezone = 'UTC'
| /etc/postgresql/9.3/main/postgresql.conf:timezone = 'UTC'
| /etc/postgresql/9.3/main/postgresql.conf:#timezone_abbreviations =
'Default' # Select the set of available time zone
| /etc/postgresql/9.3/main/postgresql.conf:
# share/timezonesets/.
"
So now I am lost:(
Also what is the timezone set to in the 9.4 cluster?
If nothing else, just change the timezone in the 9.3 cluster to 'UTC'.
>
> Those are Debian's default config files. As I wrote the diff between
> the not working /etc/postgresql/9.3/ snd the working /etc/postgresql/9.4/
> is only things like 9.3 vs 9.4 in path names, the port number and the
> addition in 9.4 of dynamic_shared_memory_type = mmap.
>
> Whatever caused this is not in the config files.
>
> -JimC
>
--
Adrian Klaver
adrian.klaver@aklaver.com