This document provides a list of database management tasks for various database systems
including SQL, Oracle, and PostgreSQL. The tasks include checking database status, taking
backups, modifying database parameters, creating and dropping databases, and granting
permissions to users.
Check DB FreeSpace
Fixlet User Friendly Name |
|
Description |
Checks for available free space in the database. |
Check DB Status
Fixlet User Friendly Name |
|
Description |
Checks the status of the database. Requires Get DB status. |
DB Backup
Fixlet User Friendly Name |
|
Description |
Takes the backup of the database. |
Modify Log File Size for DB
Fixlet User Friendly Name |
|
Description |
Changes the maximum size of log file for a particular
database. |
Detach DB
Fixlet User Friendly Name |
|
Description |
Detaches a specified database. |
Drop Clean buffer PNP
Fixlet User Friendly Name |
- SQL_Drop_Clean_buffer_PNP
|
Description |
Cleans buffer of specified database. |
Drop DB
Fixlet User Friendly Name |
|
Description |
Drops a specified database. |
Services Start
Fixlet User Friendly Name |
|
Description |
Checks the status of the service in Database. If the service is
running, it will restart the service else it will start the
service. |
Shrink DB
Fixlet User Friendly Name |
|
Description |
Shrinks a specified database. |
DB Growth PNP
Fixlet User Friendly Name |
|
Description |
Displays the growth of Database. Database growth is PNP
monitored. |
Check Server Connectivity
Fixlet User Friendly Name |
- SQL_Check_Server_Connectivity
|
Description |
Checks SQL Server connectivity. |
DB Log File Growth Rate
Fixlet User Friendly Name |
- SQL_DB_Log_File_Growth_Rate
|
Description |
Gives the report of database log file growth rate of all the
databases in SQL instance. Monitors growth rate of log file. |
MSSQL
Add Database To Availabilty Group
Fixlet User Friendly Name |
- MSSQL_Add_Database_To_Availabilty_Group
|
Description |
Adds a database to an availability group in MSSQL Server. |
MSSQL Backup Transaction Log
Fixlet User Friendly Name |
- MSSQL_Backup_Transaction_Log
|
Description |
Performs a transaction log backup of a MS SQL instance |
MSSQL Change DB Recovery Model
Fixlet User Friendly Name |
- MSSQL_Change_DB_Recovery_Model
|
Description |
Updates/modifies the recovery model for a given MS SQL
instance |
MSSQL Check DB Integrity
Fixlet User Friendly Name |
|
Description |
Performs a database integrity check against a specified database
on a given MS SQL instance |
MSSQL Check Instance
Fixlet User Friendly Name |
|
Description |
Displays the MS SQL Server instance version |
MSSQL Check Service Status
Fixlet User Friendly Name |
- MSSQL_Check_Service_Status
|
Description |
Checks and validates the status of the MS SQL Service |
MSSQL Create Database
Fixlet User Friendly Name |
|
Description |
Creates a new database in the MS SQL Server |
MSSQL Create Login
Fixlet User Friendly Name |
|
Description |
Creates new SQL login for a given user and the password is sent
to their email ID. The user is granted access on the master
database. |
MSSQL Disable All DB Constraints
Fixlet User Friendly Name |
- MSSQL_Disable_All_DB_Constraints
|
Description |
Disables all constraints for a specified database residing on a
given MS SQL server instance |
MSSQL Display Database
Performance
Fixlet User Friendly Name |
- MSSQL_Display_Database_Performance
|
Description |
Displays the performance of all the databases |
MSSQL Enable All DB Constraints
Fixlet User Friendly Name |
- MSSQL_Enable_All_DB_Constraints
|
Description |
Enables all the constraints for a specified database residing on
a given MS SQL server instance |
MSSQL Enable Deadlock Tracing
Fixlet User Friendly Name |
- MSSQL_Enable_Deadlock_Tracing
|
Description |
Activates and enables deadlock tracing on MS SQL Server |
MSSQL Fetch DB IOPs Consumption
Fixlet User Friendly Name |
- MSSQL_Fetch_DB_IOPs_Consumption
|
Description |
Retrieves and displays input-output consumption of all databases
residing on a given MS SQL Server |
MSSQL Grant BulkAdmin To Login
Fixlet User Friendly Name |
- MSSQL_Grant_BulkAdmin_To_Login
|
Description |
Grants bulk admin role to a given user on a MS SQL instance |
MSSQL Grant Login Roles
Fixlet User Friendly Name |
|
Description |
Grants multiple roles to a given user. Role names need to be
provided in a comma separated format |
MSSQL Grant Read Write
Permissions
Fixlet User Friendly Name |
- MSSQL_Grant_Read_Write_Permissions
|
Description |
Provides read and write permissions to a given MS SQL user |
MSSQL Index Management
Fixlet User Friendly Name |
|
Description |
Automatically analyzes and defragments indexes for index
management of databases. Also rebuilds/reorganizes all indexes of
the table. |
MSSQL Latest Backup Check
Fixlet User Friendly Name |
- MSSQL_Latest_Backup_Check
|
Description |
Checks for and displays last backup taken for given or all MS
SQL servers |
MSSQL Modify Compatibility Level
Fixlet User Friendly Name |
- MSSQL_Modify_Compatibility_Level
|
Description |
Updates and modifies the compatibility number for the given MS
SQL databases |
MSSQL Monitor SQL Service Send Mail
If Down
Fixlet User Friendly Name |
- MSSQL_Monitor_SQL_Service_Send_Mail_If_Down
|
Description |
Allows for monitoring of MS SQL services and will send a mail if
any of the services are found to not be working |
MSSQL Remove Databases From
Availabilty Group
Fixlet User Friendly Name |
- MSSQL_Remove_Databases_From_Availability_Group
|
Description |
Removes/deletes a database from an availability group in MS
SQL |
MSSQL START STOP Service Agent
Fixlet User Friendly Name |
- MSSQL_START_STOP_Service_Agent
|
Description |
Enables or disables MS SQL Services on the host server |
MSSQL Update Statistics
Fixlet User Friendly Name |
|
Description |
Runs and executes a query to update the statistics for a given
table or schema of a database |
MSSQL Validate Backup File
Fixlet User Friendly Name |
- MSSQL_Validate_Backup_File
|
Description |
Checks and validates the presence of a backup file for a given
location on the MS SQL server |
Oracle Add Members To Redo Log
Group
Fixlet User Friendly Name |
- Oracle_Add_Members_To_Redo_Log_Group
|
Description |
Adds members to redo log groups in the Oracle Database. |
Oracle Add Parameters In
ParamFile
Fixlet User Friendly Name |
- Oracle_Add_Paramaters_In_ParamFile
|
Description |
Adds new parameters in the param file of the Oracle Database |
Oracle Alter Profile
Fixlet User Friendly Name |
|
Description |
Changes the value of a specified resource of a given profile in
the Oracle Database |
Oracle Assign Profile To User
Fixlet User Friendly Name |
- Oracle_Assign_Profile_To_User
|
Description |
Assigns a specified profile to a given user in Oracle |
Oracle Audit Data
Fixlet User Friendly Name |
|
Description |
Generates an audit data report in Oracle |
Oracle Change Database Name
Fixlet User Friendly Name |
- Oracle_Change_Database_Name
|
Description |
Changes/modifies the database name in Oracle. |
Oracle Check Backup Status
Fixlet User Friendly Name |
- Oracle_Check_Backup_Status
|
Description |
Checks the status of the back up of any given database in
Oracle |
Oracle Check Blocking Sessions
Fixlet User Friendly Name |
- Oracle_Check_Blocking_Sessions
|
Description |
Lists details of any blocking sessions, if any, in Oracle. |
Oracle Check Database
Performance
Fixlet User Friendly Name |
- Oracle_Check_Database_Performance
|
Description |
Checks and displays the Oracle Database performance in terms of
CPU usage, memory usage, and wait events along with the status of
the specified database |
Oracle Check Database Status
Fixlet User Friendly Name |
- Oracle_Check_Database_Status
|
Description |
Checks and displays the Oracle database mode/status |
Oracle Check If Process Crossed
Threshold
Fixlet User Friendly Name |
- Oracle_Check_If_Process_Crossed_Threshold
|
Description |
Checks and displays any processes that are utilising more of the
CPU than the defined threshold. |
Oracle Check Listener Status
Fixlet User Friendly Name |
- Oracle_Check_Listener_Status
|
Description |
Validates and displays Oracle listener status |
Oracle Compile Invalid Function
Fixlet User Friendly Name |
- Oracle_Compile_Invalid_Function
|
Description |
Compiles and lists all the invalid functions in a specified
Oracle instance |
Oracle Compile Invalid Procedure
Fixlet User Friendly Name |
- Oracle_Compile_Invalid_Procedure
|
Description |
Compiles and lists all the invalid procedures in a specified
Oracle instance |
Oracle Create Common Role
Fixlet User Friendly Name |
- Oracle_Create_Common_Role
|
Description |
Creates a common role inside a given container database of
Oracle. It will also grant session access to the newly created
role |
Oracle Create Common User
Fixlet User Friendly Name |
- Oracle_Create_Common_User
|
Description |
Creates a user on a specified container database in an Oracle
instance. Also gives an option to create the user either for all
the containers or for the current one. |
Oracle Create Container Database
Fixlet User Friendly Name |
- Oracle_Create_Container_Database
|
Description |
Creates a new container database in Oracle |
Oracle Create Database
Fixlet User Friendly Name |
|
Description |
Creates a new database in Oracle |
Oracle Create Database Link
Fixlet User Friendly Name |
- Oracle_Create_Database_Link
|
Description |
Creates a database link for a given user and database in
Oracle |
Oracle Create Datafile
Fixlet User Friendly Name |
|
Description |
Creates a new datafile in Oracle |
Oracle Create Directory
Fixlet User Friendly Name |
|
Description |
Creates a new directory for a database in Oracle |
Oracle Create Guarantee Restore
Point
Fixlet User Friendly Name |
- Oracle_Create_Guaranatee_Restore_Point
|
Description |
Creates a restore point for a database in Oracle |
Oracle Create Index
Fixlet User Friendly Name |
|
Description |
Creates a new index in Oracle |
Oracle Create Listener
Fixlet User Friendly Name |
|
Description |
Creates a new listener in Oracle |
Oracle Create Local Role
Fixlet User Friendly Name |
|
Description |
Creates a new local role inside a specified pluggable
database/container of the container database in Oracle |
Oracle Create Local User On PDB
Fixlet User Friendly Name |
- Oracle_Create_Local_User_On_PDB
|
Description |
Creates a local user on a specified pluggable database. Requires
the name of the pluggable database in Oracle to create the new user
on that pluggable database in Oracle |
Oracle Create Mview
Fixlet User Friendly Name |
|
Description |
Creates a materialised view in Oracle |
Oracle Create Password File
Fixlet User Friendly Name |
- Oracle_Create_Password_File
|
Description |
Creates a backup of an existing file and then creates a password
file in Oracle |
Oracle Create pfile
Fixlet User Friendly Name |
|
Description |
Creates a pfile on an Oracle database instance |
Oracle Create Pluggable Database
Fixlet User Friendly Name |
- Oracle_Create_Pluggable Database
|
Description |
Creates a new pluggable database in an Oracle Server |
Oracle Create Profile
Fixlet User Friendly Name |
|
Description |
Creates a new profile with a specified name in an Oracle
Database |
Oracle Create Redo Log Group
Fixlet User Friendly Name |
- Oracle_Create_Redo_Log_Group
|
Description |
Creates a new Redo log group on an Oracle Database |
Oracle Create Refresh MatView
Fixlet User Friendly Name |
- Oracle_Create_Refresh_MatView
|
Description |
Creates and refreshes a materialised view in Oracle |
Oracle Create Role
Fixlet User Friendly Name |
|
Description |
Creates a new role in an Oracle Database |
Oracle Create spfile
Fixlet User Friendly Name |
|
Description |
Creates a new spfile on an Oracle database instance |
Oracle Create Temp Tablespace
Fixlet User Friendly Name |
- Oracle_Create_Temp_Tablespace
|
Description |
Creates a new temporary tablespace of a given name and specified
size in an Oracle Database |
Oracle Create TNS Entry
Fixlet User Friendly Name |
|
Description |
Creates a new TNS Entry in an Oracle server |
Oracle Create Undo Tablespace
Fixlet User Friendly Name |
- Oracle_Create_Undo_Tablespace
|
Description |
Creates a new undo tablespace of a given name and of specific
size in an Oracle Database. Also inserts a new datafile in the
database |
Oracle Datafile Addition Temp
Tablespace
Fixlet User Friendly Name |
- Oracle_Datafile_Addition_Temp_Tablespace
|
Description |
Adds a datafile to a tablespace in an Oracle Database |
Oracle Datafile Move Diff
Location
Fixlet User Friendly Name |
- Oracle_Datafile_Move_Diff_Location
|
Description |
Moves a datafile to a difference location in an Oracle
Database |
Oracle Datafile Resize
Fixlet User Friendly Name |
|
Description |
Resizes a given datafile in Oracle |
Oracle Disable Flashback
Fixlet User Friendly Name |
|
Description |
Disables flashbacks for a given database in Oracle |
Oracle Drop Database
Fixlet User Friendly Name |
|
Description |
Drops/deletes a given database from the Oracle instance |
Oracle Drop Database Link
Fixlet User Friendly Name |
- Oracle_Drop_Database_Link
|
Description |
Drops/deletes a given database link from the Oracle instance |
Oracle Drop Datafile Temp
Tablespace
Fixlet User Friendly Name |
- Oracle_Drop_Datafile_Temp_Tablespace
|
Description |
Drops/deletes a given datafile temporary tablespace from the
Oracle instance |
Oracle Drop Directory
Fixlet User Friendly Name |
|
Description |
Drops/deletes a given directory from the Oracle instance |
Oracle Drop Index
Fixlet User Friendly Name |
|
Description |
Drops/deletes a specified index from the Oracle database
instance |
Oracle Drop Member From Redo Log
Group
Fixlet User Friendly Name |
- Oracle_Drop_Member_From_Redo_Log_Group
|
Description |
Drops/deletes a specified member of a given log group identified
by number in an Oracle Database |
Oracle Drop Mview
Fixlet User Friendly Name |
|
Description |
Drops/deletes a given materialized view from the Oracle
instance |
Oracle Drop PDB
Fixlet User Friendly Name |
|
Description |
Drops/deletes a given pluggable database from the Oracle
instance |
Oracle Drop Profile
Fixlet User Friendly Name |
|
Description |
Drops/deletes a given profile from the Oracle instance |
Oracle Drop Redo Log Group
Fixlet User Friendly Name |
- Oracle_Drop_Redo_Log_Group
|
Description |
Drops/deletes a given Redo log group from the Oracle
instance |
Oracle Drop Restorepoint
Fixlet User Friendly Name |
|
Description |
Drops/deletes a given restore point from the Oracle instance |
Oracle Drop Role
Fixlet User Friendly Name |
|
Description |
Drops/deletes a given role from the Oracle instance |
Oracle Drop Tablespace
Fixlet User Friendly Name |
|
Description |
Drops/deletes a specified tablespace from the Oracle
instance |
Oracle Enable Archivelog Mode
Fixlet User Friendly Name |
- Oracle_Enable_Archivelog_Mode
|
Description |
Enables archive log on an Oracle instance |
Oracle Enable Flashback
Fixlet User Friendly Name |
|
Description |
Enables flashback for a specified database in Oracle |
Oracle Export Fulldatabase
Fixlet User Friendly Name |
- Oracle_Export_Fulldatabase
|
Description |
Exports a full database from the Oracle instance |
Oracle Export Schema
Fixlet User Friendly Name |
|
Description |
Exports schema on an Oracle instance |
Oracle Export Table
Fixlet User Friendly Name |
|
Description |
Exports a specified list of tables to a given directory from the
Oracle distance instance |
Oracle Gather Stats
Fixlet User Friendly Name |
|
Description |
Gathers statistics for an Oracle Database |
Oracle Generate ADDM Report
Fixlet User Friendly Name |
- Oracle_Generate_ADDM_Report
|
Description |
Creates an ADDM report in Oracle |
Oracle Generate AWR Report
Fixlet User Friendly Name |
- Oracle_Generate_AWR_Report
|
Description |
Creates an AWR report in Oracle in HTML format |
Oracle Grant Permission To User On
Table
Fixlet User Friendly Name |
- Oracle_Grant_Permission_To_User_On_Table
|
Description |
Gives mentioned permissions for a table to a user in Oracle |
Oracle Grant System Permission
Fixlet User Friendly Name |
|
Description |
Grants mentioned permissions to a given user for a system in
Oracle. |
Oracle Home Cleanup
Fixlet User Friendly Name |
|
Description |
Performs clean up on a home directory by removing log and trace
files older than one week in Oracle |
Oracle Import Table
Fixlet User Friendly Name |
|
Description |
Imports a specified comma separated list of tables from the
given DBF file and on a given Directory of Oracle database |
Oracle Increase FRA Size
Fixlet User Friendly Name |
|
Description |
Modifies or increases the FRA file size in an Oracle
database |
Oracle Kill User Session
Fixlet User Friendly Name |
|
Description |
Kills a particular session of an Oracle user or all the inactive
sessions of a given user |
Oracle List Top CPU Utilizing
Process
Fixlet User Friendly Name |
- Oracle_List_Top_CPU_Utilizing_Process
|
Description |
Lists the top CPU utilizing processes of Oracle |
Oracle List Top Memory Utilizing
Process
Fixlet User Friendly Name |
- Oracle_List_Top_Memory_Utilizing_Process
|
Description |
Lists the top memory utilizing processes of Oracle |
Oracle List Top Wait Events
Fixlet User Friendly Name |
- Oracle_List_Top_Wait_Events
|
Description |
Lists the top wait events of Oracle |
Oracle Lock User
Fixlet User Friendly Name |
- Oracle_List_Top_CPU_Utilizing_Process
|
Description |
Locks/blocks a given Oracle User |
Oracle Memory Advisor
Fixlet User Friendly Name |
|
Description |
When executed, issues a memory advisory on whether any
additional memory allocation is required for a specified database
of a given Oracle instance to ensure stable operations. |
Oracle Memory Hit Ratio
Fixlet User Friendly Name |
|
Description |
Fetches and displays memory hit ratio in Oracle |
Oracle Monitor Open Cursor
Fixlet User Friendly Name |
- Oracle_Monitor_Open_Cursor
|
Description |
Checks open cursor in Oracle |
Oracle Move Object
Fixlet User Friendly Name |
|
Description |
Moves an object from one tablespace to another in Oracle |
Oracle Perform HealthCheck
Fixlet User Friendly Name |
- Oracle_Perform_HealthCheck
|
Description |
Performs a health check on the Oracle server |
Oracle Put In No Archive Mode
Fixlet User Friendly Name |
- Oracle_Put_In_No_Archive_Mode
|
Description |
Disables archive mode for a given Oracle database instance |
Oracle Quota On Tablespace
Fixlet User Friendly Name |
- Oracle_Quota_On_Tablespace
|
Description |
Allocates/alters the quota on a tablespace in Oracle |
Oracle Rebuild Index
Fixlet User Friendly Name |
|
Description |
Rebuilds a specific index or all indexes of a given table |
Oracle Rebiuld Invalid Indexes
Fixlet User Friendly Name |
- Oracle_Rebuild_Invalid_Indexes
|
Description |
Rebuilds all unusable/invalid indexes of a given database in
Oracle |
Oracle Relocate FRA File
Fixlet User Friendly Name |
|
Description |
Relocates the FRA file to a different location, specified by the
user, in Oracle |
Oracle Remove Or Modify Parameter In
Paramfile
Fixlet User Friendly Name |
- Oracle_Remove_Or_Modify_Parameter_In_Paramfile
|
Description |
Removes or modifies a specified parameter in the parameter file
of Oracle |
Oracle Reorganize Table
Fixlet User Friendly Name |
|
Description |
Reorganizes a specified table in Oracle by rebuilding its
indexes moving it to a different tablespace if needed. |
Oracle Reset Password
Fixlet User Friendly Name |
|
Description |
Resets the password of a given Oracle user |
Oracle Restore Database From Restore
Point
Fixlet User Friendly Name |
- Oracle_Restore_Database_From_Restore_Point
|
Description |
Triggers a flashback restore that restores a specified restore
point of the Oracle database |
Oracle Revoke Permission From User On
Table
Fixlet User Friendly Name |
- Oracle_Revoke_Permsission_From_User_On_Table
|
Description |
Revokes a specified permission from the user against a table in
Oracle |
Oracle Revoke System Permission
Fixlet User Friendly Name |
- Oracle_Revoke_System_Permission
|
Description |
Revokes a specified system permission from the user in
Oracle |
Oracle RMAN Backup Restore
Fixlet User Friendly Name |
- Oracle_RMAN_Backup_Restore
|
Description |
Restores the backup taken by the RMAN utility on the same Oracle
Server |
Oracle Run Adhoc Script
Fixlet User Friendly Name |
|
Description |
Executes an adhoc script supplied as an attachment in the
ticket |
Oracle Shutdown Database
Fixlet User Friendly Name |
|
Description |
Shuts down an Oracle Database |
Oracle Start CDB
Fixlet User Friendly Name |
|
Description |
Starts up a specified container database CDB in Oracle |
Oracle Start Database
Fixlet User Friendly Name |
|
Description |
Starts up the Oracle database using the startup command in
Oracle Server |
Oracle Start Listener
Fixlet User Friendly Name |
|
Description |
Starts the Oracle Listener |
Oracle Start Pluggable Database
Fixlet User Friendly Name |
- Oracle_Start_Pluggable_Database
|
Description |
Starts the pluggable Database in Oracle |
Oracle Stop CDB
Fixlet User Friendly Name |
|
Description |
Stops a specified container database CDB in Oracle |
Oracle Stop Listener
Fixlet User Friendly Name |
|
Description |
Stops the Oracle Listener |
Oracle Stop Pluggable Database
Fixlet User Friendly Name |
- Oracle_Stop_Pluggable_Database
|
Description |
Stops a specified pluggable database in Oracle |
Oracle Take Backup Via RMAN
Fixlet User Friendly Name |
- Oracle_Take_Backup_Via_RMAN
|
Description |
Takes the backup of a given database in Oracle using RMAN
utility on a given mount point |
Oracle Unlock User
Fixlet User Friendly Name |
|
Description |
Unlocks/activates an existing Oracle user |
Oracle Unplug PDB
Fixlet User Friendly Name |
|
Description |
Unplugs and drops/deletes a Pluggable database |
Oracle User Creation
Fixlet User Friendly Name |
|
Description |
Creates a new user in Oracle with a specified name and profile.
If profile name is not provided, then the default profile is
attached to the user |
Oracle Utlrp Script
Fixlet User Friendly Name |
|
Description |
Compiles and lists all invalid objects for an Oracle Database
instance. |
PostGres Alter Group
Fixlet User Friendly Name |
|
Description |
Renames/alters group name or members in PostgreSQL |
PostGres Alter PolicyName
Fixlet User Friendly Name |
|
Description |
Renames/alters a specified policy in PostgreSQL |
PostGres Analyzer
Fixlet User Friendly Name |
|
Description |
Executes an analysis operation against a specified object in
PostgreSQL like a database, table, schema, etc. |
PostGres Change Data Directory
Fixlet User Friendly Name |
- PostGres_Change_Data_Directory
|
Description |
Changes data directory for a given PostgreSQL instance |
PostGres Change Data Wal
Directory
Fixlet User Friendly Name |
- PostGres_Change_Data_Wal_Directory
|
Description |
Changes data and wal directory for a given PostgreSQL
instance |
PostGres Configure PEM Agent
Fixlet User Friendly Name |
- PostGres_Configure_PEM_Agent
|
Description |
Executes the agent configuration of PostgreSQL EDB PEM Agent and
then restarts the agent service |
PostGres CPU Consumption By
Postgres
Fixlet User Friendly Name |
- PostGres_CPU_Consumption_By_Postgres
|
Description |
Checks the CPU usage by PostgreSQL processes on the host
server |
PostGres Create DB
Fixlet User Friendly Name |
|
Description |
Creates a new database on a given PostgreSQL instance with the
name specified by the user |
PostGres Create Group
Fixlet User Friendly Name |
|
Description |
Creates a new group on a given PostgreSQL instance |
PostGres Create Index
Fixlet User Friendly Name |
|
Description |
Creates a new index corresponding to a specified column of a
given table for a given PostgreSQL database |
PostGres Create Policy
Fixlet User Friendly Name |
|
Description |
Creates a new policy in PostgreSQL |
PostGres Create Role
Fixlet User Friendly Name |
|
Description |
Creates a new role on a given PostgreSQL instance |
PostGres Create Schema
Fixlet User Friendly Name |
|
Description |
Creates a new schema on a given PostgreSQL instance and grants
authority of the same to a specified user |
PostGres Create Tablespace
Fixlet User Friendly Name |
- PostGres_Create_Tablespace
|
Description |
Creates a new tablespace at a specified location on a given
PostgreSQL instance |
PostGres Create User With DB
Access
Fixlet User Friendly Name |
- PostGres_Create_User_With_DB_Access
|
Description |
Playbook creates a new user in the PostgreSQL instance and
grants the basic privileges of DB access. A randomly generated
password is also sent on mail. |
PostGres Create View
Fixlet User Friendly Name |
|
Description |
Creates a view for a given table in a PostgreSQL instance |
PostGres Delete Policy
Fixlet User Friendly Name |
|
Description |
Deletes a given policy from the PostgreSQL instance |
PostGres Drop Cluster
Fixlet User Friendly Name |
|
Description |
Drops/deletes PostgreSQL instances from a server by uninstalling
Postgre packages |
PostGres Drop Database
Fixlet User Friendly Name |
|
Description |
Drops/deletes a given database from a PostgreSQL instance |
PostGres Drop Group
Fixlet User Friendly Name |
|
Description |
Drops/deletes a specified from a PostgreSQL instance |
PostGres Drop Index
Fixlet User Friendly Name |
|
Description |
Drops/deletes a given index from a PostgreSQL instance |
PostGres Drop Role
Fixlet User Friendly Name |
|
Description |
Drops/deletes a specified role from a PostgreSQL instance |
PostGres Drop Schema
Fixlet User Friendly Name |
|
Description |
Drops/deletes a given schema from a specified database in a
PostgreSQL instance |
PostGres Drop Tablespace
Fixlet User Friendly Name |
|
Description |
Drops/deletes a given tablespace from a PostgreSQL instance |
PostGres Drop User
Fixlet User Friendly Name |
|
Description |
Drops/deletes a given user from a PostgreSQL instance |
PostGres Drop View
Fixlet User Friendly Name |
|
Description |
Drops/deletes a specified view for a given table and database
from a PostgreSQL instance |
PostGres Extract Bloating Report
Fixlet User Friendly Name |
- PostGres_Extract_Bloating_Report
|
Description |
Extracts and fetches the bloating report for the PostgreSQL
instance of a given database |
PostGres Grant Permission To
User
Fixlet User Friendly Name |
- PostGres_Grant_Permission_To_User
|
Description |
Grants a user the specified permissions for a given schema in a
PostgreSQL instance |
PostGres Install EDB Bart
Fixlet User Friendly Name |
- PostGres_Install_EDB_Bart
|
Description |
Installs and deploys the Postgres enterprise database Bart on a
specified RHEL server of version-7. |
PostGres Install EDB EFM Agent
Fixlet User Friendly Name |
- PostGres_Install_EDB_EFM_Agent
|
Description |
Installs and deploys the PostgreSQL EDB EFM Agent on the RHEL 7
machine. |
PostGres Install EDB PEM
Fixlet User Friendly Name |
- PostGres_Install_EDB_Bart
|
Description |
Installs and deploys the enterprise database Postgres Enterprise
Manager on a specified RHEL server of version-8 and above |
PostGres Install EDB PGBouncer
Fixlet User Friendly Name |
- PostGres_Install_EDB_PGBouncer
|
Description |
Installs and deploys EDB PGBouncer on the RHEL 7 machine |
PostGres Install PEM Agent
Fixlet User Friendly Name |
- PostGres_Install_PEM_Agent
|
Description |
Installs and deploys the Postgres Enterprise Manager agent
package on a specified RHEL 7 server version only. |
PostGres Install Postgres DB
Fixlet User Friendly Name |
- PostGres_Install_Postgres_DB
|
Description |
Installs and deploys Postgres on a RHEL server. |
PostGres Install Witness Server
Fixlet User Friendly Name |
- PostGres_Install_Witness_Server
|
Description |
Installs the EFM and EDB Advanced server version 11 and EDB
Advanced server client along with JDK package in order to make the
specified server as a witness server when required for the primary
instance of PostgreSQL cluster. |
PostGres List Running Queries
Fixlet User Friendly Name |
- PostGres_List_Running_Queries
|
Description |
Fetches and lists on running queries in a PostgreSQL
instance |
PostGres Memory Consumption By
Postgres
Fixlet User Friendly Name |
- PostGres_Memory_Consumption_By_Postgres
|
Description |
Checks and validates the memory usage by PostgreSQL processes on
the host server |
PostGres Perform Disaster
Recovery
Fixlet User Friendly Name |
- PostGres_Perform_Disaster_Recovery
|
Description |
Will perform a disaster recovery between two nodes of a
PostgreSQL Database |
PostGres Perform Failover
Fixlet User Friendly Name |
- PostGres_Perform_Failover
|
Description |
Will perform the failover from a secondary server to the primary
server in PostgreSQL |
PostGres Perform Physical
Restore
Fixlet User Friendly Name |
- PostGres_Perform_Physical_Restore
|
Description |
Executes physical restore on a secondary PostgreSQL server from
a specified primary instance of PostgreSQL |
PostGres Perform Streaming
Replication
Fixlet User Friendly Name |
- PostGres_Perform_Streaming_Replication
|
Description |
Will perform the enablement of streaming replication between two
servers of the PostgreSQL database |
PostGres Perform Vacuum
Fixlet User Friendly Name |
|
Description |
Performs the vacuum operation in PostgreSQL on a given database,
schema or table and a specified set of columns. |
PostGres Reindex
Fixlet User Friendly Name |
|
Description |
Performs the reindexing for a table or a database in
PostgreSQL |
PostGres Rename View
Fixlet User Friendly Name |
|
Description |
Renames the view for a given table in PostgreSQL |
PostGres Restart Service
Fixlet User Friendly Name |
|
Description |
Restarts the PostgreSQL database service for version 10 |
PostGres Restore Full Database
Fixlet User Friendly Name |
- PostGres_Restore_Full_Database
|
Description |
Restores a specified database from a file in PostgreSQL |
PostGres Restore Shema
Fixlet User Friendly Name |
|
Description |
Restores the specified schema from its backup file in a given
database in PostgreSQL |
PostGres Restore Table
Fixlet User Friendly Name |
|
Description |
Restores a specified table from its backup in a given database
in PostgreSQL |
PostGres Revoke Table Access
Fixlet User Friendly Name |
- PostGres_Revoke_Table_Access
|
Description |
Revokes permissions from a user for a table access in
PostgreSQL |
PostGres Start EDB EFM Agent
Fixlet User Friendly Name |
- PostGres_Start_EDB_EFM_Agent
|
Description |
Starts the EDB failover manager agent of a specified version on
a given PostgreSQL server. |
PostGres Start PEM Agent
Fixlet User Friendly Name |
|
Description |
Starts the PEM agent service on a specified PostgreSQL
server. |
PostGres Start Service
Fixlet User Friendly Name |
|
Description |
Starts the PostgreSQL service on the server hosting the
PostgreSQL instance. |
PostGres Stop EDB EFM Agent
Fixlet User Friendly Name |
- PostGres_Stop_EDB_EFM_Agent
|
Description |
Stops the EDB failover manager agent of a specified version on a
given PostgreSQL server. |
PostGres Stop PEM Agent
Fixlet User Friendly Name |
|
Description |
Stops the PEM agent service on a specified PostgreSQL
server. |
PostGres Stop Service
Fixlet User Friendly Name |
|
Description |
Stops the PostgreSQL service on the server hosting the
PostgreSQL instance. |
PostGres Take Logical Backup
Fixlet User Friendly Name |
- PostGres_Take_Logical_Backup
|
Description |
Carries out the logical backup against the whole PostgreSQL
cluster or a specified database, or a given schema or a particular
table in various modes. Performs the backup of the given
resource. |
PostGres Take Physical Backup
Fixlet User Friendly Name |
- PostGres_Take_Physical_Backup
|
Description |
Takes a physical backup of the database in PostgreSQL using
pg_basebackup utility |
PostGres Update Config Parameter
Fixlet User Friendly Name |
- PostGres_Update_Config_Parameter
|
Description |
Updates the value of a specified config parameter in
PostgreSQL |
PostGres Update HBA Config
Fixlet User Friendly Name |
- PostGres_Update_HBA_Config
|
Description |
Updates the PostgreSQL HBA config file with user, database,
types etc parameter values. |