Re: Continuous integration on Windows?

On Sat, Oct 14, 2017 at 3:08 AM, Andrew Dunstan
<andrew(dot)dunstan(at)2ndquadrant(dot)com> wrote:
> I'll add some info to the wiki. Unfortunately, the tests fail on the
> tablespace test because they are running as a privileged user. We need
> to find a way around that, still looking into it. (See
> <https://blog.2ndquadrant.com/setting-build-machine-visual-studio-2017/>
> which describes how I get around that when running by hand).

Thanks for that pointer. "runas" seems to be no good in batch files
since it asks for a password interactively, but I managed to get the
tablespace test to pass by running it like this:

test_script:
- net user testuser password1234! /add
- psexec.exe -u testuser -p password1234! -w
c:\projects\postgres\src\tools\msvc perl.exe vcregress.pl check

(It probably goes without saying but I'll say it anyway for anyone who
might find this: this plaintext-password-in-script-files stuff is
intended for use on self-destructing isolated build bot images only
and should never be done on a computer you care about.)

Hooray! Now I can go and figure out why my Parallel Hash regression
test is failing with file permissions problems on Windows...

--
Thomas Munro
http://www.enterprisedb.com