Postgres service user keeps losing password - Mailing list pgsql-admin

From Karim Mardhani
Subject Postgres service user keeps losing password
Date
Msg-id 003801c5876e$6a40ef80$0200a8c0@ipsolution1
Whole thread Raw
List pgsql-admin
Hi All:
 
I am having an interesting problem with the user which starts postmaster as service.
 
I am using postgres 8.0.1 as backend to my stand alone windows application.  My installation program installs postgres in silent mode and sets it to start as windows service.  Before installing postgres my installation program creates a user by running following script:
 
net user /add /y postgres mypassword /EXPIRES:NEVER /COMMENT:"PostgreSQL Service Account" /FULLNAME:"Postgres Service Account"
ntrights -u postgres +r SeServiceLogonRight
ntrights -u postgres +r SeNetworkLogonRight
ntrights -u postgres +r SeInteractiveLogonRight
 
 After creating the user the installation program installs postgres as windows service by using following command:
 
msiexec /i postgresql-8.0-int.msi /qb! INTERNALLAUNCH=1 ADDLOCAL=server,psql SERVICEDOMAIN=%COMPUTERNAME% SERVICEPASSWORD=mypassword SERVICENAME=pgdb SUPERPASSWORD=supperpassword PERMITREMOTE=1
 
So this works fine till the end user actually power cycles the PC rather than shutting it down properly from the start menu.  Basically when the windows starts up after the power cycle the postgres service doesn't start.  The error it gives is 1069 "logon failure".  The only way to fix this is to reset the passward for the user "postgres" to "mypassword" and after that every thing works fine till next power cycle happens.  This has been seen on both windows 2000 and windows xp.  Also I can't even use NET USER command to reset the password.  The password must be reset from "users and password" GUI.
 
So the question I have is why a power cycle causes the system to lose the passward for this user?  It doesn't happen to any other user.  There are quite a few other users in the system.  Also why can't "net user" utility be used to reset the password.  Does anybody see any thing obvious with the way installation program creates the user?
 
Any help in this regard would greatly appreciated.
 
Thanks
 
Karim

pgsql-admin by date:

Previous
From: "Joel Fradkin"
Date:
Subject: got my odbc working(re-loaded mdac as well as postgres) but it started working after I added a dsn (not using a dsn connection though so odd)
Next
From: Devrim GUNDUZ
Date:
Subject: Re: Help for postgresql binary installation v.8.0.3