English | Size: 2.33 GB
Genre: eLearning
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 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
Who this course is for:
Database Administrators
Developers
Students
Anyone who is curious about PostgreSQL
nitro.download/view/9FB4951D1843DED/UD-PostgreSQL-v12-Database-Administration-on-WinLinux-Part-2.part1.rar
nitro.download/view/C13AE87A6536C47/UD-PostgreSQL-v12-Database-Administration-on-WinLinux-Part-2.part2.rar
nitro.download/view/4BC5F98F93C02A3/UD-PostgreSQL-v12-Database-Administration-on-WinLinux-Part-2.part3.rar
nitro.download/view/2304E7444874D91/UD-PostgreSQL-v12-Database-Administration-on-WinLinux-Part-2.part4.rar
nitro.download/view/15D77C746F39A91/UD-PostgreSQL-v12-Database-Administration-on-WinLinux-Part-2.part5.rar
nitro.download/view/95B55F3591A3900/UD-PostgreSQL-v12-Database-Administration-on-WinLinux-Part-2.part6.rar
rapidgator.net/file/2395b633e4767be670f1615f5ea6bfcb/UD-PostgreSQL-v12-Database-Administration-on-WinLinux-Part-2.part1.rar.html
rapidgator.net/file/de3cad5014badf35a2f3160526090c16/UD-PostgreSQL-v12-Database-Administration-on-WinLinux-Part-2.part2.rar.html
rapidgator.net/file/ae0a2d37756f43ac71facde0874596e7/UD-PostgreSQL-v12-Database-Administration-on-WinLinux-Part-2.part3.rar.html
rapidgator.net/file/501643a30ea9ebd36814808e6f664651/UD-PostgreSQL-v12-Database-Administration-on-WinLinux-Part-2.part4.rar.html
rapidgator.net/file/f893fe452aa0e0251f54850931a56bf5/UD-PostgreSQL-v12-Database-Administration-on-WinLinux-Part-2.part5.rar.html
rapidgator.net/file/79f069d91cee3a1568ff22dae7430ad2/UD-PostgreSQL-v12-Database-Administration-on-WinLinux-Part-2.part6.rar.html
If any links die or problem unrar, send request to
forms.gle/e557HbjJ5vatekDV9