After Installing PSQL on Linux or OS X

After Installing PSQL on Linux or OS X

The following topics are useful to review after you install PSQL:

•

Verifying Installed Products with RPM

•

Server Configuration

•

Client Configuration

•

•

Common Questions After Installation

Verifying Installed Products with RPM

The following table provides commands with which you can verify which packages the RPM packager installed. The commands are case sensitive.

Table 18

RPM Commands To Verify PSQL Packages Installed

RPM Command to Verify Installation

rpm -q PSQL-Client

Returns the specific client version installed (PSQL-Client-release-build).

Client Access 32-bit

rpm -q PSQL-Client-Access

Returns the specific client version installed (PSQL-Client-Access-release-build).

Note: The 32-bit Client Access package is always installed after a 64-bit product.

rpm -qa | grep PSQL

Verifying Database Engine is Running

Optionally, after the installation script finishes, you can verify that the database engine is running with the Linux or OS X ps command. To do this, enter the following at a command prompt:

ps -e | egrep mkded

Server Configuration

Generally, the default configuration settings for PSQL Server and Vx Server are sufficient. See Configuration for settings that you may want or need to set.

If you want to explore all of the configuration settings, see the chapter Configuration Reference in Advanced Operations Guide.

Client Configuration

All configuration settings for the PSQL client are discussed in Linux and OS X Client Configuration Parameters in Advanced Operations Guide.

In this guide, see also Installing PSQL Clients for Windows and Configuring Network Communications for Clients for additional information about clients.

Linux and OS X Clients and the Monitor Utility

This information applies only to Linux or OS X clients that use a static IP address. Ignore this subsection if you use DHCP and have a DSN to resolve named addresses.

When you monitor clients using the PSQL Monitor utility, the client IP address that gets transmitted across the network originates from the hosts file. If the system name and IP have not been added to the hosts file, network communication uses the local host IP address, which is 127.0.0.1 or ::1 (a loopback address).

If you change the loopback address to the correct IP, or if you add the system name and IP to the hosts file on the client, the client name is displayed correctly in the Monitor utility.

Once you have completed installation, you may need to update your license to increase the user count for PSQL Server, or to increase the session count or data in use limits for PSQL Vx Server. See Increase User Count or Data in Use in PSQL User's Guide

Common Questions After Installation

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

•

Where Do Files Reside After Installing PSQL?

•

How Do I Access the Documentation?

•

What If I Get Errors Trying to Start the Utilities?

Where Do Files Reside After Installing PSQL?

The following table lists the primary directories and files that result from installing the PSQL products on Linux or OS X. $PVSW_ROOT refers to the root directory where the files are installed. By default it is set to /usr/local/psql. Unless otherwise noted, the primary directories and files are the same for 32- and 64-bit products.

For an upgrade installation, your existing PSQL files were updated to the latest versions.

Table 19

Primary Directories and Files for PSQL Products Installed on Linux

Path from $PVSW_ROOT

Applies to Installation of

License information

Binary files, executable utilities and so forth

Server and Client

A directory pertaining to files for the utilities and documentation

Server and Client

./data/DEMODATA

Sample PSQL database

Sample Btrieve files, alternate collating sequence file and the DefaultDB system database

Server and Client

PSQL registry of configuration settings (this directory and its subordinate directories)

User passwords file

Master table of database names

Server and Client

Shell scripts for the following:

•

pre-product installation

•

post-product installation

•

pre-product uninstall

•

post-product uninstall

Server and Client

Library of 32-bit shared objects

Server and Client

Library of 64-bit shared objects

Server and Client

Transaction log files directory

Server and Client

Man pages for the command-line utilities

Server and Client

How Do I Access the Documentation?

The documentation installed with PSQL Server includes the following:

•

Man pages for the command line utilities

•

PSQL Documentation Library

•

PSQL Release Notes

Man pages are provided for the command line utilities. To make these man pages available, add $PVSW_ROOT/man to the MANPATH environment variable.

Man pages are installed with PSQL Server, Vx Server, and with PSQL Client. Command line utilities are also covered in the PSQL user documentation.

Documentation Library

The PSQL Documentation Library contains the complete set of user documentation, including the user documentation for the PSQL engine and software developer’s kit, as well as a glossary of database terminology.

The documentation library is integrated into PSQL Control Center (PCC). In the PCC window, you can access the documentation library in the Welcome tab opened from the Help menu or by pressing F1 (Windows) or Shift F1 (Linux).

The release notes in readme_psql.htm contain general information about the release, sometimes including late-breaking advice not yet covered in the user documentation. These release notes are located in the /usr/local/psql/docs/ directory and are linked in the Welcome tab opened from the Help menu in PCC. The PSQL website always posts the most recently updated version of the release notes.

What If I Get Errors Trying to Start the Utilities?

See Starting PCC on Linux in PSQL User's Guide and Starting DDF Builder from a Command Line in DDF Builder User’s Guide.