Linux and OS X Client Configuration Parameters
You can configure both PSQL Clients and Servers using the graphical utility PSQL Control Center or the command line interface utility bcfg. For PCC, see Using PSQL Control Center in PSQL User's Guide. For bcfg, see Configuration Through CLI Utility.
Case of Configuration Values
When checking or editing the values of settings, the Linux or OS X client performs a case-insensitive comparison. For example, entering Yes or yes for a setting value is interpreted identically by the client.
Client Performance Affected by Local Setting
When the Linux or OS X client interface is first invoked, it populates its default settings in the PSQL registry. The PSQL Client does not have knowledge on whether its installation includes a server engine or not. Therefore, it sets the Local setting to yes. This can have an impact on the performance of your client.
If the machine on which you are using the client does not have a server engine, you should set the local setting to no. See Use Local MicroKernel Engine.
File Names with Embedded Spaces
By default, the Linux and OS X client interface supports file names that contain embedded spaces.
For example:
/mymount/usr/gary/file with spaces.mkd
If you want to use file names without embedded spaces, you need to change the Embedded Spaces setting. See Embedded Spaces.
Configuration Reference
The following table lists the configuration options for the Linux and OS X client.
Table 14
Client Configuration Settings
Configuration Option
Parameter Name
Access
Use Local MicroKernel Engine
Use Remote MicroKernel Engine
Use IDS
Wire Encryption
Wire Encryption Level
Communication Protocols
Enable AutoReconnect
Application Characteristics
Embedded Spaces
Verify Key Length
Access
Access contains the following configuration settings:
•
Use Local MicroKernel Engine
•
Use Remote MicroKernel Engine
•
Use IDS
•
Wire Encryption
•
Wire Encryption Level
Use Local MicroKernel Engine
See Use Local MicroKernel Engine.
Use Remote MicroKernel Engine
See Use Remote MicroKernel Engine.
Remote Engine and UNC Paths
For UNC paths to work properly from a client, the following steps must be performed:
•
You must be running an engine on the same computer as the file that you are trying to access
•
You must set Use Remote MicroKernel Engine to on.
*Note: You cannot send use a UNC path that points to the local Linux or OS X system. However, you can use a path that is in the UNC style such as
//localhost/usr/local/psql/data/samples/sample.btr
If you do not want an engine on your file server (that is, you want to use the client's local engine), then you will need to mount the remote file system on the client, and modify the path so that it is a "native format" path and not UNC format. For example, the following path is a native format on Linux or OS X:
/mnt/myremotedata/sample.btr
Use IDS
See Use IDS.
Wire Encryption
See Wire Encryption.
*Note: Client-side wire encryption settings are not used by the PSQL JDBC and ADO.NET access methods. For them, encryption can be specified using the connection string. See Connection String Overview in JDBC Driver Guide and Defining Basic Connection Strings in Data Provider for .NET Guide.
Wire Encryption Level
See Wire Encryption Level.
*Note: Client-side wire encryption settings are not used by the PSQL JDBC and ADO.NET access methods. For them, encryption can be specified using the connection string. See Connection String Overview in JDBC Driver Guide and Defining Basic Connection Strings in Data Provider for .NET Guide.
Communication Protocols
Communication protocols contains the following configuration setting:
•
Enable AutoReconnect
Enable AutoReconnect
Type
Range
Default
Units
Requires Engine Restart
Boolean
On
Off
Off
None
Not applicable
This setting specifies whether you want the client to attempt to auto-reconnect during a network outage. A setting of on means Auto Reconnect is enabled.
Auto Reconnect is not in effect unless this setting is also enabled in the server configuration.
*Note: The PSQL Linux and OS X client supports this autoreconnect feature, but currently the Linux and OS X server does not. Therefore, you can only use the AutoReconnect (PARC) feature from a Linux or OS X client connecting to a Windows server.
Application Characteristics
Application characteristics contains the following configuration settings:
•
Embedded Spaces
•
Verify Key Length
Embedded Spaces
See Embedded Spaces.
Verify Key Length
See Verify Key Length.