Configuration Overview
Configuration is the process by which you provide settings for database engines and clients. You can specify configuration settings in Pervasive PSQL Control Center (PCC) or with a command line interface (CLI) utility.
In PCC, the configuration settings are properties of the engine or client. See
To access configuration settings in PCC for an engine
and
To access configuration settings in PCC for a local client
.
Configuring any components is optional. If you do not configure them, each component loads with default configuration settings. For best results, you should use only the version of PCC that is the same version as your client and engine components.
You can use configuration for the following reasons:
•
Your system or your Pervasive PSQL application requires you to adjust the settings. Refer to your application documentation for recommended values. If you are running multiple applications concurrently, add the recommended values together. If you are running multiple applications sequentially, use the highest recommended value.
•
You want to optimize the settings so that Pervasive PSQL provides the services you need without using more memory than necessary. (The stated memory requirements provide guidelines for optimizing your computer’s resources.)
The configuration settings themselves are discussed in
Configuration Reference
.
Ensuring Configuration Changes Take Effect
Some engine configuration settings require that you restart the database engines after the setting is changed. Restarting the engines ensures that the setting takes effect. Each setting in this chapter lists whether a database engine restart is required. Also, PCC informs you with a popup message if a changed setting requires an engine restart.
The CLI utility also informs you provided that you changed the setting from the command line rather by using an input file. Use of an input file always requires that you restart the engines. See
Configuration Through CLI Utility
.
To stop and start a server database engine from the command line, see the following topics in
Pervasive PSQL User's Guide
:
•
Starting and Stopping the Server Engine on a Windows Server
•
Starting and Stopping the Database Engine on Linux
To stop and start a Workgroup engine, see
Starting and Stopping the Workgroup Engine on Windows
in
Pervasive PSQL User's Guide
.
In addition, changing client parameters often requires the client to be restarted. To re-load the client, simply exit all applications that depend on Pervasive PSQL and restart them.
Connecting to Different Machines
You can configure both local and remote engines as well as local client components; however, each engine must be configured separately. See
Configuration Through PCC
and
Configuration Through CLI Utility
.
When you are connected to a remote machine with PCC, you can view and change only engine components. Client components (such as on workgroup and workstation engines and client machines) can only be configured locally on each machine.