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

Hello

Everything is ended well.

Few tests has been made with the 9.2.0 but unfortunatly it fails, I supposed due to my own fault.
Others (better?) with 9.2.1 are working fine :
I add on folders (mainly tablespace and backup) RW access to postgres and networkService

Thanks for the informations.

Raphael

De : Dave Page [mailto:dpage(at)pgadmin(dot)org]
Envoyé : lundi 24 septembre 2012 17:43
À : PETIT Raphael
Cc : pgsql-bugs(at)postgresql(dot)org
Objet : Re: [BUGS] 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<mailto: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<mailto: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

AVIS : Ce courrier et ses pieces jointes sont destines a leur seul destinataire et peuvent contenir des informations confidentielles appartenant a bioMerieux. Si vous n'etes pas destinataire, vous etes informe que toute lecture, divulgation, ou reproduction de ce message et des pieces jointes est strictement interdite. Si vous avez recu ce message par erreur merci d'en prevenir l'expediteur et de le detruire, ainsi que ses pieces jointes.
NOTICE: This message and attachments are intended only for the use of their addressee and may contain confidential information belonging to bioMerieux. If you are not the intended recipient, you are hereby notified that any reading, dissemination, distribution, or copying of this message, or any attachment, is strictly prohibited. If you have received this message in error, please notify the original sender immediately and delete this message, along with any attachments.