Re: BUG #7564: window installer of Postgresql 9.2 and service configuration

On Mon, Sep 24, 2012 at 12:37 PM, <raphael(dot)petit(at)biomerieux(dot)com> wrote:

> The following bug has been logged on the website:
>
> Bug reference: 7564
> Logged by: petitr
> Email address: raphael(dot)petit(at)biomerieux(dot)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