Thread: BUG #16287: 'Server doesn't listen' after setting 'timezone' to "America/Detroit US/Michigan"
BUG #16287: 'Server doesn't listen' after setting 'timezone' to "America/Detroit US/Michigan"
From
PG Bug reporting form
Date:
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
Re: BUG #16287: 'Server doesn't listen' after setting 'timezone' to"America/Detroit US/Michigan"
From
Jeff Janes
Date:
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