Installation Overview

This section provides an overview to the components that make up Pervasive PSQL v9 Service Pack 2. Also included in this section is information on the files included in the different types of installation.

Major Components of the Product

The product consists of the following components:

Database Engine

Pervasive PSQL v9 Service Pack 2 consists of two database sub-engines:

MicroKernel Database Engine (MKDE), which provides Btrieve/MicroKernel API support for Pervasive PSQL applications

SQL Relational Database Engine (SRDE), which provides ODBC/SQL API support for Pervasive PSQL applications

Client

Requesters that allow you to access the server-based MicroKernel from a DOS client, a Windows 98/ME client, or a Windows 32-bit platform client.

The 16-bit requesters used in DOS clients are Btrieve requesters only and will have no relational access.

Utilities

Pervasive PSQL v9 Service Pack 2 includes a suite of useful utilities for every phase of database management from engine installation and configuration to data maintenance. They include the following:

Pervasive System Analyzer (PSA)

Pervasive PSQL Control Center (PCC)

SQL Editor

Table Editor

Configuration properties for client and engines

Monitor

Function Executor

Maintenance

Rebuild

License Administrator

ODBC Administrator

Gateway Locator

Printed Documentation

If you received a boxed version of Pervasive PSQL v9 Service Pack 2, your package contains a printed copy of Getting Started With Pervasive PSQL (Server Edition) and the Status Codes and Messages Quick Reference card. You can order a complete hardcopy set of the manuals through the Pervasive Software Sales Team.

Online Documentation

The complete Pervasive PSQL v9 Service Pack 2 documentation set is provided in JavaHelp format. This help also serves as the context-sensitive help for the Pervasive PSQL Control Center.

Documentation Titles

The following titles are included in the online library and are available in hardcopy except where noted:

This book - Getting Started with Pervasive PSQL (Server Edition) - helps you to get Pervasive PSQL v9 Service Pack 2 Server engine running with installation, setup, and basic configuration information based on your operating environment.

Getting Started with Pervasive PSQL (Workgroup Edition) - helps you to get Pervasive PSQL v9 Service Pack 2 Workgroup engine running with installation, setup, and basic configuration information based on your operating environment. This title is not available in hardcopy.

Pervasive Products and Services - provides an overview of Pervasive Software products and services, including support options and information regarding licensing and registration. This manual also describes the database and product architectures.

Pervasive PSQL User's Guide - gives basic information on the utilities provided with the Pervasive PSQL Control Center, including several interactive wizards designed to help you accomplish basic database tasks. This manual also contains information on the Linux database engine and the utilities available for that particular platform.

SQL Engine Reference - provides database programmers a complete reference guide to the SQL relational database language supported in Pervasive PSQL v9 Service Pack 2.

Advanced Operations Guide - details tasks typically performed by Network or System Administrators, using various tools such as the Rebuild, Maintenance, Monitor, and Function Executor utilities.

Status Codes and Messages - lists the error and informational codes and messages that can be received when using Pervasive software.

Installation Options

On Windows operating systems and the NetWare operating system, Pervasive PSQL v9 Service Pack 2 offers Complete and Custom installation options. You can accept default installation parameters by selecting the Complete install, or you can specify certain installation parameters by selecting the Custom install option. The following sections outline the major differences in these two installation options. (On Linux distributions, each major component has its own separate installation.)

Complete Setup Installation

The Complete installation, which is recommended for most first time users, takes default actions for most operations performed during the installation.

The Complete setup installs the following components:

Database engine (including ODBC interface)

All client requesters (Win32 and MS-DOS requesters)

Pervasive PSQL Control Center and other utilities

Transactional and Relational interfaces

Online documentation in JavaHelp format

Custom Setup Installation

Selecting Custom setup type allows you to specify the program folder name and select the components to install.

During a Custom server installation, the following components are optional:

Pervasive PSQL Control Center and JavaHelp documentation

Other Utilities (except minimum set)

Note
Client installation programs for DOS, Windows, and Linux are not part of the server installation. You must run a separate installation program for Pervasive PSQL clients. See Installing Pervasive PSQL Clients for Windows for more information.

On Windows, the default installation location is C:\PVSW, assuming the Windows system drive is C.

On NetWare, the default installation location is SYS:\SYSTEM.

On Linux, the default installation location is /usr/local/psql.

Installing Over a Previous Version

If you install the Pervasive PSQL Server product over a previous version (update the server), be aware of the following:

An upgrade re-creates the system databases TEMPDB and SYSTEMDB, and the sample database DEMODATA. The upgrade removes all dictionary files and data files associated with TEMPDB, SYSTEMDB, and DEMODATA, including ones you may have added.

If the system database DEFAULTDB exists from a previous installation, it is retained as is. An upgrade does not re-create DEFAULTDB if it already exists.

This information applies to all platforms on which Pervasive PSQL is supported.