When will I receive my Course Certificate?

If you complete the course successfully, your electronic Course Certificate will be added to your Accomplishments page - from there, you can print your Course Certificate or add it to your LinkedIn profile.

Why can’t I audit this course?

This course is currently available only to learners who have paid or received financial aid, when available.

Is financial aid available?

Yes. In select learning programs, you can apply for financial aid or a scholarship if you can’t afford the enrollment fee. If fin aid or scholarship is available for your learning program selection, you’ll find a link to apply on the description page.

PostgreSQL 17: High Availability & Advanced Administration

PostgreSQL 17: High Availability & Advanced Administration

This course is part of Mastering PostgreSQL 17 Specialization

Instructor: Packt - Course Instructors

Included with

Learn more

5 modules

Gain insight into a topic and learn the fundamentals.

Advanced level

Recommended experience

4 hours to complete

Flexible schedule

Learn at your own pace

5 modules

Gain insight into a topic and learn the fundamentals.

Advanced level

Recommended experience

4 hours to complete

Flexible schedule

Learn at your own pace

What you'll learn

Deploy and manage PostgreSQL in production environments
Optimize database performance and handle complex queries
Implement replication and security strategies for high availability

Details to know

Shareable certificate

Add to your LinkedIn profile

See how employees at top companies are mastering in-demand skills

Learn more about Coursera for Business

logos of Petrobras, TATA, Danone, Capgemini, P&G and L'Oreal

Build your subject-matter expertise

This course is part of the Mastering PostgreSQL 17 Specialization

When you enroll in this course, you'll also be enrolled in this Specialization.

Learn new concepts from industry experts
Gain a foundational understanding of a subject or tool
Develop job-relevant skills with hands-on projects
Earn a shareable career certificate

There are 5 modules in this course

This course focuses on PostgreSQL's high availability and advanced administration techniques. In today's data-driven world, managing database reliability and performance is essential for businesses.

You will develop key skills to handle critical aspects of PostgreSQL administration, such as backup and recovery, replication, troubleshooting, and migration. This practical knowledge enables you to ensure that your databases run smoothly, even in complex, mission-critical environments. This course combines theoretical knowledge with real-world scenarios to help you manage PostgreSQL environments effectively. You’ll learn how to optimize and troubleshoot PostgreSQL databases to meet performance and reliability goals. This course is designed for database administrators and system engineers with prior experience in PostgreSQL or database administration. A basic understanding of SQL and database systems will be beneficial. This course is part three of a three-course Specialization designed to provide a comprehensive learning pathway in this subject area. While it delivers standalone value and practical skills, learners seeking a more integrated and in-depth progression may benefit from completing the full Specialization.

This module introduces the essential concepts and practices for backing up and recovering PostgreSQL databases. Learners will explore strategies to ensure data safety and continuity, gaining practical skills to manage and restore database systems effectively.

What's included

1 video1 reading1 assignment

This module guides learners through the essentials of PostgreSQL backup, recovery, and replication, including configuration, transaction log management, and failover strategies. You will explore both physical and logical replication, learn to optimize system availability, and implement best practices for data durability and disaster recovery.

What's included

1 video16 readings1 assignment

1 videoTotal 1 minute

Overview1 minute

16 readingsTotal 75 minutes

Introduction5 minutes
Optimizing the Transaction Log5 minutes
Configuring the pg_hba.conf File6 minutes
Tracking pg_basebackup3 minutes
Replaying the Transaction Log4 minutes
Running PITR5 minutes
Cleaning up the Transaction Log Archive6 minutes
Combining Backups Again4 minutes
Performing a Basic Setup6 minutes
Checking Replication to Ensure Availability5 minutes
Performing Failovers and Understanding Timelines5 minutes
Making Replication More Reliable5 minutes
Adjusting Durability4 minutes
Making Use of Replication Slots5 minutes
Handling Logical Replication Slots4 minutes
Making Use of the CREATE PUBLICATION and CREATE SUBSCRIPTION Commands3 minutes

1 assignmentTotal 16 minutes

Mastering Backup and Replication Strategies16 minutes

This module introduces key PostgreSQL extensions, focusing on their practical uses for database management and optimization. Learners will explore contrib modules, investigate caching with pg_buffercache, and analyze storage issues such as table bloat using pgstattuple. By the end, you'll be equipped to leverage extensions for enhanced database performance and diagnostics.

What's included

1 video5 readings1 assignment

This module guides learners through systematic approaches to diagnosing and resolving common PostgreSQL performance issues. You will explore techniques for identifying slow queries, interpreting log files, addressing commit log corruption, and managing database connections effectively. By the end, you'll be equipped with practical troubleshooting skills to optimize PostgreSQL deployments.

What's included

1 video5 readings1 assignment

This module guides learners through the process of migrating databases to PostgreSQL, highlighting common troubleshooting strategies and compatibility considerations. It covers key differences in SQL feature support, such as the FILTER clause, and provides practical insights for transitioning from Oracle to PostgreSQL.

What's included

1 video3 readings1 assignment

Earn a career certificate

Add this credential to your LinkedIn profile, resume, or CV. Share it on social media and in your performance review.

Instructor

Packt - Course Instructors

Packt

1,763 Courses500,581 learners

Offered by

Packt

Explore more from Data Management

Packt
PostgreSQL 17: Optimizing Performance & Security
Course
Packt
PostgreSQL 17: Core Concepts and Advanced SQL Techniques
Course

Why people choose Coursera for their career

Felipe M.

Learner since 2018

"To be able to take courses at my own pace and rhythm has been an amazing experience. I can learn whenever it fits my schedule and mood."

Jennifer J.

Learner since 2020

"I directly applied the concepts and skills I learned from my courses to an exciting new project at work."

Larry W.

Learner since 2021

"When I need courses on topics that my university doesn't offer, Coursera is one of the best places to go."

Chaitanya A.

"Learning isn't just about being better at your job: it's so much more than that. Coursera allows me to learn without limits."

Open new doors with Coursera Plus

Unlimited access to 10,000+ world-class courses, hands-on projects, and job-ready certificate programs - all included in your subscription

Learn more

Advance your career with an online degree

Earn a degree from world-class universities - 100% online

Explore degrees

Join over 3,400 global companies that choose Coursera for Business

Upskill your employees to excel in the digital economy

Learn more

Frequently asked questions

Yes, you can preview the first video and view the syllabus before you enroll. You must purchase the course to access content not included in the preview.

If you decide to enroll in the course before the session start date, you will have access to all of the lecture videos and readings for the course. You’ll be able to submit assignments once the session starts.

Once you enroll and your session begins, you will have access to all videos and other resources, including reading items and the course discussion forum. You’ll be able to view and submit practice assessments, and complete required graded assignments to earn a grade and a Course Certificate.