PostgreSQL Database Administration on Windows/Linux- Part 2

PostgreSQL Database Administration on Windows/Linux- Part 2, available at $64.99, has an average rating of 4.54, with 50 lectures, based on 1095 reviews, and has 6842 subscribers.

You will learn about 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) This course is ideal for individuals who are Database Administrators or Developers or Students or Anyone who is curious about PostgreSQL It is particularly useful for Database Administrators or Developers or Students or Anyone who is curious about PostgreSQL.

Enroll now: PostgreSQL Database Administration on Windows/Linux- Part 2

Summary

Title: PostgreSQL Database Administration on Windows/Linux- Part 2

Price: $64.99

Average Rating: 4.54

Number of Lectures: 50

Number of Published Lectures: 50

Number of Curriculum Items: 50

Number of Published Curriculum Objects: 50

Original Price: CA$34.99

Quality Status: approved

Status: Live

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)

Who Should Attend

Database Administrators
Developers
Students
Anyone who is curious about PostgreSQL

Target Audiences

Database Administrators
Developers
Students
Anyone who is curious about PostgreSQL

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
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

Course Curriculum

Chapter 1: Introduction

Lecture 1: Introduction to PostgreSQL Replication

Lecture 2: Master/Slave Configuration

Lecture 3: Types of Replication

Lecture 4: Modes of Replication

Lecture 5: Replication Models

Chapter 2: Log Based Shipping Standby

Lecture 1: Introduction to Log Based Shipping Standby

Lecture 2: Initial Setup of Log Based Shipping Standby on Windows

Lecture 3: Log Based Shipping Standby on Windows

Lecture 4: Log Based Shipping Standby Failover on Windows

Lecture 5: Initial Setup of Log Based Shipping Standby on Linux

Lecture 6: Log Based Shipping Standby on Linux

Lecture 7: Log Based Shipping Standby Failover on Linux

Chapter 3: Streaming Replication

Lecture 1: Introduction to Streaming Replication

Lecture 2: Streaming Replication on Windows

Lecture 3: Streaming Replication on Linux

Lecture 4: Monitor Streaming Replication

Lecture 5: Synchronous Mode in Streaming Replication

Lecture 6: Replication Slots in Streaming Replication

Lecture 7: Streaming Replication Failover

Chapter 4: Replication Manager – Repmgr (Linux)

Lecture 1: Introduction to Replication Manager

Lecture 2: Setup Primary/Standby Streaming Replication Using Repmgr

Lecture 3: Automatic Failover and Node Rejoin

Lecture 4: Add New Standby Node and Standby Follow

Lecture 5: Cascading Streaming Replication

Lecture 6: Streaming Replication Switchover

Lecture 7: Witness Server

Lecture 8: Uninstall Replication Manager

Chapter 5: Logical Replication

Lecture 1: Introduction to Logical Replication

Lecture 2: Setup Logical Replication

Lecture 3: Add Table to Publication

Lecture 4: Add Table Without Primary Key to Publication

Lecture 5: Alter Column on a Table Part of Existing Publication

Lecture 6: Cascading Logical Replication

Lecture 7: Remove Publication/Subscription

Chapter 6: Tune Server Parameters

Lecture 1: Introduction to Server Parameters

Lecture 2: Tune Server Parameters

Chapter 7: Postgresql V15 – New Features (Logical Replication)

Lecture 1: Postgresql V15 – New Features Introduction

Lecture 2: Logical Replication Row Filtering

Lecture 3: Logical Replication Column List

Lecture 4: Alter Subscription Skip

Chapter 8: Postgresql V16 – New Features (Replication)

Lecture 1: Logical Replication New Features and Enhancements.

Lecture 2: Bi-Directional Replication Introduction

Lecture 3: Bi-Directional Replication – Infinite Loop Demo

Lecture 4: Bi-Directional Replication – With Origin Demo

Lecture 5: Binary Copy Introduction

Lecture 6: Binary Copy Demo

Lecture 7: Parallel Apply Intro – Create Subscription

Lecture 8: Parallel Apply Demo – Create Subscription

Lecture 9: Logical Replication From Standby Introduction

Lecture 10: Logical Replication From Standby Demo

Instructors

Sadiq Basha
Senior Production Database Administrator

Rating Distribution

1 stars: 2 votes
2 stars: 8 votes
3 stars: 87 votes
4 stars: 450 votes
5 stars: 549 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!

Menu