PSQL v12 SP1 Release Notes
General Release – June 2016
Contents
Welcome to the General Release of PSQL v12 SP1.
These release notes for this service pack 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 PSQL website.
Overview
Product Editions
This release includes the following editions.
Windows
Linux
OS X
Platforms Supported
This release has been successfully tested on the following operating systems in their 32- and 64-bit editions:
We recommend updating all operating systems to their latest service packs.
Product Authorization
PSQL v12 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 v12, 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 v12 during installation requires an Internet connection. To authorize PSQL v12 after installation, see the alternative authorization procedures outlined in PSQL User's Guide.
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 v12 requires an Internet connection. To authorize PSQL v12 after installation, see the alternative authorization procedures outlined in PSQL User's Guide.
Authorizing on OS X
On OS X, product authorization is required for PSQL Server and Vx Server. Product authorization must be performed after installation using the license administrator utility. Authorizing PSQL v12 requires an Internet connection. To authorize PSQL v12 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 and OS X
On Linux and OS X 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 Linux or OS X.
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
For Windows and Linux, PSQL v12 Server and Workgroup support PSQL v11 Client or later.
For OS X server, clients must be 12.00 or later.
New Features and Enhancements
See What’s New in PSQL for coverage of new and changed features in PSQL v12. This document is included with the installed documentation and at the PSQL 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 PSQL website.
You must remove any previously installed prerelease version, such as a beta or release candidate from any edition, before installing the final General Availability (GA) release of PSQL v12.
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 PSQL website.
Installation comes in three 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 v12 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 v12 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 v12 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%\PSQLv12_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 Linux
PSQL v12 has been tested on Red Hat Enterprise Linux 7. For information about installing or upgrading to PSQL v12 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 v12 from a previous PSQL version on Linux, you must first uninstall the current version.
Installing PSQL on OS X
PSQL v12 has been tested on OS X 10.9, 10.10, and 10.11. For information about installing or upgrading to PSQL v12 on OS X, see Getting Started with PSQL.
Installation Packages
PSQL offers full and client installations of both TAR and DMG packages on OS X. 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 v12 from a previous PSQL version on OS X, you must first uninstall the current version.
Important Notes about Installing on OS X
The following information applies when you install PSQL on OS X 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, but with the exceptions shown here.
 
Source Code for PSQL unixODBC
In accordance with GNU General Public Licensing (GPL), on Linux and OS X 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 and OS X, the JRE components are always installed.
Installing Backup Agent
You can use Backup Agent v12 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 v12 Server for Windows. To use Backup Agent with PSQL v12 Workgroup, you must have a separate license.
Windows
On Windows platforms, PSQL v12 provides two upgrade paths from older versions of Backup Agent. The following table compares the two upgrades.
Linux
On Linux, after installing PSQL v12 you must manually uninstall your existing version of Backup Agent and then manually install Backup Agent v12.
OS X
In this release, Backup Agent v12 is not currently supported.
Fixed Issues and Known Issues
The online download page for PSQL v12 provides a history log that lists issues fixed and enhancements added since PSQL 12.00. You can also download a file of known issues for PSQL v12.
Usage Notes
This section 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 PSQL website:
Knowledge Base. Search hundreds of articles for answers and solutions others have found useful.
Community Forums. Join a technical discussion or post a question to start a new one.
PSQL Database Support page. Open a service ticket, submit a defect, or purchase support.
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 © 2016 Actian Corporation. All Rights Reserved.