Nick Martens <nick80(at)xs4all(dot)nl> writes:
> Jan 10 17:14:40 dndwebdev01 postgres[17374]: [1-1] ERROR: unrecognized time
> zone name: "America/Indiana"
> Jan 10 17:14:40 dndwebdev01 kernel: pid 17374 (postgres), uid 70: exited on
> signal 11 (core dumped)
Doesn't happen for me:
regression=# set timezone = 'America/Indiana';
ERROR: unrecognized time zone name: "America/Indiana"
regression=# set timezone = 'America/Indiana';
ERROR: unrecognized time zone name: "America/Indiana"
regression=# set timezone = 'America/Indiana';
ERROR: unrecognized time zone name: "America/Indiana"
regression=#
(This is with 8.0.6, but I don't see any related fixes in the CVS logs.)
Can you get a stack trace from the core dump?
regards, tom lane