Pervasive PSQL v11 SP1 Release Notes
General Release—July 2011

Contents

Welcome to the General Release of Pervasive PSQL v11 SP1.

This file contains the following topics:

Overview

The General Release includes the following:

Platforms Supported

The following operating systems in both 32-bit and 64-bit editions are supported for this General Release:

Third-Party Certification

For information related to third-party certification for Pervasive PSQL v11 SP1, refer to the Pervasive Software web site for detailed status information.

Product Authorization

Pervasive PSQL v11 SP1 comes with a trial key (Server 20 user or Workgroup 5 user) for evaluation installations.

If you are installing this release of Pervasive PSQL v11 SP1 on a machine with a previously authorized version of Pervasive PSQL v11, you will not be required to authorize the product at installation; you will continue to use your previous product key.

If you are installing this release of Pervasive PSQL v11 SP1 on a machine without a previously authorized version of Pervasive PSQL v11, you will be required to authorize the product, either at the time of installation or after installation using the License Administrator utility.

Client Compatibility

The General Release of Pervasive PSQL v11 SP1 Server and Workgroup supports Pervasive PSQL v10 or later Clients.

New Features and Enhancements

See What’s New in Pervasive PSQL for a discussion of the new and changed features in Pervasive PSQL v11 SP1.

Installing Pervasive PSQL

This section discusses topics pertaining to the installation of the product on Windows and Linux. Before reading this section, review the content on Product Authorization in the previous section.

The installation files are available for download from the Pervasive Web site: http://www.pervasivedb.com.

Pervasive Software requires that you uninstall the Beta Release prior to installing the final General Release of Pervasive PSQL v11 SP1.

Windows

If you have not installed the product and want to read about installation, see the portable document format (PDF) book Getting Started with Pervasive PSQL, available on the installation media or the Pervasive Software web site.

Installing Pervasive PSQL on Windows

Run the full (setup*.exe) Pervasive PSQL v11 SP1 installation.

The following topics apply when you install to Windows.

Subject
Discussion
Windows firewall and client/server applications
The Pervasive PSQL Server and Workgroup installation adds files to the firewall access list to enable client/server functionality. If the operating system security prompts you during installation of Pervasive PSQL to unblock or allow communication with a Pervasive PSQL component, select OK (yes).
Optionally Disable Restore Points
The total installation time can usually be reduced on Windows Vista and later systems by disabling Windows System Restore. On Windows 7 and Windows Server 2008 R2 systems the installation can be made to skip the creation of a system restore point without actually disabling Windows System Restore by setting the property “MSIFASTINSTALL=1” on the command line. For example:
Setup<InstallType>_x<Platform>.exe /s /v" /l*v \"%temp%\PSQLv11_InstallLogFileName.log\" MSIFASTINSTALL=1"
Characters to avoid in installation path
The pound (#) and percent (%) characters should not be used in installation paths for the Pervasive PSQL products if you intend to use Pervasive PSQL Control Center or DDF Builder. Those two utilities will not run if the installation path contains a pound character or a percent character.
Upgrading to run Workgroup Engine as a Service
If you install Workgroup Engine or Client Cache Engine as an application, then later decide you want to run it as a service, uninstall the engine, then reinstall it as a service.
Authorization and security
You must have Administrator rights to install Pervasive PSQL.
Depending on the particular account, a local security policy, “Sharing and security model for local accounts,” in Vista and Windows Server 2008 platforms can adversely affect network logins. Ensure that your policy for “Sharing and security model for local accounts” is set to Classic, which authenticates users as themselves.
PATH location
If you are installing a downloaded version of Pervasive PSQL, do not place the setup files in a location that is listed in the PATH environment variables. This can cause issues with file copying during install. Place the setup files in a location such as the Windows TEMP directory.
Windows Installer Version
Some versions of Windows supported with Pervasive PSQL v11 SP1 may not have the minimum required version of the Windows Installer installed. Pervasive PSQL v11 SP1 requires Windows Installer v3.1 be installed in order to run the PSQL installation. To see what version of the Windows Installer is present on your system, type MSIExec /? at a command prompt.
If your version of Windows does not have Windows Installer v3.1 installed, either upgrade your version of Windows Installer or install Pervasive PSQL v11 SP1 using the Setup executable file, which will automatically upgrade the installed version of Windows Installer to v3.1 before running the Pervasive PSQL v11 SP1 installation.
Windows Server 2008 Core installation
The optional installation features are disabled by default when installing Pervasive PSQL Server on Windows Server 2008 Core.
Installing XIO on Virtual Machines
Pervasive Software does not support running XIO on a virtual machine image.

Silent Installation

To install Pervasive PSQL v11 SP1 silently follow these steps:

1. Run the PSQL installation using the silent command line option. To authorize PSQL during the installation, update the installation configuration file ptksetup.ini to specify the authorization key (PVSW_PSQL_LICENSE_KEY=<key>). To authorize PSQL from the command line after the installation has completed, see step 2. 

Setup<InstallType>_x<Platform>.exe /s /v"/qn /l*v 
\"%temp%\PSQLv11_InstallLogFileName.log\""

This example creates an installation log file in the Windows temp directory.

2. [Optional] To authorize PSQL after the installation has completed, use the License Administrator Command Line Interface utility: 

“<PSQL_install_path>\bin\clilcadm.exe” –a <key>

Linux

Installing Pervasive PSQL on Linux

Pervasive PSQL v11 SP1 supports Linux distributions running Kernel 2.6.0 or higher. For information on installing Pervasive PSQL v11 SP1 on Linux, see Getting Started with Pervasive PSQL. For information on upgrading to Pervasive PSQL v11 SP1 on Linux, see Getting Started with Pervasive PSQL.

Note  If you are upgrading from a previous version of Pervasive PSQL on Linux, you must uninstall and then install Pervasive PSQL v11 SP1.

Linux Installation Packages

Full installation packages are available for Linux. A full installation includes the necessary engine and client files, all available utilities and the complete user documentation.

The following table outlines the installation packages available.

Pervasive PSQL Product
Installation Type
Contains
Example Name of Package1
Server 64-bit
Full
Engine and client files, utilities, and documentation
Pervasive.SQL-x.yy-zzz.zzz.x86_64.[rpm | tar]
Server 32-bit
Full
Engine and client files, utilities, and documentation
Pervasive.SQL-x.yy-zzz.zzz.i486.[rpm | tar]
Client 64-bit
Client
Client files, utilities, and documentation
Pervasive.SQL-Client-x.yy-zzz.zzz.i486_64.[rpm | tar]
Client 32-bit
Client
Client files, utilities, and documentation
Pervasive.SQL-Client-x.yy-zzz.zzz.i486.[rpm | tar]
1 x.yy-zzz.zzz represents the actual digits in the file name that indicate the release and build number of the product

Eco System Products

This section details information specific to Pervasive Software Eco System products and their compatibility with Pervasive PSQL v11 SP1. Pervasive PSQL v11 SP1 supports Backup Agent v3, DataExchange v4 and AuditMaster v7.

If you have Backup Agent 1.x/2.x, DataExchange 2.x/3.x, or AuditMaster 6.4 installed and are installing Pervasive PSQL v11 SP1, they will not work after you have installed Pervasive PSQL v11 SP1. You will need to uninstall or upgrade your eco products so that they are compatible with Pervasive PSQL v11 SP1.

Backup Agent

If you have Backup Agent 2.x 32-bit installed, you will not be able to install Pervasive PSQL v11 SP1 until you first uninstall Backup Agent 2.x 32-bit. This is a current limitation with the Backup Agent 2.x 32-bit uninstall.

Note  The latest version of Backup Agent v3 for Linux is required for use with Pervasive PSQL v11 SP1 for Linux. Download the latest version from the Pervasive PSQL Web site www.pervasivedb.com. This requirement applies only to Linux, not Windows.

JRE Components Included in Installation

The JRE is no longer invoked as a separate installation by the Pervasive PSQL installation. The components of the JRE needed by the following features are now installed as part of Pervasive PSQL unless an appropriate version of the JRE (1.6.0_01 or higher) is already installed for all users on the system:

On Windows 32-bit operating systems, the Pervasive PSQL installation does not install the JRE components if an appropriate version of the JRE (1.6.0_01 or higher) is already present for all users. On Windows 64-bit operating systems and on Linux, the JRE components are always installed.

Fixed Issues and Known Issues

The Web download page for Pervasive PSQL v11 SP1 General Release contains a file that lists the issues fixed since the General Release of Pervasive PSQL v11. The known issues for Pervasive PSQL v11 SP1 General Release are also published on the download page. See http://www.pervasivedb.com.

Usage Notes

This section discusses situations you may encounter using the product after installation.

Windows

Subject
Discussion
Restore point errors in Pervasive PSQL install log
Failures pertaining to restore point can be ignored. Sometimes the Windows operating system fails to create a snapshot of the current disk (called a restore point) prior to allowing a new application installation. The restore point is not required. Uninstalling Pervasive PSQL completely removes the Pervasive PSQL product from the system.
Right-click shortcut for "Run As Administrator" on Windows Vista and later releases
A right-click on an application utility in the Windows Start menu does not offer a "Run As Administrator" option. This is a limitation of Windows Installer 3.1.
If, for some reason, you want to run a Pervasive PSQL utility in an elevated mode, you have several options:
  • Run the utility from an elevated command prompt
  • Create your own desktop shortcut to the utility executable
  • Navigate to the utility executable with Windows Explorer.

Linux

Subject
Discussion
Internet protocol on Linux
Pervasive PSQL does not support Internet Protocol (IP) v6 on Linux. If the operating system uses IP v6 by default, consider changing the default configuration to IP v4. Using IP v4 as the default prevents the delay caused by the database engine when it attempts to use IP v6 then must revert to IP v4. Refer to the operating system documentation for setting the IP default.
ODBC and Linux
Unix ODBC does not come installed with Red Hat Enterprise 5.4. If your ODBC application is set to use the Unix ODBC cursor library, you need to install the Unix ODBC package or change your ODBC application to use the Pervasive ODBC driver.

Technical Support

You may obtain technical support from the following Web-based support options:

Disclaimer

PERVASIVE SOFTWARE INC. 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 ©2011 Pervasive Software Inc. All Rights Reserved.

Pervasive Software Inc.
http://www.pervasivedb.com
12365 Riata Trace Pkwy, Bldg B
Austin, TX 78727 USA
Voice: (512) 231-6000
Fax: (512) 231-6010

*** End of Release Notes ***