Thread: BUG #16287: 'Server doesn't listen' after setting 'timezone' to "America/Detroit US/Michigan"

The following bug has been logged on the website:

Bug reference:      16287
Logged by:          Felix Jetzinger jun.
Email address:      felix.jetzinger@alpinemetaltech.com
PostgreSQL version: Unsupported/Unknown
Operating system:   Windows 7 Embedded Standard SP1
Description:

Hello,
we're using PostgreSQL 9.3 on our Windows 7 Embedded computers. Our new
system goes to Michigin in the USA and so I want to adjust the timezone to
it. 
Unfortunately everytime after adjusting the 'timezone' parameter in the
'postgresql.conf' to "America/Detroit US/Michigan" regarding the table
'Table B-6. Time Zone Names for Setting timezone' from your website I can't
connect to the server anymore. Same problem with "America/New_York EST5EDT
SystemV/EST5EDT US/Eastern". Out default setting for it is "UTC" which is
working fine. I also tried "Etc/GMT-5" and "America/Bogota" and they are
working but I need the time settings for Michigan because of ther
daylight-savings time rule. 

Please help me out why the setting "America/Detroit US/Michigan" isn't
working or how I can make it work.

Thank you,
Felix


On Fri, Mar 6, 2020 at 1:32 PM PG Bug reporting form <noreply@postgresql.org> wrote:
The following bug has been logged on the website:

Bug reference:      16287
Logged by:          Felix Jetzinger jun.
Email address:      felix.jetzinger@alpinemetaltech.com
PostgreSQL version: Unsupported/Unknown
Operating system:   Windows 7 Embedded Standard SP1
Description:       

Hello,
we're using PostgreSQL 9.3 on our Windows 7 Embedded computers. Our new
system goes to Michigin in the USA and so I want to adjust the timezone to
it.
Unfortunately everytime after adjusting the 'timezone' parameter in the
'postgresql.conf' to "America/Detroit US/Michigan" regarding the table
'Table B-6. Time Zone Names for Setting timezone' from your website I can't
connect to the server anymore.

You should read the documentation for the version of PostgreSQL you are using.  Table B-6 disappeared a very long time ago (in version 8.2).

It is just spelled "America/Detroit", or "US/Michigan", not both in the same string.

Cheers,

Jeff