Go to main content
oracle home
Oracle
®
Solaris Cluster Data Service for PostgreSQL Guide
Exit Print View
Search Term
Search Scope:
This Document
Entire Library
» ...
Documentation Home
»
Oracle Solaris Cluster 4.3
»
Oracle
®
Solaris Cluster Data ...
»
Index C
Updated: June 2017
Oracle
®
Solaris Cluster Data Service for PostgreSQL Guide
Document Information
Using This Documentation
Product Documentation Library
Feedback
Chapter 1 Installing and Configuring HA for PostgreSQL
HA for PostgreSQL Overview
Overview of Installing and Configuring HA for PostgreSQL
Planning the HA for PostgreSQL Installation and Configuration
PostgreSQL and Oracle Solaris Zones
PostgreSQL WAL Shipping
Configuration Restrictions
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 for Solaris Zones Configuration
Restriction for the PostgreSQL WAL File Shipping Without Shared Storage
Configuration Requirements
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 the Global Zone
How to Install and Configure PostgreSQL in the Global Zone
How to Enable a Non-Global Zone to Run PostgreSQL in an HA for Solaris Zones Configuration
How to Install and Configure PostgreSQL in an HA for Solaris Zones Configuration
Verifying the Installation and Configuration of PostgreSQL
How to Verify the Installation and Configuration of PostgreSQL
Installing the HA for PostgreSQL Package
How to Install the HA for PostgreSQL Package
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
How to Prepare Your PostgreSQL for Oracle Solaris Cluster Registration in the Global Zone
How to Prepare Your PostgreSQL for Oracle Solaris Cluster Registration in an HA for Solaris Zones Configuration
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 Oracle 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
Debugging HA for PostgreSQL
How to Activate Debugging for HA for PostgreSQL
Appendix A Files for Configuring Oracle Solaris Cluster HA for PostgreSQL Resources
Listing of pgs_config
Listing of rolechg_config
Appendix B Deployment Example: Installing PostgreSQL in the Global Zone or a Zone Cluster
Target Cluster Configuration
Software Configuration
Assumptions
Installing and Configuring PostgreSQL on Shared Storage in the Global Zone or a Zone Cluster
Example: Preparing the Cluster for PostgreSQL
Example: Configuring Cluster Resources for PostgreSQL
Example: Modifying the PostgreSQL Configuration File
Example: Building and Installing the PostgreSQL Software on Shared Storage
Example: Enabling the PostgreSQL Software to Run in the Cluster
Installing the PostgreSQL Binaries in the Default Directory (Alternative Installation)
Example: Building and Installing the PostgreSQL Software in the Default Directory in the Global Zone
Appendix C Deployment Example: Installing PostgreSQL in a Non-Global Zone With HA for Solaris Zones
Target Cluster Configuration
Software Configuration
Assumptions
Installing and Configuring PostgreSQL on Shared Storage in a Non-Global Zone with HA for Solaris Zones
Example: Preparing the Cluster for PostgreSQL
Example: Configuring Cluster Resources for PostgreSQL
Example: Configuring HA for Solaris Zones
Example: Modifying the PostgreSQL Configuration File
Example: Building and Installing the PostgreSQL Software on Shared Storage in a Non-Global Zone With HA for Solaris Zones
Example: Enabling the PostgreSQL Software to Run in the Cluster
Installing the PostgreSQL Binaries in the Default Directory in a Non-Global Zone With HA for Solaris Zones (Alternative Installation)
Example: Building and Installing the PostgreSQL Software in the Default Directory in a Non-Global Zone With HA for Solaris Zones
Appendix D Deployment Example: Installing PostgreSQL in the Global Zone Using WAL File Shipping
Target Cluster Configuration
Software Configuration
Assumptions
Installing and Configuring PostgreSQL on Shared Storage in the Global Zone
Example: Preparing the Cluster for PostgreSQL
Example: Configuring Cluster Resources for PostgreSQL
Example: Modifying the PostgreSQL Configuration File
Example: Building and Installing the PostgreSQL Software on Shared Storage
Example: Enabling the PostgreSQL Software to Run in the Cluster
Index
Index C
Index D
Index E
Index F
Index H
Index I
Index O
Index P
Index R
Index S
Index T
Index V
Index W
Language:
English
Index
C
commands
clreslogicalhostname
How to Enable a Non-Global Zone to Run PostgreSQL in an HA for Solaris Zones Configuration
How to Enable a PostgreSQL Database to Run in the Global Zone
clresource
How to Create and Enable Resources for PostgreSQL
How to Enable a Non-Global Zone to Run PostgreSQL in an HA for Solaris Zones Configuration
How to Enable a PostgreSQL Database to Run in the Global Zone
clresourcegroup
How to Enable a Non-Global Zone to Run PostgreSQL in an HA for Solaris Zones Configuration
How to Enable a Non-Global Zone to Run PostgreSQL in an HA for Solaris Zones Configuration
How to Enable a PostgreSQL Database to Run in the Global Zone
How to Enable a PostgreSQL Database to Run in the Global Zone
clresourcetype
How to Enable a Non-Global Zone to Run PostgreSQL in an HA for Solaris Zones Configuration
How to Enable a PostgreSQL Database to Run in the Global Zone
configuration files
Registering and Configuring HA for PostgreSQL
pg_hba.conf
How to Prepare Your PostgreSQL for Oracle Solaris Cluster Registration in an HA for Solaris Zones Configuration
pgs_config
PostgreSQL resource
Registering and Configuring HA for PostgreSQL
postgresql.conf
How to Prepare Your PostgreSQL for Oracle Solaris Cluster Registration in an HA for Solaris Zones Configuration
How to Prepare Your PostgreSQL for Oracle Solaris Cluster Registration in the Global Zone
WAL file shipping without shared storage
Specifying Configuration Files for WAL File Shipping Without Shared Storage
configuration requirements
Configuration Requirements
configuration restrictions
Configuration Restrictions
D
debugging
HA for PostgreSQL
Debugging HA for PostgreSQL
dependency, component
Dependencies Between HA for PostgreSQL Components
deployment examples
PostgreSQL in a non-global zone
Deployment Example: Installing PostgreSQL in a Non-Global Zone With HA for Solaris Zones
PostgreSQL in a zone cluster
Deployment Example: Installing PostgreSQL in the Global Zone or a Zone Cluster
PostgreSQL in the global zone
Deployment Example: Installing PostgreSQL in the Global Zone or a Zone Cluster
PostgreSQL in the global zone using WAL file shipping
Deployment Example: Installing PostgreSQL in the Global Zone Using WAL File Shipping
PostgreSQL using HA for Solaris Zones
Deployment Example: Installing PostgreSQL in a Non-Global Zone With HA for Solaris Zones
E
enabling resource group
How to Enable a Non-Global Zone to Run PostgreSQL in an HA for Solaris Zones Configuration
How to Enable a PostgreSQL Database to Run in the Global Zone
examples
PostgreSQL in a non-global zone
Deployment Example: Installing PostgreSQL in a Non-Global Zone With HA for Solaris Zones
PostgreSQL in a zone cluster
Deployment Example: Installing PostgreSQL in the Global Zone or a Zone Cluster
PostgreSQL in the global zone
Deployment Example: Installing PostgreSQL in the Global Zone or a Zone Cluster
PostgreSQL in the global zone using WAL file shipping
Deployment Example: Installing PostgreSQL in the Global Zone Using WAL File Shipping
PostgreSQL using HA for Solaris Zones
Deployment Example: Installing PostgreSQL in a Non-Global Zone With HA for Solaris Zones
extension properties
effect on fault monitor
Tuning the HA for PostgreSQL Fault Monitor
F
fault monitor
operation
Operation of the HA for PostgreSQL Parameter File
tuning
Tuning the HA for PostgreSQL Fault Monitor
H
HA for PostgreSQL
debugging
Debugging HA for PostgreSQL
fault monitors
Tuning the HA for PostgreSQL Fault Monitor
installing
Installing the HA for PostgreSQL Package
registering resources
How to Create and Enable Resources for PostgreSQL
software package, installing
Installing the HA for PostgreSQL Package
verifying installation
Verifying the HA for PostgreSQL Installation and Configuration
I
installing
HA for PostgreSQL
Installing the HA for PostgreSQL Package
PostgreSQL
Installing and Configuring PostgreSQL
O
Oracle Solaris Cluster software
publisher
How to Install the HA for PostgreSQL Package
How to Install the HA for PostgreSQL Package
overview
installation
Overview of Installing and Configuring HA for PostgreSQL
product
HA for PostgreSQL Overview
P
package
Installing the HA for PostgreSQL Package
parameter file
Parameter File for HA for PostgreSQL
parameters
Rolechanger resource
Specifying the Parameters for the Rolechanger Resource
PostgreSQL application
fault monitor
Tuning the HA for PostgreSQL Fault Monitor
PostgreSQL, WAL shipping
PostgreSQL WAL Shipping
publisher
Oracle Solaris Cluster software
How to Install the HA for PostgreSQL Package
How to Install the HA for PostgreSQL Package
R
register
sczbt_register
How to Create and Enable Resources for PostgreSQL
resource group
enabling
How to Enable a Non-Global Zone to Run PostgreSQL in an HA for Solaris Zones Configuration
How to Enable a PostgreSQL Database to Run in the Global Zone
resource types
fault monitor
Tuning the HA for PostgreSQL Fault Monitor
resources
PostgreSQL application debugging
Debugging HA for PostgreSQL
S
software package
Installing the HA for PostgreSQL Package
standard properties
effect on fault monitors
Tuning the HA for PostgreSQL Fault Monitor
T
tuning
fault monitors
Tuning the HA for PostgreSQL Fault Monitor
V
verifying installation
HA for PostgreSQL
Verifying the HA for PostgreSQL Installation and Configuration
PostgreSQL
Verifying the Installation and Configuration of PostgreSQL
W
WAL file shipping
deployment examples
Deployment Example: Installing PostgreSQL in the Global Zone Using WAL File Shipping
without shared storage
Specifying Configuration Files for WAL File Shipping Without Shared Storage
Previous