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

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