PostgreSQL Upgrade – PostgreSQL Administration

Sorry, you have Javascript Disabled! To see this page as it is meant to appear, please enable your Javascript!

Course Content

Pre Introduction

0/9

How does a computer work?

Teams involved in IT project

Database Administration environment types

Types of Databases a DBA has to support

Further team classification in DBA team

Responsibilities of a DBA

Service level agreement

Common database related problems

What a Relational Database Is

Introduction

0/1

Brief history of PostgreSQL database

PostgreSQL Features

0/9

Object Relational Database Management System

PostgreSQL is open source

No License and a Large Community

DBaaS and JSON support

Scalability High-Availability Redundancy

PostgreSQL Forks and Data handling

What am I going to learn from here on

General Database Limits

PostgreSQL Architecture

0/8

How a connection is established in PostgreSQL

PostgreSQL Architecture Introduction

PostgreSQL Process Architecture

PostgreSQL Checkpointer process

Logger, Stats Collector and Autovacuum Process

Background Writer and WALWriter

PostgreSQL Memory Architecture

PostgreSQL Local Memory Architecture

ACID Properties and Query Processing

0/2

ACID Properties

The Path of a Query

PostgreSQL Installation

0/5

PostgreSQL Source code installation

PostgreSQL Yum Installation

PostgreSQL RPM Installation

Starting and Stopping the Server

PostgreSQL Database design

Physical Database Layout

0/4

PostgreSQL Page Layout

PostgreSQL WAL log files

PostgreSQL Control file

PostgreSQL Configuration and Authentication File

Logical Database Layout

0/5

PostgreSQL Tablespaces

PostgreSQL Databases

PostgreSQL Schemas

PostgreSQL Users and Roles

PostgreSQL Roles and Privileges

PostgreSQL Backup Methods

0/3

PostgreSQL Physical Backups

PostgreSQL Logical Backups

PostgreSQL Replication

0/1

PostgreSQL Physical Replication

SQL Tuning

0/2

What is Explain plan

PostgreSQL Optimizer Stats

PostgreSQL Upgrade

0/1

PostgreSQL Upgrade

PostgreSQL Tutorial for Absolute Beginners [Administration]

About Lesson

/usr/pgsql-12/bin/pg_upgrade -d /u01/pgsql/data -D /u01/pgsql/12 -b /usr/pgsql-10/bin -B /usr/pgsql-12/bin