PostgreSQL Database Administration on WindowsLinux Part 2

PostgreSQL Database Replication : Walk-in a Beginner, Walk-Out an Expert (Updated with Latest PostgreSQL V15)
PostgreSQL Database Administration on WindowsLinux Part 2
File Size :
2.95 GB
Total length :
6h 41m

Category

Instructor

Sadiq Basha

Language

Last update

3/2023

Ratings

4.5/5

PostgreSQL Database Administration on WindowsLinux Part 2

What you’ll 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)

PostgreSQL Database Administration on WindowsLinux Part 2

Requirements

Basic Knowledge of Database Concepts
PostgreSQL v12 Foundation
Internet access is required to download PostgreSQL Server
Working Knowledge on Windows and Linux

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 TerminalogiesMaster and Slave ConfigurationWarm & Hot StandbyTypes of ReplicationModes of ReplicationModels of ReplicationLog Based Shipping Standby Initial SetupLog Based Shipping Standby on Windows and LinuxLog Based Shipping Standby FailoverStreaming Replication SetupMonitoring Streaming ReplicationSynchronous Streaming ReplicationConfigure Physical Replication Slots Failover Streaming ReplicationRepmgr – Replication ManagerAutomatic Failover using RepmgrNode Rejoin of Failed PrimaryAdd New Node and Standby FollowSwitch Over From Primary to Standby Cascading Streaming ReplicationWitness ServerUninstall Replication ManagerLogical Replication SetupPublication and SubscriptionLogical Replication SlotsAdd Table to PublicationRefresh SubscriptionCascading Logical ReplicationUninstall Publication and Subscription.Tune PostgreSQL Server parametersShared BuffersWork_MemMaintenance_Work_Mem Postgresql V15 – New Features (Logical Replication)

Overview

Section 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

Section 2: Log Based Shipping Standby

Lecture 6 Introduction to Log Based Shipping Standby

Lecture 7 Initial Setup of Log Based Shipping Standby on Windows

Lecture 8 Log Based Shipping Standby on Windows

Lecture 9 Log Based Shipping Standby Failover on Windows

Lecture 10 Initial Setup of Log Based Shipping Standby on Linux

Lecture 11 Log Based Shipping Standby on Linux

Lecture 12 Log Based Shipping Standby Failover on Linux

Section 3: Streaming Replication

Lecture 13 Introduction to Streaming Replication

Lecture 14 Streaming Replication on Windows

Lecture 15 Streaming Replication on Linux

Lecture 16 Monitor Streaming Replication

Lecture 17 Synchronous Mode in Streaming Replication

Lecture 18 Replication Slots in Streaming Replication

Lecture 19 Streaming Replication Failover

Section 4: Replication Manager – Repmgr (Linux)

Lecture 20 Introduction to Replication Manager

Lecture 21 Setup Primary/Standby Streaming Replication Using Repmgr

Lecture 22 Automatic Failover and Node Rejoin

Lecture 23 Add New Standby Node and Standby Follow

Lecture 24 Cascading Streaming Replication

Lecture 25 Streaming Replication Switchover

Lecture 26 Witness Server

Lecture 27 Uninstall Replication Manager

Section 5: Logical Replication

Lecture 28 Introduction to Logical Replication

Lecture 29 Setup Logical Replication

Lecture 30 Add Table to Publication

Lecture 31 Add Table Without Primary Key to Publication

Lecture 32 Alter Column on a Table Part of Existing Publication

Lecture 33 Cascading Logical Replication

Lecture 34 Remove Publication/Subscription

Section 6: Tune Server Parameters

Lecture 35 Introduction to Server Parameters

Lecture 36 Tune Server Parameters

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

Lecture 37 Postgresql V15 – New Features Introduction

Lecture 38 Logical Replication Row Filtering

Lecture 39 Logical Replication Column List

Lecture 40 Alter Subscription Skip

Database Administrators,Developers,Students,Anyone who is curious about PostgreSQL

Course Information:

Udemy | English | 6h 41m | 2.95 GB
Created by: Sadiq Basha

You Can See More Courses in the Developer >> Greetings from CourseDown.com

New Courses

Scroll to Top