Обсуждение: BUG #7564: window installer of Postgresql 9.2 and service configuration
BUG #7564: window installer of Postgresql 9.2 and service configuration
От
raphael.petit@biomerieux.com
Дата:
The following bug has been logged on the website: Bug reference: 7564 Logged by: petitr Email address: raphael.petit@biomerieux.com PostgreSQL version: 9.2.0 Operating system: window = Description: = Hello, The window installer of Postgresql 9.2 configures the service with NT AUTHORITY\NetworkService. So the behavior has changed : rights need to be updated. No documentation can be found on this. I wonder if all this is OK? The url http://postgresql.1045698.n5.nabble.com/Minimising-windows-installer-passwo= rd-confusion-td5712177i20.html explains that --serviceaccount postgres can be used on the command line. Should I go on this way? Regards
On Mon, Sep 24, 2012 at 12:37 PM, <raphael.petit@biomerieux.com> wrote: > The following bug has been logged on the website: > > Bug reference: 7564 > Logged by: petitr > Email address: raphael.petit@biomerieux.com > PostgreSQL version: 9.2.0 > Operating system: window > Description: > > Hello, > > The window installer of Postgresql 9.2 configures the service with NT > AUTHORITY\NetworkService. > > So the behavior has changed : rights need to be updated. No documentation > can be found on this. > > I wonder if all this is OK? > The lack of documentation is an oversight, which I'll fix for the next release (which will be 9.2.2 now unfortunately). It is supposed to work that way now though. > > The url > > http://postgresql.1045698.n5.nabble.com/Minimising-windows-installer-password-confusion-td5712177i20.html > explains that --serviceaccount postgres can be used on the command line. > > Should I go on this way? > Only if you have a specific need to use a different service account (you'll know if that's the case for you). For the vast majority of people, NetworkService should be fine. -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EnterpriseDB UK: http://www.enterprisedb.com The Enterprise PostgreSQL Company
SGVsbG8NCg0KRXZlcnl0aGluZyBpcyBlbmRlZCB3ZWxsLg0KDQpGZXcgdGVzdHMgaGFzIGJlZW4g bWFkZSB3aXRoIHRoZSA5LjIuMCBidXQgdW5mb3J0dW5hdGx5IGl0IGZhaWxzLCBJIHN1cHBvc2Vk IGR1ZSB0byBteSBvd24gZmF1bHQuDQpPdGhlcnMgKGJldHRlcj8pIHdpdGggOS4yLjEgYXJlIHdv cmtpbmcgZmluZSA6DQpJIGFkZCBvbiBmb2xkZXJzIChtYWlubHkgdGFibGVzcGFjZSBhbmQgYmFj a3VwKSBSVyBhY2Nlc3MgdG8gcG9zdGdyZXMgYW5kIG5ldHdvcmtTZXJ2aWNlDQoNClRoYW5rcyBm b3IgdGhlIGluZm9ybWF0aW9ucy4NCg0KUmFwaGFlbA0KDQpEZSA6IERhdmUgUGFnZSBbbWFpbHRv OmRwYWdlQHBnYWRtaW4ub3JnXQ0KRW52b3nDqSA6IGx1bmRpIDI0IHNlcHRlbWJyZSAyMDEyIDE3 OjQzDQrDgCA6IFBFVElUIFJhcGhhZWwNCkNjIDogcGdzcWwtYnVnc0Bwb3N0Z3Jlc3FsLm9yZw0K T2JqZXQgOiBSZTogW0JVR1NdIEJVRyAjNzU2NDogd2luZG93IGluc3RhbGxlciBvZiBQb3N0Z3Jl c3FsIDkuMiBhbmQgc2VydmljZSBjb25maWd1cmF0aW9uDQoNCg0KT24gTW9uLCBTZXAgMjQsIDIw MTIgYXQgMTI6MzcgUE0sIDxyYXBoYWVsLnBldGl0QGJpb21lcmlldXguY29tPG1haWx0bzpyYXBo YWVsLnBldGl0QGJpb21lcmlldXguY29tPj4gd3JvdGU6DQpUaGUgZm9sbG93aW5nIGJ1ZyBoYXMg YmVlbiBsb2dnZWQgb24gdGhlIHdlYnNpdGU6DQoNCkJ1ZyByZWZlcmVuY2U6ICAgICAgNzU2NA0K TG9nZ2VkIGJ5OiAgICAgICAgICBwZXRpdHINCkVtYWlsIGFkZHJlc3M6ICAgICAgcmFwaGFlbC5w ZXRpdEBiaW9tZXJpZXV4LmNvbTxtYWlsdG86cmFwaGFlbC5wZXRpdEBiaW9tZXJpZXV4LmNvbT4N ClBvc3RncmVTUUwgdmVyc2lvbjogOS4yLjANCk9wZXJhdGluZyBzeXN0ZW06ICAgd2luZG93DQpE ZXNjcmlwdGlvbjoNCg0KSGVsbG8sDQoNClRoZSB3aW5kb3cgaW5zdGFsbGVyIG9mIFBvc3RncmVz cWwgOS4yIGNvbmZpZ3VyZXMgdGhlIHNlcnZpY2Ugd2l0aCBOVA0KQVVUSE9SSVRZXE5ldHdvcmtT ZXJ2aWNlLg0KDQpTbyB0aGUgYmVoYXZpb3IgaGFzIGNoYW5nZWQgOiByaWdodHMgbmVlZCB0byBi ZSB1cGRhdGVkLiBObyBkb2N1bWVudGF0aW9uDQpjYW4gYmUgZm91bmQgb24gdGhpcy4NCg0KSSB3 b25kZXIgaWYgYWxsIHRoaXMgaXMgT0s/DQoNClRoZSBsYWNrIG9mIGRvY3VtZW50YXRpb24gaXMg YW4gb3ZlcnNpZ2h0LCB3aGljaCBJJ2xsIGZpeCBmb3IgdGhlIG5leHQgcmVsZWFzZSAod2hpY2gg d2lsbCBiZSA5LjIuMiBub3cgdW5mb3J0dW5hdGVseSkuIEl0IGlzIHN1cHBvc2VkIHRvIHdvcmsg dGhhdCB3YXkgbm93IHRob3VnaC4NCg0KDQpUaGUgdXJsDQpodHRwOi8vcG9zdGdyZXNxbC4xMDQ1 Njk4Lm41Lm5hYmJsZS5jb20vTWluaW1pc2luZy13aW5kb3dzLWluc3RhbGxlci1wYXNzd29yZC1j b25mdXNpb24tdGQ1NzEyMTc3aTIwLmh0bWwNCiBleHBsYWlucyB0aGF0IC0tc2VydmljZWFjY291 bnQgcG9zdGdyZXMgY2FuIGJlIHVzZWQgb24gdGhlIGNvbW1hbmQgbGluZS4NCg0KU2hvdWxkIEkg Z28gb24gdGhpcyB3YXk/DQoNCk9ubHkgaWYgeW91IGhhdmUgYSBzcGVjaWZpYyBuZWVkIHRvIHVz ZSBhIGRpZmZlcmVudCBzZXJ2aWNlIGFjY291bnQgKHlvdSdsbCBrbm93IGlmIHRoYXQncyB0aGUg Y2FzZSBmb3IgeW91KS4gRm9yIHRoZSB2YXN0IG1ham9yaXR5IG9mIHBlb3BsZSwgTmV0d29ya1Nl cnZpY2Ugc2hvdWxkIGJlIGZpbmUuDQoNCi0tDQpEYXZlIFBhZ2UNCkJsb2c6IGh0dHA6Ly9wZ3Nu YWtlLmJsb2dzcG90LmNvbQ0KVHdpdHRlcjogQHBnc25ha2UNCg0KRW50ZXJwcmlzZURCIFVLOiBo dHRwOi8vd3d3LmVudGVycHJpc2VkYi5jb20NClRoZSBFbnRlcnByaXNlIFBvc3RncmVTUUwgQ29t cGFueQ0KCkFWSVMgOiBDZSBjb3VycmllciBldCBzZXMgcGllY2VzIGpvaW50ZXMgc29udCBkZXN0 aW5lcyBhIGxldXIgc2V1bCBkZXN0aW5hdGFpcmUgZXQgcGV1dmVudCBjb250ZW5pciBkZXMgaW5m b3JtYXRpb25zIGNvbmZpZGVudGllbGxlcyBhcHBhcnRlbmFudCBhIGJpb01lcmlldXguIFNpIHZv dXMgbidldGVzIHBhcyBkZXN0aW5hdGFpcmUsIHZvdXMgZXRlcyBpbmZvcm1lIHF1ZSB0b3V0ZSBs ZWN0dXJlLCBkaXZ1bGdhdGlvbiwgb3UgcmVwcm9kdWN0aW9uIGRlIGNlIG1lc3NhZ2UgZXQgZGVz IHBpZWNlcyBqb2ludGVzIGVzdCBzdHJpY3RlbWVudCBpbnRlcmRpdGUuIFNpIHZvdXMgYXZleiBy ZWN1IGNlIG1lc3NhZ2UgcGFyIGVycmV1ciBtZXJjaSBkJ2VuIHByZXZlbmlyIGwnZXhwZWRpdGV1 ciBldCBkZSBsZSBkZXRydWlyZSwgYWluc2kgcXVlIHNlcyBwaWVjZXMgam9pbnRlcy4KTk9USUNF OiBUaGlzIG1lc3NhZ2UgYW5kIGF0dGFjaG1lbnRzIGFyZSBpbnRlbmRlZCBvbmx5IGZvciB0aGUg dXNlIG9mIHRoZWlyIGFkZHJlc3NlZSBhbmQgbWF5IGNvbnRhaW4gY29uZmlkZW50aWFsIGluZm9y bWF0aW9uIGJlbG9uZ2luZyB0byBiaW9NZXJpZXV4LiBJZiB5b3UgYXJlIG5vdCB0aGUgaW50ZW5k ZWQgcmVjaXBpZW50LCB5b3UgYXJlIGhlcmVieSBub3RpZmllZCB0aGF0IGFueSByZWFkaW5nLCBk aXNzZW1pbmF0aW9uLCBkaXN0cmlidXRpb24sIG9yIGNvcHlpbmcgb2YgdGhpcyBtZXNzYWdlLCBv ciBhbnkgYXR0YWNobWVudCwgaXMgc3RyaWN0bHkgcHJvaGliaXRlZC4gSWYgeW91IGhhdmUgcmVj ZWl2ZWQgdGhpcyBtZXNzYWdlIGluIGVycm9yLCBwbGVhc2Ugbm90aWZ5IHRoZSBvcmlnaW5hbCBz ZW5kZXIgaW1tZWRpYXRlbHkgYW5kIGRlbGV0ZSB0aGlzIG1lc3NhZ2UsIGFsb25nIHdpdGggYW55 IGF0dGFjaG1lbnRzLgoKCg==