1. Installing and Configuring HA for PostgreSQL
Overview of Installing and Configuring HA for PostgreSQL
Planning the HA for PostgreSQL Installation and Configuration
PostgreSQL and Solaris Containers
Restriction for the Location of the Database Cluster
Restriction for the Listening Policy of the PostgreSQL Database Server
Restriction for the PostgreSQL postgresql.conf File
Restriction for the Password Policy for the HA for PostgreSQL Monitoring Database
Restriction for the PostgreSQL smf Service Name in an HA Container
Restriction for the PostgreSQL WAL File Shipping Without Shared Storage
Dependencies Between HA for PostgreSQL Components
Parameter File for HA for PostgreSQL
Configuration Requirements for the WAL File Shipping Without Shared Storage Configuration
Installing and Configuring PostgreSQL
How to Enable a PostgreSQL Database to Run in a Global Zone Configuration
How to Install and Configure PostgreSQL in a Global Zone
How to Enable a Zone to Run PostgreSQL in a Zone Configuration
How to Install and Configure PostgreSQL in a Zone
How to Enable a Zone to Run PostgreSQL in an HA Container Configuration
How to Install and Configure PostgreSQL in an HA Container
Verifying the Installation and Configuration of PostgreSQL
How to Verify the Installation and Configuration of PostgreSQL
Registering and Configuring HA for PostgreSQL
Specifying Configuration Parameters for the PostgreSQL Resource
Specifying the Parameters for the Rolechanger Resource.
Specifying Configuration Files for WAL File Shipping Without Shared Storage
Preparing Your PostgreSQL Installation for Cluster Control
Creating and Enabling Resources for PostgreSQL
How to Create and Enable Resources for PostgreSQL
How to Modify Parameters in the HA for PostgreSQL Manifest
How to Remove a HA for PostgreSQL Resource From an HA Container
How to Create and Enable Resources for PostgreSQL Rolechanger
Verifying the HA for PostgreSQL Installation and Configuration
How to Verify the HA for PostgreSQL Installation and Configuration
How to Verify the Solaris Cluster HA for PostgreSQL WAL File Shipping Installation and Configuration
Tuning the HA for PostgreSQL Fault Monitor
Operation of the HA for PostgreSQL Parameter File
Operation of the Fault Monitor for HA for PostgreSQL
How to Activate Debugging for HA for PostgreSQL
A. Files for Configuring Solaris Cluster HA for Solaris PostgreSQL Resources
B. Deployment Example: Installing PostgreSQL in the Global Zone
C. Deployment Example: Installing PostgreSQL in a Non-Global HA Container
D. Deployment Example: Installing PostgreSQL in a Non-Global Zone
E. Deployment Example: Installing PostgreSQL in the Global Zone Using WAL File Shipping
If you did not install the HA for PostgreSQL packages during your initial Oracle Solaris Cluster installation, perform this procedure to install the packages. To install the packages, use the installer program.
Note - You need to install the HA for PostgreSQL packages in the global cluster and not in the zone cluster.
Perform this procedure on each cluster node where you are installing the HA for PostgreSQL packages.
You can run the installer program with a command-line interface (CLI) or with a graphical user interface (GUI). The content and sequence of instructions in the CLI and the GUI are similar.
Note - Even if you plan to configure this data service to run in non-global zones, install the packages for this data service in the global zone. The packages are propagated to any existing non-global zones and to any non-global zones that are created after you install the packages.
Before You Begin
Ensure that you have the Oracle Solaris Cluster installation media.
If you intend to run the installer program with a GUI, ensure that your DISPLAY environment variable is set.
If the Volume Management daemon vold(1M) is running and configured to manage DVD-ROM devices, the daemon automatically mounts the DVD-ROM on the /cdrom directory.
# cd /cdrom/cdrom0/Solaris_sparc
# cd /cdrom/cdrom0/Solaris_x86
# ./installer
English language support is always installed.
Choose Configure Later to perform the configuration after the installation.
The installation wizard displays the status of the installation. When the installation is complete, the wizard displays an installation summary and the installation logs.
The Product Registration option is not available with the CLI. If you are running the installation wizard with the CLI, omit this step.
# eject cdrom
Next Steps
See Registering and Configuring HA for PostgreSQL to register HA for PostgreSQL and to configure the cluster for the data service.