When you enroll through our links, we may earn a small commission—at no extra cost to you. This helps keep our platform free and inspires us to add more value.

Database Design & Development
Udemy logo

PostgreSQL Database Administration on Windows/Linux- Part 2

New course available now for Performance tuning : PostgreSQL Database Administration on Win/Linux-Part 3 (PT)

     
  • 4.7
    •  |
  • Reviews ( 1.6K )
₹589
PostgreSQL Database Administration on Windows/Linux- Part 2

Related Courses

This Course Includes

  • iconudemy
  • icon4.7 (1.6K reviews )
  • icon8h 16m
  • iconenglish
  • iconOnline - Self Paced
  • iconprofessional certificate
  • iconUdemy

About PostgreSQL Database Administration on Windows/Linux- Part 2

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

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