7-12 PPAS

7-12 PPAS

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.

  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.

State

Agent command

Description

Note

State

Agent command

Description

Note

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.

Attribute

Description

Type

Default

Edit

Attribute

Description

Type

Default

Edit

DBName

Instance name of a PPAS database.

STRING

 

X

Port

Server port of a database.

STRING

 

X

DoQuery

Checks state of instance.

BOOLEAN

true

O

PostgressHome

Directory path where PPAS program is installed

STRING

 

O

User

User's account to run PPAS

STRING

 

O

DBAAccount

DBA account to run commands related to PPAS

STRING

 

O

Password

Password of the DBA account

PASSWORD

 

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.