Beginner
PostgreSQL: Getting Started & Administration
8-10 hours
- Installation and initial setup
- Getting started with psql & pgAdmin
- Roles, privileges and authentication
- Essential configuration parameters
- Logical backups (pg_dump / pg_restore)
- Monitoring and system views
- Minor and major version upgrades
View on Udemy →
Advanced
PostgreSQL: Advanced Administration & High Availability
6-8 hours
- Internal architecture (processes, memory, WAL)
- MVCC, isolation levels and locking
- VACUUM, autovacuum and pg_repack
- OS tuning and advanced configuration
- Declarative partitioning
- Physical backups, PITR & pgBackRest
- Physical and logical replication
View on Udemy →
Expert
PostgreSQL: Performance & Optimization
6-8 hours
- Diagnostic methodology
- Execution plans (EXPLAIN ANALYZE)
- Statistics and planner impact
- Indexing: B-tree, GIN, GiST, BRIN
- Full-text search, JSONB, PostGIS, pg_trgm
- pg_stat_statements and auto_explain
- PoWA and advanced analysis tools
View on Udemy →
Need custom training?
We also offer private training sessions tailored to your specific context and challenges.
PostgreSQL Auditing
Thorough analysis of your infrastructure: configuration, security, performance, backups and disaster recovery.
Configuration
Security
Performance
DR/BCP
Performance Optimization
Diagnose and resolve performance issues: slow queries, indexing strategy, configuration and architecture tuning.
pg_stat_statements
EXPLAIN ANALYZE
Indexing
Tuning
Our approach
A structured process to ensure your project's success.
Step 01
Assessment
Analysis of your current setup and goals
Step 02
Proposal
Detailed and costed action plan
Step 03
Delivery
Implementation with regular check-ins
Step 04
Handover
Documentation and knowledge transfer
Migration to PostgreSQL
End-to-end support for migrating your databases from Oracle, MySQL, SQL Server or any other DBMS to PostgreSQL.
Compatibility analysis
Migration plan
Validation
Cutover
Version Upgrades
Upgrade your PostgreSQL instances to the latest major versions with minimal downtime.
pg_upgrade
Logical replication
Zero-downtime
Rollback plan
High Availability
Design and deploy HA architectures: replication, automatic failover and load balancing.
Streaming replication
Patroni
pgBouncer
HAProxy
Support & Managed Services
Responsive support for emergencies and day-to-day operations: monitoring, maintenance and incident management.
Monitoring
Backups
Incidents
SLA
CloudNativePG on Kubernetes
Deploy, configure and operate PostgreSQL on Kubernetes with the CloudNativePG operator. Automated HA, scheduled backups to S3 and full observability.
CloudNativePG
Kubernetes
S3 Backups
Auto failover
Tell us about your needs and we'll get back to you within 24 hours with a tailored proposal.
contact@aperiumdata.com