After Installing Pervasive PSQL for Linux
The following topics are useful to review after you install Pervasive PSQL:
•
Verifying Installed Products With RPM
•
Server Configuration
•
Client Configuration
•
User Count License
•
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 14
RPM Commands To Verify Pervasive PSQL Packages Installed
Pervasive PSQL Package
RPM Command to Verify Installation
Server
rpm -q Pervasive.SQL
Vx Server
rpm -q Pervasive.SQL-Vx
Client
rpm -q Pervasive.SQL-Client
The command returns the specific client version installed (Pervasive.SQL-Client-release-build).
All installed
rpm -qa | grep Pervasive
Verifying Database Engine is Running
Optionally, after the installation script finishes, you can verify that the database engine is running with the Linux ps utility. Type the following at the command line:
ps -e | egrep mkded
Server Configuration
Generally, the default configuration settings for Pervasive PSQL 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 Linux client are discussed in Linux Client Configuration Parameters in the Advanced Operations Guide.
In this guide, see also Installing Pervasive PSQL Clients for Windows and Configuring Network Communications for Clients for additional information about clients.
Linux Clients and the Monitor Utility
This information applies only to Linux 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 Linux clients using the Pervasive 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's 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’s name and IP to the “hosts” file on the Linux client, the client name correctly displays when in the Monitor utility.
User Count License
Once you have completed installation, you may need to update your user count license by using the clilcadm utility. The update can be done anytime before using Pervasive PSQL from a client. Information about how to do this can be found in Pervasive PSQL User's Guide (see License Administration). Detailed information about clilcadm can also be found in the Linux man pages. The Pervasive PSQL User's Guide also explains clilcadm (see clilcadm).
*Note: You must be a member of group pvsw to run the clilcadm utility. See Pervasive PSQL Account Management on Linux for more information.
Common Questions After Installation
If you are have problems with your installation, see Troubleshooting After Installation or get help online from the Pervasive Knowledge Base at the Pervasive Web site. The following are common questions after installation of the products:
•
Where Do Files Reside After Installing Pervasive PSQL?
•
How Do I Access the Documentation?
•
What If I Get Errors Trying To Start the Utilities?
Where Do Files Reside After Installing Pervasive PSQL?
The following table lists the primary directories and files that result from installing the Pervasive PSQL products on Linux. $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-bit and 64-bit products.
For an upgrade installation, your existing Pervasive PSQL files were updated to the latest versions.
Table 15
Primary Directories and Files for Pervasive PSQL Products Installed on Linux
Path from $PVSW_ROOT
Primary Files
Description
Applies to Installation of
./
LICENSE
License information
Server
./bin
 
Binary files, executable utilities and so forth
Server and Client
./bin/plugins
 
A directory pertaining to files for the utilities and documentation
Server and Client
./data/DEMODATA
 
Sample Pervasive PSQL database
Server
./data/samples
 
Sample Btrieve files, alternate collating sequence file and the DefaultDB system database
Server
./etc
 
 
Server and Client
 
.PSRegistry
Pervasive registry of configuration settings (this directory and its subordinate directories)
Server
 
btpasswd
User passwords file
Server
 
dbnames.cfg
Master table of database names
Server
 
odbc.ini
ODBC settings
Server and Client
 
 
Shell scripts for the following:
•
pre-product installation
•
post-product installation
•
pre-product uninstall
•
post-product uninstall
Server and Client
./lib
 
Library of 32-bit shared objects
Server and Client
./lib64
 
Library of 64-bit shared objects
Note: This directory exists only if you install the 64-bit Server or Client
Server and Client
./log
 
Transaction log files directory
Server and Client
./man/man1
 
Man pages for the command-line utilities
Server and Client
How Do I Access the Documentation?
The documentation installed with Pervasive PSQL Server includes the following:
•
Man pages for the command-line utilities
•
Pervasive PSQL Documentation Library
•
Pervasive PSQL Release Notes
Man Pages
Man pages are provided for the command-line utilities. To make these man pages available, add $PVSW_ROOT/man to your MANPATH environment variable.
Note that the man pages are installed with Pervasive PSQL Server and with Pervasive PSQL Client. They are not installed as part of the user documentation.
Documentation Library
The Pervasive PSQL Documentation Library contains the complete set of user documentation, including the user documentation for the Pervasive PSQL engine and software developer’s kit, as well as a glossary of database terminology.
►
To view the Pervasive PSQL Documentation Library
1
Open a terminal window.
2
Run one of the following:
a.
As root user
/usr/local/psql/bin/pcc
b.
As the psql user
pcc
Note that the viewer for the documentation library is integrated into Pervasive PSQL Control Center (PCC). The documentation library is accessed through the PCC interface on the Welcome view, in the Help menu, by pressing F1 (Windows) or Shift F1 (Linux).
Release Notes
The release notes in readme_psql.htm contain late-breaking news that could not be included as part of the user documentation. The release notes file is located in the /usr/local/psql/docs/ directory.
What If I Get Errors Trying To Start the Utilities?
See Starting PCC On Linux in Pervasive PSQL User's Guide and Starting DDF Builder from a Command Line in DDF Builder User’s Guide.