PostgreSQL Database Administration v13

What you'll learn:
PostgreSQL Database Administration
Enhanced features
Performance Tuning
Database Upgrade

Requirements:
No prerequisites

Description:
Why PostgreSQL?PostgreSQL is an opensource RDBMS DB, which is widely used across globally with it unique features and huge community. The DB doesn't have any size limitations.The maximum size of a table is 32TB, you can assume how easily it stores the data. With the new generations servers available round the corner of the world and many great mindscontributing to the database, PostgreSQL stands tall.Timely releases with enhanced features, and being open source PostgreSQL stands far away from the competitors.This course starts from basic to advance levelBelow are the list of topics which will be discussed:Setting up the server with AlmaLinuxInstalling DB BinariesCreating Directories as our requirementInitializing the DB clusterPostgreSQL Architecture.Physical filesconfiguration fileshow to perform deploymentsUser ManagementSchema Managementhow to set search_pathLogical objectsDefault Tablespaces and User defined tablespaceBackup and Restore which include Logical, Physical, filesystem, compressed and split backups.Utilities used for backupsSetting in archivelog mode.performing wal switch manuallyMaintenance Tasks which include vacuum, vacuumfull and analyzekilling inactive session from the DBDatabase upgrade from v13 to v15 with pg_upgradeExtensions in postgresviews in postgreSQLpgbench and pgbouncer overviewEnhancements in postgreSQL

Who this course is for:
Database Administrators willing to learn PostgreSQL
Students
Database Developers
Willing to learn PostgreSQL

Homepage