On 06/15/2015 11:44 AM, James Cloos wrote:
"AK" == Adrian Klaver <adrian.klaver@xxxxxxxxxxx> 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@xxxxxxxxxxxxxxxxxx
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@xxxxxxxxxxx
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
