NXTEO
pOSTGRESQL SERVICES
SERENITY Pack or ASSURITY Pack
Our basic offer for all packs
Logical space management
Managing tablespaces / directories
Moving objects between tablespaces / directories
Object management
Checking object status*
Creating, modifying and deleting objects in a database
Management of objects with a very large increase in volume over a short period of time
Large volume management / partitioning
Availability management
Check the perimeter to ensure that all bases are UP*
Corruption management*
Lock management*
Error management
Cron management*
Error management: syslog, csvlog*
Trace file purge management
Modification of a database parameter when an alert threshold is reached
Safety management
User and password management
Role management
Transaction log management (WAL / Write-Ahead-Logging)
Checking the backup*
Backup / restore of a backup of less than 200GB
Feeding a PostgreSQL application schema (pg_jump / pg_restore)
Application of security patches in accordance with the schedule (PostgreSQL Global Development Group)
Performance management
Table / index / system / database reindexing
Statistics calculation restart
Analysis of sessions and consumer requests
Identification of CPU, memory, network and disk I/O restrictions
Our additional options
SERENITY packs only
UNLIMITED option
Safety management
Management and implementation of backup strategy + WAL
Backup / restore of a backup greater than 200GB
Performance management
Detailed analysis of CPU, memory, network and disk I/O constraints
New monitoring tool under study and development
DR* operations management
* DR: Disaster Recovery
Checking the status of the Disaster Recovery solution*
Switchover of a base on scheduled technical maintenance
Base failover in the event of a major incident
Management of CDC operations*
* CDC: Change Data Capture
Checking latency to the target base*
Verification of CDC activation on base model loading*
Additional operations
Migration of a database on the same server
Duplicating/moving a database to another server
ON-CALL DUTY option
ON-CALL DUTY management
Full scope of NWH incidents taken into account
NWH : Non-Working Hours, 24/7/365, including public holidays
SUPERVISION option
Supervision management
Remote supervision of the perimeter, reduced GRT*
*GRT : Guaranteed Response Time
LINUX / REDHAT option
OS* operations management
* Linux or RedHat OS only
File System check
Checking system error messages
Preparing devices for LVM enlargement / reduction
Managing local server accounts
Check server memory usage*.
*: Possible corrective action
