BUG #4352: Service fails to start when moved from domain to workgroup - Mailing list pgsql-bugs

From Bhaskar Sirohi
Subject BUG #4352: Service fails to start when moved from domain to workgroup
Date
Msg-id 200808131238.m7DCcSts064218@wwwmaster.postgresql.org
Whole thread Raw
List pgsql-bugs
The following bug has been logged online:

Bug reference:      4352
Logged by:          Bhaskar Sirohi
Email address:      bhaskar.sirohi@druvaa.com
PostgreSQL version: 8.3
Operating system:   Windows 2003 Server
Description:        Service fails to start when moved from domain to
workgroup
Details:

It seems there is an issue with Postgres v8.3 that if you move the postgres
server from domain to workgroup the service fails to start with
logon-failure.

If you right click on postgres service, and check "log-on" in properties it
says "./postgres". Even resetting postgres service user password doesn't
have any impact. Finally if you change the "log-on" to "local system
account" it works well.

Please advise what could be done for the above case and whether it would be
okay to run the postgres service under the local windows account.

pgsql-bugs by date:

Previous
From: "Heikki Linnakangas"
Date:
Subject: Re: BUG #4350: 'select' acess given to views containing "union all" even though user has no grants
Next
From: Tom Lane
Date:
Subject: Re: BUG #4350: 'select' acess given to views containing "union all" even though user has no grants