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