Asset Server on Windows10

How-To start AssetServer 2.0.1 on Windows 10 x64
If you try to start AssetServer 2.0.1 on Windows 10 x64 you possible would not success and got this problem in AssetServer's logs:

FATAL: could not reattach to shared memory (key=332, addr=02B40000): 487 LOG: database system is ready to accept connections LOG: WAL writer process (PID 5304) exited with exit code 1 LOG: terminating any other active server processes LOG: autovacuum launcher started LOG: all server processes terminated; reinitializing

The problem is described here https://www.postgresql.org/message-id/v2w937d27e11005021131x1bfe254ftc33c76a42ea12e87%40mail.gmail.com

and as a solution - you should update PgSQL 8.3.7 (included in AssetServer 2.0.1) to version 8.3.8

In order to do it:

1) Load postgresql-8.3.8-1-binaries-no-installer.zip from here https://apt.postgresql.org/pub/binary/v8.3.8/win32/

2) Unpack and overwrite files in your current AssetServer's bin folder with ones that you can find inside the ZIP archive

3) After it find msvcr71.dll in Internet and add it to AssetServer's bin folder.

Now you should be able to start AssetServer with AssetServerControl.exe tool as usual, in a case of some problem take a look inside the logs.