Re: Regression tests failures on Windows Server 2019 - on master at commit # d816f366b - Mailing list pgsql-hackers

From Andres Freund
Subject Re: Regression tests failures on Windows Server 2019 - on master at commit # d816f366b
Date
Msg-id 20220304224412.wunxfyfwp5il3qs7@alap3.anarazel.de
Whole thread Raw
In response to Re: Regression tests failures on Windows Server 2019 - on master at commit # d816f366b  (Andres Freund <andres@anarazel.de>)
List pgsql-hackers
On 2022-03-04 14:04:44 -0800, Andres Freund wrote:
> Trying to make it use the current user now - I don't know what
> permissions services are needed to run a service as a user or such.

My first attempt of using %USERNAME% failed:

[22:10:20.862] c:\cirrus>call tmp_install\bin\pg_ctl.exe register -D tmp_check/db "-UContainerAdministrator"
[22:10:20.889] pg_ctl: could not register service "PostgreSQL": error code 1057

seems to require a domain for some reason:
[22:33:54.599] c:\cirrus>call tmp_install\bin\pg_ctl.exe register -Dtmp_check/db -U "User
Manager\ContainerAdministrator"

but that then doesn't start:
[22:33:54.660] c:\cirrus>call net start PostgreSQL
[22:33:55.887] System error 1068 has occurred.

So it indeed seems hard to start a service as the current user. At least with
my limited windows knowledge.



pgsql-hackers by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: role self-revocation
Next
From: Tatsuo Ishii
Date:
Subject: Re: Proposal: Support custom authentication methods using hooks,Re: Proposal: Support custom authentication methods using hooks