Обсуждение: BUG #7564: window installer of Postgresql 9.2 and service configuration

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==