Re: BUG #14373: PostgreSQL Service is seems to be "Stopped" after Jan 19, 2038.

On Sat, Oct 15, 2016 at 03:38:32AM +0000, kensuke.nakam@gmail.com wrote:
> The following bug has been logged on the website:
>
> Bug reference:      14373
> Logged by:          kensuke
> Email address:      kensuke.nakam@gmail.com
> PostgreSQL version: 9.3.5
> Operating system:   Windows 8
> Description:
>
> If the time of OS is set to a time later than Jun 19, 2038,
> the status of PostgreSQL Service is "Stopped" by checking Service Manager of
> Task Manager.
>
> If I try to start PostgreSQL Service manually on Service Manager, the status
> is changed to "starting", but it is returned to "stopped" after 5 seconds.
>
> In this case,some applications can access PostgreSQL database.So I consider
> PostgreSQL Service might be running in the background.
>
> Additional comment: This computer has 2 PostgreSQL Services(PostgreSQL
> Service and PostgreSQL-Slave) to backup database.
>
> Could you tell me why PostgreSQL is not running on Service Manager ?
> And is this problem fixed in later version of PostgreSQL ?

There is nothing inherent in Postgres that would prevent it from working
past 2038.  Seems the problem is either in the installer or in Windows.

--
  Bruce Momjian  <bruce@momjian.us>        http://momjian.us
  EnterpriseDB                             http://enterprisedb.com

+ As you are, so once was I.  As I am, so you will be. +
+                      Ancient Roman grave inscription +