Instalaciones y Actualizaciones del software de PostgreSQL
Master PostgreSQL upgrades! Learn to smoothly install and perform minor & major version updates with minimal downtime. Boost database reliability.
Course Content
Instalaciones y Actualizaciones del software de PostgreSQL is an advanced Udemy course taught by Loles Ferrándiz. It runs 3h 3m, is taught in Spanish, and includes a certificate of completion. Learners rate it 4.6 out of 5 from 39 reviews, with 147 students enrolled. It is a paid course, last updated February 2023.
Master PostgreSQL Installation & Upgrades: A Comprehensive Guide
This course equips you with the skills to confidently manage PostgreSQL, the powerful open-source database system. Learn to handle any PostgreSQL installation scenario, from straightforward setup to complex source code compilation. You'll also master all aspects of PostgreSQL upgrades, including minor and major version updates, even within High Availability (HA) environments.
What you'll learn:
- Why Choose PostgreSQL? Understand the advantages of PostgreSQL over other database systems and the importance of keeping your PostgreSQL installation current. We'll explore the PostgreSQL versioning policy and how to stay informed about new releases.
- Installation Mastery: Gain hands-on experience installing PostgreSQL on various platforms. Learn step-by-step instructions for installing a PostgreSQL server on Linux from repositories, as well as compiling and installing from source code. We'll also cover Windows installation and essential PostgreSQL concepts like clusters vs. instances, key installation paths, and extension management. Plus, discover how to completely uninstall PostgreSQL.
- Minor Version Upgrades: Execute minor version upgrades seamlessly, applying the techniques learned during the installation module.
- Major Version Upgrades: Successfully perform major version upgrades in diverse scenarios. Dive into PostgreSQL's native upgrade and migration methods, including:
pg_upgradepg_dump- Logical Replication
Learn to effectively utilize each method, understanding their respective strengths and limitations.
- High Availability (HA) Upgrades: Navigate PostgreSQL upgrades in HA systems with minimal downtime. Understand the critical order of node upgrades based on their roles within the cluster.
- Unsupported Version Upgrades: Tackle challenging upgrades from unsupported PostgreSQL versions. Learn strategies for successful upgrades when standard tools may not guarantee success.
Course Structure:
This comprehensive course features 25 video lessons, combining thorough theory with practical demonstrations. You'll gain the knowledge and hands-on skills necessary to confidently install, upgrade, and maintain PostgreSQL databases in any environment. Become proficient in PostgreSQL management and ensure your data is always up-to-date and secure.
Hire the developers behind TutorialSearch.io
We built this site — full-stack web apps, AI integration & automation. Tell us what you need and we'll build yours.