PostgreSQL Database Administration Tutorial - By Kiran Kambale
=================================================================

Welcome to **Mastering PostgreSQL Database Administration**, a comprehensive tutorial created by **Kiran Kambale** — a passionate Database Administrator with over **3 years of professional experience** and a strong academic foundation, holding an **MBA in Information Technology (IT)**.

This tutorial is crafted for those who aspire to become **expert PostgreSQL DBAs**. It blends theoretical knowledge with real-world practices, providing you with the skills, confidence, and strategies needed to manage mission-critical PostgreSQL environments.

What You Will Learn
====================

- Professional Installation and Setup of PostgreSQL
- Advanced Configuration and Tuning Techniques
- User Management, Access Control, and Database Security
- Backup, Recovery, and Disaster Recovery Planning
- Query Optimization and Performance Enhancement
- Replication, High Availability, and Failover Management
- Monitoring Tools and Proactive Troubleshooting
- Industry Best Practices for Managing PostgreSQL in Production

Each module combines detailed explanations, best practices, and field-tested tips to ensure you not only learn but master PostgreSQL administration.

About the Author
================

**Kiran Kambale**

- **Experience**: 3+ years managing complex PostgreSQL and other database systems
- **Education**: Master of Business Administration (MBA) in Information Technology (IT)
- **Mission**: To simplify complex database topics and empower learners to become confident, industry-ready DBAs.

Start Your Journey
===================

Whether you're preparing for your first DBA role, strengthening your existing skills, or aiming to certify your PostgreSQL knowledge, this guide is your gateway to success.

Let’s begin!

Contents
========

.. toctree::
   :maxdepth: 2
   :caption: PostgreSQL DBA Tutorial

   introduction
   installation
   configuration
   user_management
   backup_recovery
   performance_tuning
   replication_high_availability
   monitoring_troubleshooting
   production_best_practices
   faqs


.. toctree::
   :maxdepth: 2
   :caption: Index

   index2

.. toctree::
   :maxdepth: 2
   :caption: PostgreSQL

   postgresql

.. toctree::
   :maxdepth: 2
   :caption: SQL Language

   sql

.. toctree::
   :maxdepth: 2
   :caption: MongoDB

   mongodb

.. toctree::
   :maxdepth: 2
   :caption: PostgreSQL Upgrade Guide

   postgresql_upgrade_guide

.. toctree::
   :maxdepth: 2
   :caption: pgBackRest Documentation

   pgbackrest_document