Creating the PostgreSQL Hierarchy

If you have an existing PosgreSQL database cluster installed, you may need to close any client applications (local or remote) that are accessing the PostgreSQL database cluster prior to completing this procedure. Closing all client connections is required if any of the following conditions exist:

• 
  
• The PostgreSQL database cluster data directory does not reside on a protected volume. To be highly available the PostgreSQL data directory must reside on a protected volume that can be switched between nodes in the LifeKeeper cluster. This will require manually moving the data directory prior to creating the resource hierarchy. Once the move is complete, restart the PostgreSQL database cluster services.
  

  
  

• The PostgreSQL Server instance is not controlled by an existing Windows service. To facilitate the administration of the protected PostgreSQL Server, the hierarchy create will create a Windows service if one does not already exist. This requires stopping and restarting the PostgreSQL database cluster services.
  

  
  

• The postmaster process is not running with the “-p port” option. See Configuring the Postmaster Port Argument for more information on how to verify and start PostgreSQL with the postmaster port argument.

Enter the Windows Service Name for this instance.

If the name entered is an existing PostgreSQL service, then the PostgreSQL Recovery Kit will use the service information to pull information for the resource creation.

If the name entered is not an existing PostgreSQL service, then the create process will require additional inputs in order to create a Windows Service using the entered name.

Note: If a Windows Service is created during the PostgreSQL resource create, then a delete of the PostgreSQL resource will remove the PostgreSQL service. If the PostgreSQL service already exists at create time, then a delete of PostgreSQL resource will not remove the service.

Enter a unique tag name, or you can accept the default tag name offered by SPS.

Note: The tag name must consist of printable ASCII characters.

Enter the user password to be used for the logon credentials for the new PostgreSQL Windows Service.

Note: If built-in system accounts (e.g. “Local System” or “Network Service”) are used, enter any non-blank value into this field (blank is not allowed). For built-in accounts, the password is ignored.