Configuration Overview
Configuration is the process by which you provide settings for database engines and clients. You can specify configuration settings in 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 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 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 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 PSQL User's Guide:
•
Starting and Stopping the Server Engine on a Windows Server
•
Starting and Stopping the Database Engine on Linux and OS X
To stop and start a Workgroup engine, see Starting and Stopping the Workgroup Engine on Windows in 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 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.