Re: BUG #12858: Server crash on upgrade due to invalid timezoneset syntax

The server does work when restarted. I was looking at this more from the
perspective of it being unexpected/undocumented behavior for a minor
version upgrade.

Thank you for the tips on the re-index.

On Thu, Mar 12, 2015 at 4:19 PM, John R Pierce <pierce(at)hogranch(dot)com> wrote:

> On 3/12/2015 1:08 PM, tpoland(at)engineyard(dot)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
>
>

--
*Tyler Poland* | Data Support Lead | w: (415) 624-8448 | s: tyler.poland
| t: @tylerpoland
[image: Inline image 1]