3.2 Configuring a Package Installation

Table of Contents Previous Next


3 Using a Package Manager to Install Advanced Server : 3.2 Configuring a Package Installation

The Advanced Server RPM package creates the ppas-9.4 service configuration file (see Figure 3.5) in /etc/sysconfig/ppas. The file contains environment variables that specify default values that are used by the service startup script when initializing a database and configuring the service for use.
PGENGINE specifies the location of the engine and utility executable files.
PGPORT specifies the listener port for the database server.
PGDATA specifies the path to the data directory.
PGLOG specifies the location of the log file to which the server writes startup information.
Use the INITDBOPTS variable to specify any initdb option or options that you wish to apply to the new cluster.
By default, the INITDBOPTS variable is commented out; when you run the service startup script, the new cluster will be created in Oracle 互換性 mode. Clusters created in Oracle 互換性 mode will contain a database named EDB, and have a database superuser named enterprisedb
To create a new cluster in PostgreSQL mode, remove the pound sign (#) in front of the INITDBOPTS variable, enabling the "--no-redwood-compat" option. Clusters created in PostgreSQL mode will contain a database named postgres, and have a database superuser named enterprisedb.
You may specify multiple initdb options. For example, the following statement:
Creates a database cluster (without compatibility features for Oracle) that contains a database named postgres that is owned by a user named alice; the cluster uses UTF-8 encoding.
To view a list of valid initdb options, open a command line, assume superuser privileges, and enter the command:
For more information about using initdb, see the PostgreSQL Core Documentation, available at:
You can modify the ppas-9.4 file before invoking the startup script to change the listener port, data directory location, startup log location or installation mode. Note that if you plan to create more than one instance on the same system, you may wish to copy the ppas-9.4 file (and the associated startup script that resides in /etc/init.d), and modify the file contents for each additional instance that resides on the same host.
Please note that the options in the service configuration file are only enforced if initdb is invoked via the service command; if you manually invoke initdb (at the command line), you must specify the other options (such as the data directory and installation mode) on the command line.

3 Using a Package Manager to Install Advanced Server : 3.2 Configuring a Package Installation

Table of Contents Previous Next