PostgreSQL Database Administration on Windows/Linux- Part 2

Partner: Udemy
Affiliate Name:
Area:
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 Repmgr
Category: Development > Database Design & Development > PostgreSQL
Partner ID:
Price: 24.99
Commission:
Source: Impact
Go to Course