Обсуждение: 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 +