Обсуждение: BUG #14373: PostgreSQL Service is seems to be "Stopped" after Jan 19, 2038.

Поиск
Список
Период
Сортировка

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

От
kensuke.nakam@gmail.com
Дата:
VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJz
aXRlOgoKQnVnIHJlZmVyZW5jZTogICAgICAxNDM3MwpMb2dnZWQgYnk6ICAg
ICAgICAgIGtlbnN1a2UKRW1haWwgYWRkcmVzczogICAgICBrZW5zdWtlLm5h
a2FtQGdtYWlsLmNvbQpQb3N0Z3JlU1FMIHZlcnNpb246IDkuMy41Ck9wZXJh
dGluZyBzeXN0ZW06ICAgV2luZG93cyA4IApEZXNjcmlwdGlvbjogICAgICAg
IAoKSWYgdGhlIHRpbWUgb2YgT1MgaXMgc2V0IHRvIGEgdGltZSBsYXRlciB0
aGFuIEp1biAxOSwgMjAzOCwgDQp0aGUgc3RhdHVzIG9mIFBvc3RncmVTUUwg
U2VydmljZSBpcyAiU3RvcHBlZCIgYnkgY2hlY2tpbmcgU2VydmljZSBNYW5h
Z2VyIG9mClRhc2sgTWFuYWdlci4NCg0KSWYgSSB0cnkgdG8gc3RhcnQgUG9z
dGdyZVNRTCBTZXJ2aWNlIG1hbnVhbGx5IG9uIFNlcnZpY2UgTWFuYWdlciwg
dGhlIHN0YXR1cwppcyBjaGFuZ2VkIHRvICJzdGFydGluZyIsIGJ1dCBpdCBp
cyByZXR1cm5lZCB0byAic3RvcHBlZCIgYWZ0ZXIgNSBzZWNvbmRzLg0KDQpJ
biB0aGlzIGNhc2Usc29tZSBhcHBsaWNhdGlvbnMgY2FuIGFjY2VzcyBQb3N0
Z3JlU1FMIGRhdGFiYXNlLlNvIEkgY29uc2lkZXIKUG9zdGdyZVNRTCBTZXJ2
aWNlIG1pZ2h0IGJlIHJ1bm5pbmcgaW4gdGhlIGJhY2tncm91bmQuDQoNCkFk
ZGl0aW9uYWwgY29tbWVudDogVGhpcyBjb21wdXRlciBoYXMgMiBQb3N0Z3Jl
U1FMIFNlcnZpY2VzKFBvc3RncmVTUUwKU2VydmljZSBhbmQgUG9zdGdyZVNR
TC1TbGF2ZSkgdG8gYmFja3VwIGRhdGFiYXNlLg0KDQpDb3VsZCB5b3UgdGVs
bCBtZSB3aHkgUG9zdGdyZVNRTCBpcyBub3QgcnVubmluZyBvbiBTZXJ2aWNl
IE1hbmFnZXIgPyANCkFuZCBpcyB0aGlzIHByb2JsZW0gZml4ZWQgaW4gbGF0
ZXIgdmVyc2lvbiBvZiBQb3N0Z3JlU1FMID8KCg==

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

От
Bruce Momjian
Дата:
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 +