PostgreSQL Database Administration on WindowsLinux- 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!