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 +

--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs