Re: localtime ? - Mailing list pgsql-general

From Adrian Klaver
Subject Re: localtime ?
Date
Msg-id 557F2DBA.3050905@aklaver.com
Whole thread Raw
In response to Re: localtime ?  (James Cloos <cloos@jhcloos.com>)
List pgsql-general
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


pgsql-general by date:

Previous
From: James Cloos
Date:
Subject: Re: localtime ?
Next
From: Robert Haas
Date:
Subject: Re: [HACKERS] 9.4.1 -> 9.4.2 problem: could not access status of transaction 1