7-12 PPAS

Owned by Copy Page Tree
Last updated: 2018/04/16 by 정은진
2 min read

This resource controls the PPAS and detects whether PPAS is installed on a system or not, also controls relevant services and monitors their status.

이 페이지의 주요 내용

Adding

Choose a type of PPAS resource on the Add Resource wizard.

  1. Home directory of PPAS: Inputs a path of the directory where PPAS has been installed.
  2. PPAS user: Inputs a user's account to run a database service.

    The account should be the same as those of owner of the home directory.

  3. Name of PPAS database: Inputs a name of a database for easy identification.

    [Figure] Add PPAS Resource screen


Deleting

To delete a resource, click the resource → right click → choose the Delete Resource.


State

The following table describes MCCS resources' status conversion occurred by state changes or user's commands.

PPAS agent: Manages PPAS registered for MCCS.

StateAgent commandDescriptionNote

Online

 

PPAS is on running. Indicates the status of instance is OPEN if the DoQuery attribute is true.

Offline

Stop a PPAS service.

e.g.) pg_ctl stop -mf -w

Before stopping the PPAS service, stop all backups if there is any backup on progressing.


Monitoring

Detects whether PPAS process is on running or not.

In the case that the DoQuery attribute is "True", it checks if state of PPAS instance is "OPEN", and if not, it considers state of the process as no response.


Offline

 

Indicates that all processes configure the PPAS service have been terminated.

Online

Start the PPAS service.

e.g.) pg_ctl start -w

 If there is any backup which has not been completed, terminate the backup and then retry OPEN, i.e., opening the instance.


Monitoring

Detects whether PPAS process is on running or not. In the case that the DoQuery attribute is "True", it checks instance's state, and if "OPEN", it terminates PPAS.


Fault

 

Indicates that its state has been converted from online into offline, although it has never been terminated.

Online

Start the PPAS service.

e.g.) pg_ctl start -w

If there is any backup which has not been completed, terminate the backup and then retry "OPEN", i.e., opening the instance.


Offline

Stop a PPAS service.

Before stopping the PPAS service, stop all backups if there is any backup on progressing.


Clean
  1. Terminate all processes if all of PPAS processes are on running.

  2. Force to terminate a process in case that there is any process which has not been shut down although the command to terminate all processes was ran.



Attribute

The following table describes attributes related to PPAS resources.

AttributeDescriptionTypeDefaultEdit
DBNameInstance name of a PPAS database.STRING
X
PortServer port of a database.STRING
X
DoQueryChecks state of instance.BOOLEANtrueO
PostgressHomeDirectory path where PPAS program is installedSTRING
O
UserUser's account to run PPASSTRING
O
DBAAccountDBA account to run commands related to PPASSTRING
O
PasswordPassword of the DBA accountPASSWORD
O

Specified attribute values are normally entered when add the resource, This value can be edited or viewed through 'Specified Attribute' table in the Resource Attributes tab on the detailed information panel

MCCS has function to limit input values against user's input field, and it provides function detects automatically data which is input wrong by user's mistake.