Vendor: Cloud Contraptions
Format: Live instructor-led
Duration: 21 hours of live training delivered over 3-5 days to accommodate your scheduling needs
- Course details available on vendor site
- Introduction to PostgreSQL Administration
- Overview of PostgreSQL
- PostgreSQL Architecture
- Key Features of PostgreSQL
- Installation and Setup
- Installing PostgreSQL from Binaries
- Installing PostgreSQL from Source
- Post-Installation Setup
- Creating and Managing Database Clusters
- Configuration
- Understanding Configuration Files (postgresql.conf, pg_hba.conf)
- Setting Parameters
- File Locations
- Connection and Authentication Configuration
- Resource Consumption Settings
- Write-Ahead Log (WAL) Configuration
- Query Planning and Execution Configuration
- Security
- User Authentication Methods (MD5, SCRAM, GSSAPI, etc.)
- Role Management
- Granting and Revoking Privileges
- Secure TCP/IP Connections with SSL and SSH
- Data Encryption
- Implementing Row-Level Security
- Performance Tuning
- Monitoring and Optimizing Queries with EXPLAIN
- Using Indexes Effectively
- Understanding and Managing Bloat
- Configuring and Using AutoVacuum
- Managing Resource Consumption
- Tuning Memory and Disk I/O
- Backup and Restore
- SQL Dump
- File System Level Backup
- Continuous Archiving and Point-in-Time Recovery (PITR)
- Using pg_basebackup
- Restoring from Backup
- Replication and High Availability
- Introduction to Replication
- Configuring Streaming Replication
- Synchronous vs. Asynchronous Replication
- Configuring Hot Standby
- Using Logical Replication
- Failover and Switchover Procedures
- Routine Maintenance
- Regular Vacuuming and Analyzing
- Reindexing
- Log File Management
- Monitoring Disk Usage
- Managing Long-Running Queries
- Monitoring and Logging
- Using Built-in Monitoring Tools
- Configuring and Using pg_stat_statements
- Viewing and Analyzing Logs
- Setting up Alerts and Notifications
- Using External Monitoring Tools
- Advanced Topics
- Using Partitioning for Large Tables
- Full-Text Search Configuration
- Understanding and Using Table and Index Storage Parameters
- Configuring and Using Foreign Data Wrappers
- Extending PostgreSQL with Extensions and Plugins
- Troubleshooting and Best Practices
- Common Issues and Solutions
- Best Practices for Database Administration
- Regular Health Checks
- Disaster Recovery Planning
- Keeping PostgreSQL Updated
- Containerizing PostgreSQL
- Running PostgreSQL in Docker Containers
- Managing PostgreSQL in Kubernetes
- Using Helm Charts for PostgreSQL Deployment
- Monitoring PostgreSQL in Containerized Environments
- PostgreSQL in the Cloud
- Deploying PostgreSQL on AWS RDS
- Deploying PostgreSQL on Google Cloud SQL
- Deploying PostgreSQL on Azure Database for PostgreSQL
- Managing PostgreSQL in Cloud Environments
- Download
- Word Version
- PDF Version
- Reseller Version
- We specialize in delivering computer programming training and consulting services with an emphasis on using the latest in AI technology. We are customer-friendly and employ AI best practices and teach these practices to companies around the world.
- Learn More
- Services
- Courses
- Academy
- Contact Info
- +1 434-945-9416
- help@cloudcontraptions.com
- 3378 South Amherst Hwy
- Unit 21
- Monroe, VA 24574
- © 2026 Cloud Contraptions LLC. All Rights Reserved.
- About |Contact |Privacy
- This website uses cookies to improve your experience and analyze site traffic. By clicking "Accept", you consent to our use of cookies.
- Accept
- Decline
- DBAs, DevOps/SREs, sysadmins, and data engineers aiming to own PostgreSQL in production—install and configure clusters, harden security, tune performance, automate backups and PITR, implement replication and high availability, and operate on Docker/Kubernetes and AWS, GCP, or Azure with monitoring.
- No prior experience with PostgreSQL is necessary
- Students should have a basic understanding of SQL and relational databases
Source Host: www.cloudcontraptions.com
Generated on 2026-04-16 03:37:06