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(dot)nakam(at)gmail(dot)com wrote:
> The following bug has been logged on the website:
>
> Bug reference: 14373
> Logged by: kensuke
> Email address: kensuke(dot)nakam(at)gmail(dot)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(at)momjian(dot)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 +