Table of Contents Previous Next


3 Database Administration : 3.1 Configuration Parameters : 3.1.3 Configuration Parameters by Functionality : 3.1.3.8 Client Connection Defaults / Locale and Formatting

3.1.3.8.1 icu_short_form
Range: n/a
The configuration parameter icu_short_form is a parameter containing the default ICU short form name assigned to a database or to the Advanced Server instance. See Section 3.6 for general information about the ICU short form and the Unicode Collation Algorithm.
This configuration parameter is set either when the CREATE DATABASE command is used with the ICU_SHORT_FORM parameter (see Section 3.6.3.2) in which case the specified short form name is set and appears in the icu_short_form configuration parameter when connected to this database, or when an Advanced Server instance is created with the initdb command used with the --icu_short_form option (see Section 3.6.3.3) in which case the specified short form name is set and appears in the icu_short_form configuration parameter when connected to a database in that Advanced Server instance, and the database does not override it with its own ICU_SHORT_FORM parameter with a different short form.
Once established in the manner described, the icu_short_form configuration parameter cannot be changed.
Range: 10 to 100
Sets the fillfactor for a table when the FILLFACTOR storage parameter is omitted from a CREATE TABLE command.
The fillfactor for a table is a percentage between 10 and 100. 100 (complete packing) is the default. When a smaller fillfactor is specified, INSERT operations pack table pages only to the indicated percentage; the remaining space on each page is reserved for updating rows on that page. This gives UPDATE a chance to place the updated copy of a row on the same page as the original, which is more efficient than placing it on a different page. For a table whose entries are never updated, complete packing is the best choice, but in heavily updated tables smaller fillfactors are appropriate.
3.1.3.10.1 oracle_home
Range: n/a
Before creating an Oracle Call Interface (OCI) database link to an Oracle server, you must direct Advanced Server to the correct Oracle home directory. Set the LD_LIBRARY_PATH environment variable on Linux (or PATH on Windows) to the lib directory of the Oracle client installation directory.
For Windows only, you can instead set the value of the oracle_home configuration parameter in the postgresql.conf file. The value specified in the oracle_home configuration parameter will override the Windows PATH environment variable.
The LD_LIBRARY_PATH environment variable on Linux (PATH environment variable or oracle_home configuration parameter on Windows) must be set properly each time you start Advanced Server.
For Windows only: To set the oracle_home configuration parameter in the postgresql.conf file, edit the file, adding the following line:
oracle_home = 'lib_directory'
After setting the oracle_home configuration parameter, you must restart the server for the changes to take effect. Restart the server from the Windows Services console.
3.1.3.10.2 odbc_lib_path
Range: n/a
odbc_lib_path = 'complete_path_to_libodbc.so'

3 Database Administration : 3.1 Configuration Parameters : 3.1.3 Configuration Parameters by Functionality : 3.1.3.8 Client Connection Defaults / Locale and Formatting

Table of Contents Previous Next