PostgreSQL Database Administration On AlmaLinux

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 minds
contributing 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 level
Below are the list of topics which will be discussed:
Setting up the server with AlmaLinux
Installing DB Binaries
Creating Directories as our requirement
Initializing the DB cluster
PostgreSQL Architecture.
Physical files
configuration files
how to perform deployments
User Management
Schema Management
how to set search_path
Logical objects
Default Tablespaces and User defined tablespace
Backup and Restore which include Logical, Physical, filesystem, compressed and split backups.
Utilities used for backups
Setting in archivelog mode.
performing wal switch manually
Maintenance Tasks which include vacuum, vacuumfull and analyze
killing inactive session from the DB
Database upgrade from v13 to v15 with pg_upgrade
Extensions in postgres
views in postgreSQL
pgbench and pgbouncer overview
Enhancements in postgreSQL
Who this course is for:
Database Administrators willing to learn PostgreSQL
Students
Database Developers
Willing to learn PostgreSQL

More Info