Pervasive PSQL Account Management on Linux
This section discusses information on Linux user accounts with respect to operation of Pervasive PSQL.
After Installation Behavior
•
User psql has no password and can only be accessed through the root account by using the su command.
•
You can access the .bash_profile for user psql with ~psql/.bash_profile.
•
All Pervasive files have user:group ownership psql:pvsw
•
You must be logged in as root to run the start and stop scripts for the Pervasive PSQL engines.
•
You can run utilities on other user accounts if you add the necessary environment variables to the user .bash_profile or system /etc/profile as described in Using Utilities from Users Other than psql.
•
In addition to the instructions outlined in Using Utilities from Users Other than psql, users other than ROOT must be a member of the group pvsw to perform functionality with the following utilities:
•
Pervasive PSQL Control Center (PCC) to administer the local server.
•
License Administrator utility (clilcadm) for functions other than displaying current licenses.
•
Named Database Maintenance utility (dbmaint) for functions other than displaying current databases.
•
Pervasive Services Registry Editor (psregedit) for functions other than displaying the registry.
•
Linux command-line configuration (bcfg).
The User Environment
The single environment variable $PVSW_ROOT is used to determine the location of installed components. The generic location for configuration files are $PVSW_ROOT/etc. For executable files, the location is $PVSW_ROOT/bin. For shared libraries (32-bit) the location is $PVSW_ROOT/lib; for shared libraries (64-bit) the location is $PVSW_ROOT/lib64.
It is recommended that you add $PVSW_ROOT/bin to your PATH environment variable, and $PVSW_ROOT/lib to LD_LIBRARY_PATH as described in the following section.
Using Utilities from Users Other than psql
To use utilities from user accounts other than psql, you must first make modifications to the user account configuration. Add the following to either the profile for a specific user or to the profile that all users inherit.
/home/username/.bash_profile
Profile for the user. Similar to the /etc/profile file but only for the current user.
Look in /home/username for this file.
/etc/profile
Default profile for all user accounts on the system. Copy the lines below into this text file if you want all user accounts on the machine to have access to Pervasive PSQL utilities.
This does not give the users administrative privileges or access to Pervasive PSQL data.
Here is an example of a modified profile:
PVSW_ROOT=/usr/local/psql
PATH=$PATH:$PVSW_ROOT/bin:/bin:/usr/bin
LD_LIBRARY_PATH=$PVSW_ROOT/lib:$PVSW_ROOT/bin:/usr/lib
MANPATH=$MANPATH:$PVSW_ROOT/man
 
Ensure that you export all variables specific to Pervasive PSQL.