Installing WiltonDB - wiltondb/wiltondb GitHub Wiki

On this page:

Window version requirements

WiltonDB can be installed onto a Windows Server (2016 or later) or onto desktop Windows 10 or 11. Wilton DB only supports x86_64 (also known as AMD-64) processor architecture.

Installation prerequisites

WiltonDB requires the Microsoft Visual C++ Redistributable as a prerequisite to the installation.

Download the latest version of the redistributable from this (direct) link: VC_redist.x64.exe and run it:

vc_redist_02

vc_redist_03

Running the installer

WiltonDB requires Administrator priviliges to perform the installation:

install_01

install_02

install_03

install_04

Check that WiltonDB is added to the list of installed programs:

install_05

Check that WiltonDB Windows service was successfully registered and has started:

install_06

Using GUI configuration tool

Configuration tool can be opened automatically when installation is completed:

config_01

It can be used to inspect and change database settings. To use this tool after the installation you can pin it to Windows taskbar using right-click context menu.

Installation troubleshooting

In case of problems during the installation it may be rolled back automatically:

trouble_01

trouble_02

Usually problem details will be available in system Event Viewer under "MsiInstaller" or "PostgreSQL" event source:

trouble_03

Database cluster is created automatically during installation in <install_dir>/data directory inside the installation directory. In case when data directory already exists on this path (for example: remained there from a previous installation), cluster creation is skipped and the service attempts to use existing data directory.

trouble_04

If service startup error is displayed, cancel the installation, rename or remove existing data directory and rerun the installer.

When system Event Viewer does not provide enough information, it is possible to run the installer with verbose logging. To do that open the Administrator Command Prompt and run the following:

msiexec /i wiltondb3.3_2.4.1.msi /L*V c:\tmp\install_log.txt

Inspect the generated install_log.txt for possible erors. For example the following error will be recorded if Microsoft Visual C++ Redistributable is not installed:

MSI (s) (D0:BC) [08:19:47:576]: Executing op: ActionStart(Name=create_cluster_deferred,,)
Action 8:19:47: create_cluster_deferred. 
MSI (s) (D0:BC) [08:19:47:589]: Executing op: CustomActionSchedule(Action=create_cluster_deferred,ActionType=3073,Source=BinaryData,Target=WixQuietExec,CustomActionData="C:\Windows\system32\WindowsPowerShell\v1.0\powershell.exe" -NoLogo -NoProfile -NonInteractive -ExecutionPolicy Bypass -File "C:\Program Files\WiltonDB Software\wiltondb3.3\share\installer\wiltondb-setup.ps1" "C:\Program Files\WiltonDB Software\wiltondb3.3\")
MSI (s) (D0:EC) [08:19:47:589]: Invoking remote custom action. DLL: C:\Windows\Installer\MSI46AA.tmp, Entrypoint: WixQuietExec
MSI (s) (D0:FC) [08:19:47:589]: Generating random cookie.
MSI (s) (D0:FC) [08:19:47:589]: Created Custom Action Server with PID 4428 (0x114C).
MSI (s) (D0:E8) [08:19:47:617]: Running as a service.
MSI (s) (D0:E8) [08:19:47:617]: Hello, I'm your 32bit Elevated Non-remapped custom action server.
WixQuietExec:  C:\Program Files\WiltonDB Software\wiltondb3.3\bin\initdb.exe -D C:\Program Files\WiltonDB Software\wiltondb3.3\data -U postgres -E UTF8 --no-locale --no-instructions
WixQuietExec:  
WixQuietExec:  
WixQuietExec:  C:\Program Files\WiltonDB Software\wiltondb3.3\bin\initdb.exe "-D" "C:\Program Files\WiltonDB Software\wiltondb3.3\data" "-U" "postgres" "-E" "UTF8" "--no-locale" "--no-instructions"
WixQuietExec:  Exit code: -1073741515
WixQuietExec:  Output:
WixQuietExec:  
WixQuietExec:  Error 0x80070001: Command line returned an error.
WixQuietExec:  Error 0x80070001: QuietExec Failed
WixQuietExec:  Error 0x80070001: Failed in ExecCommon method
CustomAction create_cluster_deferred returned actual error code 1603 (note this may not be 100% accurate if translation happened inside sandbox)
Action ended 8:19:48: InstallFinalize. Return value 3.