pg.ddx.io  pgsql-bugs@postgresql.org mailing list archive  
help / color / mirror / Atom feed
BUG #16287: 'Server doesn't listen' after setting 'timezone' to "America/Detroit US/Michigan"
2+ messages / 2 participants
[nested] [flat]

* BUG #16287: 'Server doesn't listen' after setting 'timezone' to "America/Detroit US/Michigan"
@ 2020-03-06 18:31  PG Bug reporting form <noreply@postgresql.org>
  0 siblings, 1 reply; 2+ messages in thread

From: PG Bug reporting form @ 2020-03-06 18:31 UTC (permalink / raw)
  To: pgsql-bugs@lists.postgresql.org; +Cc: felix.jetzinger@alpinemetaltech.com

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



^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: BUG #16287: 'Server doesn't listen' after setting 'timezone' to "America/Detroit US/Michigan"
@ 2020-03-06 19:09  Jeff Janes <jeff.janes@gmail.com>
  parent: PG Bug reporting form <noreply@postgresql.org>
  0 siblings, 0 replies; 2+ messages in thread

From: Jeff Janes @ 2020-03-06 19:09 UTC (permalink / raw)
  To: felix.jetzinger@alpinemetaltech.com, pgsql-bugs <pgsql-bugs@lists.postgresql.org>

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

^ permalink  raw  reply  [nested|flat] 2+ messages in thread


end of thread, other threads:[~2020-03-06 19:09 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2020-03-06 18:31 BUG #16287: 'Server doesn't listen' after setting 'timezone' to "America/Detroit US/Michigan" PG Bug reporting form <noreply@postgresql.org>
2020-03-06 19:09 ` Jeff Janes <jeff.janes@gmail.com>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox