Re: BUG #12858: Server crash on upgrade due to invalid timezoneset syntax - Mailing list pgsql-bugs

From John R Pierce
Subject Re: BUG #12858: Server crash on upgrade due to invalid timezoneset syntax
Date
Msg-id 5501F4D2.2080302@hogranch.com
Whole thread Raw
In response to BUG #12858: Server crash on upgrade due to invalid timezoneset syntax  (tpoland@engineyard.com)
Responses Re: BUG #12858: Server crash on upgrade due to invalid timezoneset syntax  (Tyler Poland <tpoland@engineyard.com>)
List pgsql-bugs
On 3/12/2015 1:08 PM, tpoland@engineyard.com wrote:
> Immediately after upgrading from 9.1.9 to 9.1.15 the server (still running
> 9.1.9) crashes with the error:
>
> 2015-03-12 18:39:55.585 UTC,,,13721,,5500d157.3599,9,,2015-03-11 23:35:51
> UTC,,0,FATAL,22023,"invalid number for time zone offset in time zone file
> ""Default"", line 57",,,,,,,,,""
>
> Reviewing the Default timezoneset file reveals that it has changed

does the server work when you restart it?

replacing files of a running service is always a sketchy thing.

you should also read the release notes for 9.1.15, .14, and .11 as there
are issues which may need addressing via REINDEX and such, if you use
certain index types.

http://www.postgresql.org/docs/current/static/release-9-1-11.html
http://www.postgresql.org/docs/current/static/release-9-1-14.html
http://www.postgresql.org/docs/current/static/release-9-1-15.html



--
john r pierce                                      37N 122W
somewhere on the middle of the left coast

pgsql-bugs by date:

Previous
From: tpoland@engineyard.com
Date:
Subject: BUG #12858: Server crash on upgrade due to invalid timezoneset syntax
Next
From: Tyler Poland
Date:
Subject: Re: BUG #12858: Server crash on upgrade due to invalid timezoneset syntax