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

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|

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

PG Doc comments form
The following bug has been logged on the website:

Bug reference:      16287
Logged by:          Felix Jetzinger jun.
Email address:      [hidden email]
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

Reply | Threaded
Open this post in threaded view
|

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

Jeff Janes
On Fri, Mar 6, 2020 at 1:32 PM PG Bug reporting form <[hidden email]> wrote:
The following bug has been logged on the website:

Bug reference:      16287
Logged by:          Felix Jetzinger jun.
Email address:      [hidden email]
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