The following topics cover installation and configuration of PSQL Server, Client, and Client Reporting Engine on Windows Nano Server and Windows IoT Core:

Before installing PSQL on these platforms, we recommend you review the release notes from the Actian website. Also, be aware that throughout the PSQL documentation, all references to PSQL Server apply to installations on Windows Nano Server and IoT Core systems as well.

You must be logged in as administrator to install any of the products.

Microsoft PowerShell and the .zip archive format are used to install PSQL on Windows Nano Server or IoT Core. The following topics explain how to use these to install PSQL.

Depending on the operating system where you install PSQL, choose a .zip file from the following table.

In the file name, yy.yy is a release number and zzz.zzz is a build number. See the file for its actual name.

A server installation includes the engine and client files and selected utilities. Client installations provide only files and utilities needed to support a client. Client Reporting Engine installations are the same as those on other Windows platforms.

Your installation is either a first time, with no previous version, or an upgrade to an existing installed version.

After choosing a .zip file and copying it to the target system, proceed with the following steps. After completing them, see Windows Firewall Configuration.

After installation, you can reclaim disk space by removing the .zip archive and its extracted files.

PSQL installation for Windows Nano Server and Windows IoT Core systems requires that Windows Firewall rules allow communication through the firewall. These rules are not enabled by default. To enable them, run the PowerShell script Enable-PsqlFirewallRules.ps1, which is included in a default PSQL installation in C:\Program Files\Actian\PSQL\bin. If needed, you can enter one of the following arguments to enable the rules only for the specified Windows Firewall profile:

The following example enables the firewall with the domain argument:

PS> & "C:\Program Files\Actian\PSQL\bin\Enable-PsqlFirewallRules.ps1" domain

If you enter no argument, then rules for all Windows Firewall profiles are enabled, the same as if you had entered the argument any. After the script is executed, it displays the current state of the rules for all profiles.

To upgrade an existing installed version of PSQL on Windows Nano Server and Windows IoT Core, repeat the installation steps using a new .zip archive.

You do not need to redo changes made to Windows Firewall rules after the first installation.

The following topics may be useful after you install PSQL. Throughout the PSQL documentation, references to PSQL Server apply to installations on Windows Nano Server and IoT Core systems.

All configuration settings for PSQL Server are available on Windows Nano Server and IoT Core. Generally, the default configuration settings used for PSQL Server are sufficient. For information on these settings, see Configuration Reference in Advanced Operations Guide.

Basic configuration settings for installations of PSQL Client are discussed in Setting Up Network Communications for Clients. For information on all client settings, see Windows Client Configuration Properties in Advanced Operations Guide.

On both Windows Nano Server and IoT Core, PSQL uses license keys instead of product keys.

In the current release, the code page for a PSQL installation on Windows IoT Core defaults to Western European 1252. You can change the code page using PowerShell. For example, if you want to change the setting to Microsoft Windows 932 for Japanese systems, use the following command:

Set-ItemProperty -Path HKLM:\SYSTEM\CurrentControlSet\Control\Nls\CodePage -Name ACP -Value 932

If you have problems with your installation, see Troubleshooting After Installation or get help online from the PSQL knowledge base at the Actian website. The following are common questions after installation of the products:

After the installation script finishes, you can verify that the database engine is running with the PowerShell Get-Service command. To do so, enter the following at a command prompt:

If the engine is running, this command returns the following:

Status Name DisplayName
------ ---- -----------
Running  Pervasive.SQL (... Actian PSQL Relational Engine
Running  Pervasive.SQL (... Actian PSQL Transactional Engine

If the relational or transactional engine is stopped, you can use the following commands to manually start them, which must be run in the order given here:

Start-Service -DisplayName "Actian PSQL Transactional Engine"
Start-Service -DisplayName "Actian PSQL Relational Engine"

The engine services start automatically with the operating system. If you need to stop them, use the following command:

Stop-Service -DisplayName "Actian PSQL*"

After running this command, the Get-Service command returns the following:

Status Name DisplayName
------ ---- -----------
Stopped  Pervasive.SQL (... Actian PSQL Relational Engine
Stopped  Pervasive.SQL (... Actian PSQL Transactional Engine

On Nano Server systems, PSQL provides a subset of the command line utilities that are available in full installations. These utilities consist of the following:

On IoT Core systems, the utilities consist of the following:

The following table lists the primary directories and files installed for PSQL products on Windows Nano Server or IoT Core. The variable %ALLUSERSPROFILE% is used to determine the location of some files, while others default to C:\Program Files\Actian\PSQL.

No documentation is included in a PSQL installation on Windows Nano Server or IoT Core. You may use the documentation installed with other PSQL editions or posted on the Actian website.

The release notes contain general information about the release, sometimes including late-breaking advice not yet covered in the user documentation. Although this document is not included in PSQL installations on Windows Nano Server or IoT Core, the Actian website posts the latest version.

Use the following steps to remove PSQL from your system.

To remove PSQL from the system, you use the script Uninstall-PSQL.ps1. This script is located in the PSQL bin folder C:\Program Files\Actian\PSQL\bin. You should invoke it from a working directory located outside that path, as shown in the example used here.

Removal of PSQL is complete.