|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/master-postgresql-from-basics-to-advanced-management/
课程评论：没有评论
课程名称：掌握PostgreSQL：从基础到高级管理 概述：本课程系列将深入探讨PostgreSQL的基本知识、基础内容以及掌握该技术所需的所有主题，帮助学习者理解PostgreSQL的概念。 **学习内容：** 1. **PostgreSQL基础知识** - 介绍PostgreSQL：了解PostgreSQL的基本概念和架构。 - Postmaster进程：学习Postmaster进程在数据库管理中的重要角色。 - 关闭类型：探索不同的PostgreSQL关闭模式及其适用场景。 - 数据库集群：深入了解数据库集群的配置和管理。 2. **PostgreSQL的安装与设置** - 下载和安装：提供逐步指导以下载安装PostgreSQL。 - 环境变量：配置环境变量以实现无缝的PostgreSQL操作。 3. **数据库与用户管理** - 创建/删除数据库：高效地创建和删除数据库。 - 创建/删除用户：掌握用户管理，包括创建和删除用户。 - 错误处理：解决常见的“角色'postgres'不存在”错误。 4. **PostgreSQL工具与命令** - psql快捷键：通过重要的psql命令行快捷键提高工作效率。 - Postmaster进程ID检查：自信地验证和排查Postmaster进程。 - 表空间：管理和利用表空间以优化存储组织。 5. **备份和恢复基本知识** - 备份与恢复介绍：了解PostgreSQL备份的重要性。 - pg_dump工具：学习使用pg_dump进行单个数据库的备份。 - 进行转储：实践可靠备份的方法。 - pg_dumpall：备份PostgreSQL实例中的所有数据库。 - 恢复技巧：使用psql和pg_restore工具恢复数据库。 - 离线备份：学习如何在关键情况下进行离线备份。 - 持续归档：配置持续归档以实现实时恢复。 - 文件系统备份：实现PostgreSQL数据库的物理备份。 - pg_basebackup工具：高效物理备份的工具使用。 - 逐时恢复（PITR）：使用恢复参数将数据库恢复到特定时间点。 6. **复制与高可用性** - 复制概述：了解PostgreSQL中不同类型的复制及其重要性。 - 复制模式：探索同步和异步复制模式。 - 基于文件的复制：了解基于文件的复制基础知识。 - 提升备用服务器：在灾难恢复场景中将备用服务器提升为主服务器。 - 流复制：设置流复制以实现实时数据一致性。 - WAL发送与接收进程：理解流复制中这些关键组件的作用。 - 复制配置参数：配置主服务器和备用服务器以实现复制。 - 复制设置（实验）：进行流复制的实践实验。 - 复制监控（实验）：学习监控和排查复制的技术。 7. **数据库优化** - VACUUM与AutoVacuum：理解VACUUM操作对性能的重要性。 - 完全VACUUM：学习何时以及如何使用FULL VACUUM来回收空间。 - pg_repack工具：使用pg_repack在不中断服务的情况下优化表和回收存储。 本课程为希望全面掌握PostgreSQL的学习者提供了丰富的知识和实用技能，适合各个层次的数据库管理员和开发人员。
In this series we will be talking about PostgreSQL fundamentals, basics and all topics which are required for you to learn the technology and understand the concepts of PostgreSQL.What You'll Learn:1. PostgreSQL FundamentalsIntroduction to PostgreSQL: Understand the foundational concepts and architecture of PostgreSQL.Postmaster Process: Learn about the crucial postmaster process and its role in database management.Types of Shutdown: Explore different PostgreSQL shutdown modes and their appropriate use cases.Database Cluster: Gain insights into database cluster configuration and management.2. Installing and Setting Up PostgreSQLDownload and Installation: A step-by-step guide to downloading and installing PostgreSQL.Environment Variables: Configure environment variables for seamless PostgreSQL operations.3. Database and User ManagementCreate/Drop Database: Learn how to efficiently create and drop databases.Create/Drop User: Master user management, including creating and removing users.Error Handling: Resolve the common "Role 'postgres' does not exist" error.4. PostgreSQL Tools and Commandspsql Shortcuts: Increase your productivity with essential psql command-line shortcuts.Postmaster Process ID Check: Verify and troubleshoot the postmaster process with confidence.Tablespaces: Manage and utilize tablespaces for optimal storage organization.5. Backup and Restore EssentialsIntroduction to Backup and Restore: Understand the importance of PostgreSQL backups.pg_dump Utility: Learn to use pg_dump for taking backups of individual databases.Taking Dumps: A hands-on approach to performing reliable backups.pg_dumpall: Backup all databases in your PostgreSQL instance.Restoration Techniques: Use psql and pg_restore utilities to recover databases.Offline Backups: Learn how to perform offline backups for critical scenarios.Continuous Archiving: Configure continuous archiving for real-time recovery.File System Backup: Implement physical backups for your PostgreSQL database.pg_basebackup Utility: Use this utility for efficient physical backups.Point-in-Time Recovery (PITR): Recover databases to a specific point using recovery parameters.6. Replication and High AvailabilityReplication Overview: Learn the significance and types of replications in PostgreSQL.Replication Modes: Explore synchronous and asynchronous replication modes.File-Based Replication: Understand the basics of file-based replication.Promoting Standby: Promote a standby server to master in disaster recovery scenarios.Streaming Replication: Set up streaming replication for real-time data consistency.WAL Sender and Receiver Processes: Understand these critical components of streaming replication.Replication Configuration Parameters: Configure both primary and standby servers for replication.Replication Setup (Lab): A hands-on lab to set up streaming replication.Monitoring Replication (Lab): Learn techniques to monitor and troubleshoot replication.7. Database OptimizationVacuum and AutoVacuum: Understand the importance of VACUUM operations for performance.Full Vacuum: Learn when and how to use FULL VACUUM to reclaim space.pg_repack Utility: Optimize tables and reclaim storage without downtime using pg_repack
