PostgreSQL Database Administration on Windows/Linux- Part 2 (Udemy.com)
New course available now for Performance tuning : PostgreSQL Database Administration on Win/Linux-Part 3 (PT)
Created by: Sadiq Basha
Last updated August 2025
What you will learn
- Replication & It’s Terminologies
- Log Based Shipping Standby
- Streaming Replication & Fail over
- Repmgr – Replication Manager
- Automatic Failover using Repmgr
- Node Rejoin
- Cascading Streaming Replication
- Logical Replication
- Cascading Logical Replication
- Tune PostgreSQL Server parameters
- Postgresql V15 - New Feature (Logical Replication)
Course Description
PostgreSQL is an advanced, enterprise class open source Object-Relational Database Management System (ORDBMS). Its is a relational database that supports both SQL (relational) and JSON (non-relational) querying.
PostgreSQL possesses robust feature sets including Multi-Version Concurrency Control (MVCC), point in time recovery, granular access controls, tablespaces, asynchronous replication, nested transactions, online/hot backups, a refined query planner/optimizer, and write ahead logging. It supports international character sets, multi-byte character encodings, Unicode, and it is locale-aware for sorting, case-sensitivity, and formatting. PostgreSQL is highly scalable both in the quantity of data it can manage and in the number of concurrent users it can accommodate.
The course provides the learner with an extensive knowledge of PostgreSQL Database Administration with real time examples.
Topics covered are:
Introduction to Replication & It's Terminalogies
Master and Slave Configuration
Warm & Hot Standby
Types of Replication
Modes of Replication
Models of Replication
Log Based Shipping Standby Initial Setup
Log Based Shipping Standby on Windows and Linux
Log Based Shipping Standby Failover
Streaming Replication Setup
Monitoring Streaming Replication
Synchronous Streaming Replication
Configure Physical Replication Slots
Failover Streaming Replication
Repmgr – Replication Manager
Automatic Failover using Repmgr
Node Rejoin of Failed Primary
Add New Node and Standby Follow
Switch Over From Primary to Standby
Cascading Streaming Replication
Witness Server
Event Notification System
Repmgr Monitoring
Upgrade Replication Manager
Uninstall Replication Manager
Logical Replication Setup
Publication and Subscription
Logical Replication Slots
Add Table to Publication
Refresh Subscription
Cascading Logical Replication
Uninstall Publication and Subscription.
Tune PostgreSQL Server parameters
Shared Buffers
Work_Mem
Maintenance_Work_Mem
Postgresql V15 - New Features (Logical Replication)
Postgresql V16 - New Features
Instructor Details
- 4.6 Rating
1,984 Reviews
Sadiq Basha
Senior Production Database Administrator with 20 years of extensive experience involving Oracle 21c/19c/12c/11g/10g/9i Databases, Oracle 11i/R12 E-Business Suite and SQL server 2012/2016/2019/2022, PostgreSQL, MongoDB, MySQL and Cloud Technologies (AWS/Azure). Experienced in designing, building and administering Oracle clustered server configurations supporting 21c,19c, 12c and 11g Real Application Clusters (RAC) installations on Linux, Solaris and AIX, HP-UX. Expertise in Always-On Availability Groups (AAG) and HA/DR. High availability 12c Golden gate setup using XAG. Database lead in implementing Cloud Solutions using various AWS Services including EC2, VPC, S3, Glacier, Lambda, RDS etc. Sound knowledge in the domain of Identity Management (OIM) Administration.
More courses by Sadiq Basha
PostgreSQL Database Administration on Windows/Linux- Part 1 (2025)
4.6 (7,007 Reviews)
Provider: Udemy
Time: 14.3h
$74.99
PostgreSQL Database Administration on Win/Linux-Part 3 (PT) (2024)
4.6 (508 Reviews)
Provider: Udemy
Time: 8.7h
$19.99
More SQL courses
SQL - The Complete Developer's Guide (MySQL, PostgreSQL) (2025)
4.8 (2,153 Reviews)
Provider: Udemy
Time: 19.7h
$94.99
SQL Server High Availability and Disaster Recovery (HA/DR) (2026)
4.8 (1,810 Reviews)
Provider: Udemy
Time: 88.3h
$16.99
70-461 Session 3: Querying Microsoft SQL Server (T-SQL code) (2025)
4.8 (1,094 Reviews)
Provider: Udemy
Time: 3.6h
$12.99
Modern Event-Driven Spring Boot: Kafka & Spring Cloud Stream (2026)
4.8 (494 Reviews)
Provider: Udemy
Time: 13.4h
$10.99
Oracle Database 12c Backup and Recovery using RMAN (2024)
4.8 (428 Reviews)
Provider: Udemy
Time: 20.1h
$34.99
Reviews
By Bill Vitaniemi on 4/28/2025
Well done! Sadiq presented this course in a simple, easy to understand format. Does a very good job of covering the topic of replication and sharing his knowledge of it. Looking forward to taking the next course on performance tuning.
By Mohinder Paul Singh on 3/12/2025
The pace of teaching is outstanding, and the explanations are comprehensive, including new version features and changes with examples. It thoroughly explains the topic, not just how to do it but also why. Detailed demos illustrate the underlying processes, enhancing comprehension. Thanks, Sadiq Basha.
By Vasanth Kumar S on 3/9/2025
Great course for new to Postgres administrators! I am working with Postgres many years and find some new details but missed more complex and real world scenarious with replication (separate index, schema folder, rights, etc) & high availability tasks where admin get some headaches.
By Anonymized User on 2/25/2025
great course for new to Postgres administrators! I am working with Postgres many years and find some new details but missed more complex and real world scenarious with replication (separate index, schema folder, rights, etc) & high availability tasks where admin get some headaches.
By Samuel Roseman on 12/22/2024
The course is excellent with very detailed explanations. We just need move away from this Master-Slave terminology that really doesn’t even fit. The databases in replication scenario are essentially Peers that will can assume database processing responsibilities when the peer is unable to continue processing. We simply need to clean up this terminology. Thank you.
By Leifur Saemundsson on 12/16/2024
Version 12 of PostgreSQL has been used for the training. However, it does cover the changes in versions 15 and 16 at the end. That said, it is somewhat outdated. The explanations are mostly derived from written material, which appears to have been compiled specifically for the training. It lacks in-depth or additional knowledge on these topics.
By Fahed Riaz on 10/17/2023
All in all, another excellent course from Sadiq. Some of the course highlights are as follows. 1, The concepts are clearly defined followed by hands-on demos. 2, Quick turnaround by the instructor when it comes to answering questions. 3, While the Section 6 "Tune Server Parameters" does not fit in, but still found it to be very useful. Future Suggestions ================= Maybe expand the scope of the course from "replication" to "replication & High Availability" and include some of the more popular HA components. Not sure, if this makes sense, but some examples are as follows. - pgbouncer (Sadiq did briefly mentioned the tool in this course). - pgpool - Slony (Not sure if it is a propertiory tool and if it can included). - PL/Proxy Note: There maybe other tools that I may not be familiar with. In summary, an excellent course that I will highly recommend to anyone wanting to learn PostgreSQL replication. Thanks Fahed
By Sai Krishna M on 1/24/2023
I got Internal training on PostgreSQL database administration to support a production databases (basically I works as an oracle DBA). I am not confident enough with internal training. while exploring in Udemy, I found this course and I purchased both part-1 and part-2 to deep dive bit more. I am very happy with course content, trust me I am managing 2TB production banking project databases with out any hiccups. Special thanks to Sadiq Basha. Thanks, Sai Krishna M
By Sri Aurobindo on 5/26/2022
This traning is excellent. This is not fast, it is in a relaxed pace so that it is comfortable for the people who are new to PostgreSQL to comfortably intake the knowledge and digest. Also the theory and hands-on demos are woven in the training simultaneously for best understanding.
By Mayuresh Shinde on 4/25/2022
Enjoyed both the parts . It covers all the basic administration activities require for a postgres beginner. Explanation was on to the point and very easy to understand. Hoping there is part 3 in making on 'performance issues in postgres'.
Quality Score
No CourseDuck member has rated this course yet. Taken it? Give each part a thumbs up or down.
Overall Score : 92 / 100








