Annex 4: PostgreSQL
| SNo | Work Type | Action/Deliverable |
|---|---|---|
| 1 | Incident | Backup/Recovery: Perform full, incremental, or partial backups of databases |
| 2 | Incident | Backup/Recovery: Automate the backup and restore process |
| 3 | Incident | Backup/Recovery: Monitor the backup disk space and archive or delete old backup files |
| 4 | Incident | PostgreSQL Cluster: Installation and Configuration |
| 5 | Incident | PostgreSQL Cluster: Troubleshooting and Maintenance |
| 6 | Incident | Replication: General troubleshooting |
| 7 | Incident | Replication: Configuration of Replication on Source and Target |
| 8 | Incident | Replication: Monitoring the Replication Status |
| 9 | Incident | Replication: Sync Issues. |
| 10 | Incident | Replication: PostgreSQL user management for replication |
| 11 | Incident | Performance optimization: Query optimization |
| 12 | Incident | Performance optimization: Instance slowness/tuning |
| 13 | Incident | Performance optimization: Hardware related slowness |
| 14 | Incident | Database Encryption |
| 15 | Incident | Capacity Planning: Database growth forecast |
| 16 | Incident | Capacity Planning: Storage capacity planning |
| 17 | Incident | Capacity Planning: Memory/CPU usages forecast |
| 18 | Replica/Migrations | General troubleshooting: Blocking |
| 19 | Replica/Migrations | General troubleshooting: Dead Locking |
| 20 | Replica/Migrations | General troubleshooting: High CPU |
| 21 | Replica/Migrations | General troubleshooting: High Memory |
| 22 | Replica/Migrations | General troubleshooting: High IO |
| 23 | Change Request | General troubleshooting: Connectivity Issues |
| 24 | User Request | General troubleshooting: Login & Permission Issues |
| 25 | User Request | General troubleshooting: Disk Space related issues |
| 26 | User Request | General troubleshooting: Mount point related issues |
| 27 | User Request | General troubleshooting: Server Not Responding |
| 28 | Change Request | General troubleshooting: Down Database - User Database |
| 29 | User Request | General troubleshooting: Down Database - Consistency Issue with User DB |
| 30 | User Request | General troubleshooting: Down Database - System Database |
| 31 | User Request | General troubleshooting: Backup Audit / Backup Job Failure |
| 32 | User Request | General troubleshooting: Agent Job Failure - Customer Jobs |
| 33 | User Request | General troubleshooting: Data and Log file high Usage |
| 34 | Incident | General troubleshooting: Services Down |
| 35 | Incident | General troubleshooting: Long Running Jobs |
| 36 | Replica/Migrations | Provisioning and managing database instances: |
| 37 | Replica/Migrations | Setting up replication and high availability: |
| 38 | Replica/Migrations | Deploying instance or database level objects: |
| 39 | Change Request | General Requests: DB refresh |
| 40 | User Request | General Requests: Script Execution |
| 41 | User Request | General Requests: Audit Configuration |
| 42 | User Request | General Requests: Table Partition |
| 43 | User Request | General Requests: Adding or moving datafiles |
| 44 | Change Request | General Requests: Creating and managing user accounts, roles, privileges |
| 45 | User Request | General Requests: Auditing and logging the activities |
| 46 | User Request | General Requests: Apply patches and upgrades minor version |
Updated about 1 year ago