PSQL v13 SP1 Release Notes
General Release – January 2018
Contents
Welcome to the General Release of PSQL v13 SP1.
These release notes cover the following topics:
This document is included in your PSQL installation but may be updated after the release. Its latest version is always posted on the Actian website.
Overview
Product Editions
This release includes the following editions, listed by operating system.
Windows and Nano Server
Windows IoT Core
Linux
OS X and Mac OS
Platforms Supported
This release has been successfully tested on the following operating systems, where appropriate in both their 32- and 64-bit editions. For more information about platform support, see What’s New in PSQL and Getting Started with PSQL.
PSQL installation has been tested successfully with Docker for Windows.
PSQL Server on Windows Nano Server and IoT Core supports use of the PSQL SDKs for Btrieve, DTI, and ODBC. Throughout the PSQL documentation, all references to PSQL Server apply to installations on Windows Nano Server and IoT Core systems.
For PSQL Client Reporting Engine, use of PSQL Server on Linux as a storage server is not currently supported.
We recommend updating all operating systems to their latest service packs.
Product Authorization
PSQL comes with a trial key for evaluation installations. These trial keys have limits of 20 users for Server, 5 users for Workgroup, and Medium size (20 GB) for Vx Server.
If you are installing this release of PSQL, you are required to authorize the product, either at the time of installation or after installation using the License Administrator utility.
Authorizing on Windows
On Windows, product authorization is required for PSQL Server, Vx Server, and Workgroup. Product authorization can be performed during installation or using the license administrator utility after installation. Authorizing PSQL during installation requires an Internet connection. To authorize PSQL after installation, see the alternative authorization procedures outlined in PSQL User's Guide.
Note On Windows IoT Core x86 and ARM32, the following licensing features are not currently supported: Online authorization through a proxy server, offline authorization, product key repair, and command line use of clilcadm -number.
Authorizing on Linux
On Linux, product authorization is required for PSQL Server and Vx Server. Product authorization must be performed after installation using the license administrator utility. Authorizing PSQL v13 SP1 requires an Internet connection. To authorize after installation, see the alternative authorization procedures outlined in PSQL User's Guide.
Note On Linux Red Hat Enterprise AArch64 and Raspbian ARM32, the following licensing features are not currently supported: Online authorization through a proxy server, offline authorization, product key repair, and command line use of clilcadm -number.
Authorizing on OS X and Mac OS
On OS X and Mac OS, product authorization is required for PSQL Server and Vx Server. Product authorization must be performed after installation using the license administrator utility. Authorizing PSQL v13 SP1 requires an Internet connection. To authorize after installation, see the alternative authorization procedures outlined in PSQL User's Guide.
License Authorization Access Through Proxy Servers on Windows
We recommend that you use Windows Internet Explorer to configure proxy servers. If your proxy server was not configured using Internet Explorer, we recommend that you use Internet Explorer to configure it again. If you are unable to use Internet Explorer, then you can use the steps given here. These steps involve editing the Windows Registry.
Caution Editing the registry is an advanced procedure. If done improperly, the editing can cause your operating system not to start. If necessary, obtain the services of a qualified technician to do the editing. Actian Corporation does not accept responsibility for a damaged registry.
In a 64-bit Windows operating system, two keys in the Registry can store proxy server settings:
Depending on the PSQL edition (Server, Client, Vx Server, or Workgroup), the ELS proxy server settings can be created in either location. Licensing manager looks for its proxy server settings first in the HKEY_LOCAL_MACHINE\Software\Wow6432Node\Pervasive Software\ELS\ key. If it cannot locate them there, it looks in the HKEY_LOCAL_MACHINE\Software\Pervasive Software\ELS\ key.
If you are editing Registry settings for proxy servers, you first need to find the correct location.
1
2
3
Note PSQL requires only the proxy_host and proxy_port values. Depending on the configuration of your proxy server, you may also need to add proxy_userid and proxy_passwd.
4
License Authorization Access Through Proxy Server on Linux, OS X, and Mac OS
On Linux, OS X, and Mac OS systems, to configure a proxy server to allow license authorization, you must edit the els.ini file. PSQL does not support any other method of configuring proxy access on these operating systems.
1
2
Note PSQL requires only the proxy_host and proxy_port values. Depending on the configuration of your proxy server, you may also need to add proxy_userid and proxy_passwd.
3
Client Compatibility
On Windows and Linux, PSQL v13 Server and Workgroup support PSQL v12 Client or later, except for IoT Core and Raspbian, where only a PSQL v13 Client is supported.
For OS X and Mac OS servers, clients must be 13.00 or later.
Compatibility with AuditMaster, Backup Agent, or DataExchange
AuditMaster, Backup Agent, and DataExchange installed with earlier PSQL versions are not compatible with PSQL v13. When you are preparing to upgrade PSQL from an older version, you must first uninstall any existing installations of these products. Before removing them, we recommend that you capture their configuration settings to use in reinstalling and configuring new versions after upgrading.
New Features and Enhancements
See What’s New in PSQL for coverage of new and changed features in this release of PSQL. This document is included with the installed documentation and at the Actian website on the download page. The download version may be updated after the product release, so we recommend you refer to that version for the latest information.
Installing PSQL
This topic discusses installation of the product. Before reading further, be familiar with Product Authorization.
Installation files are available for download from the Actian website.
You must remove any previously installed prerelease version, such as a beta or release candidate from any edition, before installing a final General Availability (GA) release of PSQL.
If you have not installed the product before or are upgrading for the first time and want to read about installation in detail, see Getting Started with PSQL, available on the installation media or the Actian website.
Installation comes in several types:
Installing PSQL on Windows
To start the installation, run the installer application (Install_*.exe) for the PSQL engine or client type that you want to install and follow the instructions displayed by the installer.
The PSQL installer automatically detects the bit architecture of the operating system and installs the right components. You do not have to choose the 32- or 64-bit installer application.
The following table describes PSQL installers on Windows operating systems.
Important Notes about Installing on Windows
The following information applies when you install PSQL on Windows systems.
Installing Silently on Windows
To install PSQL silently, run the PSQL installation using the quiet command line option /qn, as shown in this example:
Install_PSQL<InstallType>.exe /s /v"/qn /l*v \"%temp%\PSQLv13_InstallLogFileName.log\""
This example creates an installation log file in the Windows temp directory.
Optionally, to authorize PSQL after the installation has completed, use the License Administrator command line tool clilcadm.exe:
"<PSQL_install_path>\bin\clilcadm.exe" -a <key>
Installing PSQL on Windows Nano Server and IoT Core
This release of PSQL has been tested on Windows Nano Server and IoT Core. For information about installing or upgrading to PSQL on these platforms, see Getting Started with PSQL.
Installation Packages
PSQL offers full Windows Nano Server and IoT Core and Nano Server client reporting engine and client installations as noted in the following table. A full installation includes the necessary engine and client files and utilities. A client installation provides only files needed to support a client, including utilities. The following table lists the installation packages. Microsoft PowerShell and the .zip archive format are used for the installation.
Install-PSQL-Any-yy.yy-zzz.zzz-winuwp.x86_64.zip
Install-Zen-Server-yy.yy-zzz.zzz-winuwp.x86.zip
Install-Zen-Server-Any-yy.yy-zzz.zzz-winuwp.arm32.zip
1 yy.yy-zzz.zzz represents the digits in the file name for the release and build numbers of the product.
Installing PSQL on Linux (Red Hat)
PSQL v13 SP1 has been tested on Red Hat Enterprise Linux 7. For information about installing or upgrading to PSQL v13 SP1 on Linux, see Getting Started with PSQL.
Installation Packages
PSQL offers full and client installations of both RPM and TAR Linux packages. A full installation includes the necessary engine and client files, utilities, and the complete user documentation. A client installation provides only files needed to support a client, including utilities and documentation. The following table lists the installation packages.
Package Names1                                                          
PSQL-linux-yy.yy-zzz.zzz.x86_64.rpm
PSQL-linux-yy.yy-zzz.zzz.x86_64.tar.gz
PSQL-Vx-linux-yy.yy-zzz.zzz.x86_64.rpm
PSQL-Vx-linux-yy.yy-zzz.zzz.x86_64.tar.gz
PSQL-Client-linux-yy.yy-zzz.zzz.x86_64.rpm
PSQL-Client-linux-yy.yy-zzz.zzz.x86_64.tar.gz
Note: Glibc and stdc++ packages are prerequisites for the Client Access installation. Before installing Client Access, you can add these packages from the repository of your Linux distribution using a yum command:
PSQL-Client-Access-linux-yy.yy-zzz.zzz.x86_64.rpm
PSQL-Client-Access-linux-yy.yy-zzz.zzz.x86_64.tar.gz
1 yy.yy-zzz.zzz represents the digits in the file name for the release and build numbers of the product.
Note To upgrade to PSQL v13 SP1 from a previous PSQL version on Linux, you must first uninstall the current version.
Installing PSQL on Linux (Raspbian)
This release of PSQL has been tested on Raspbian. For information about installing or upgrading to PSQL on this platform, see Getting Started with PSQL.
Installation Packages
PSQL offers full and client installations of TAR Linux packages. A full installation includes the necessary engine and client files, utilities, and the complete user documentation. A client installation provides only files needed to support a client, including utilities and documentation. The following table lists the installation packages.
Package Names1                                                          
PSQL-linux-yy.yy-zzz.zzz.armhf.tar.gz
PSQL-Client-linux-yy.yy-zzz.zzz.armhf.tar.gz
1 yy.yy-zzz.zzz represents the digits in the file name for the release and build numbers of the product.
Installing PSQL on OS X and Mac OS
PSQL v13 SP1 has been tested on OS X 10.9, 10.10, and 10.11 and on Mac OS 10.12. For information about installing or upgrading to PSQL v13 SP1 on these operating systems, see Getting Started with PSQL.
Installation Packages
PSQL offers full and client installations of both TAR and DMG packages on OS X and Mac OS. A full installation includes the necessary engine and client files, utilities, and the complete user documentation. A client installation provides only files needed to support a client, including utilities and documentation. The following table lists the installation packages.
Package Names1                                                    
PSQL-macosx-yy.yy-zzz.zzz.x86_64.tar.gz
PSQL-macosx-yy.yy-zzz.zzz.x86_64.dmg
PSQL-Vx-macosx-yy.yy-zzz.zzz.x86_64.tar.gz
PSQL-Vx-macosx-yy.yy-zzz.zzz.x86_64.dmg
PSQL-Client-macosx-yy.yy-zzz.zzz.x86_64.tar.gz
PSQL-Client-macosx-yy.yy-zzz.zzz.x86_64.dmg
1 yy.yy-zzz.zzz represents the digits in the file name for the release and build numbers of the product.
Note To upgrade to PSQL v13 SP1 from a previous PSQL version on OS X, you must first uninstall the current version.
Important Notes about Installing on OS X and Mac OS
The following information applies when you install PSQL on OS X and Mac OS systems. These notes all relate to access and authentication using the Samba implementation of the SMB/CIFS networking protocol. The instructions for configuring Samba on Linux also apply to OS X and Mac OS, but with the exceptions shown here.
 
Source Code for PSQL unixODBC
In accordance with GNU General Public Licensing (GPL), on Linux, OS X, and Mac OS systems the source code for PSQL unixODBC functionality is redistributed in the /etc directory of the installation as psql-unixODBC-2.2.11.tar.gz.
JRE Components Included in Installation
On Windows 32-bit operating systems, the PSQL installation does not install the JRE components if an appropriate version of the JRE (1.7 or later) is already present for all users. On Windows 64-bit operating systems and on Linux, OS X, and Mac OS, the JRE components are always installed.
Installing Backup Agent
You can use Backup Agent v13 to upgrade from all previous versions of Backup Agent.
Backup Agent does not require a separate license when used with PSQL Server. It is included with PSQL Server for Windows. To use Backup Agent with PSQL Workgroup, you must have a separate license.
Backup Agent does not require a separate license when used with PSQL Server. It is included with PSQL v13 SP1 Server for Windows. To use Backup Agent with PSQL v13 SP1 Workgroup, you must have a separate license.
Windows
On Windows platforms, PSQL v13 SP1 provides two upgrade paths from older versions of Backup Agent. The following table compares the two upgrades.
Windows Nano Server and IoT Core
Backup Agent v13 is not currently supported.
Linux Red Hat
On Linux Red Hat, after installing PSQL v13 SP1 you must manually uninstall your existing version of Backup Agent and then manually install Backup Agent v13.
Linux Raspbian
Backup Agent v13 is not currently supported.
OS X and Mac OS
Backup Agent v13 is not currently supported.
Fixed Issues and Known Issues
The Actian website provides a history log for this release of PSQL that lists issues fixed and enhancements added since the previous release. You can also find a list of known issues.
Usage Notes
This topic discusses situations you might encounter using the product after installation.
For Windows
 
Technical Support
You can obtain technical support from several online options at the Actian website:
Disclaimer
ACTIAN CORPORATION LICENSES THE SOFTWARE AND DOCUMENTATION PRODUCT TO YOU OR YOUR COMPANY SOLELY ON AN "AS IS" BASIS AND SOLELY IN ACCORDANCE WITH THE TERMS AND CONDITIONS OF THE ACCOMPANYING LICENSE AGREEMENT.
Copyright © 2018 Actian Corporation. All Rights Reserved.