Course Content
Pre Introduction
0/9
How does a computer work?
00:00
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
00:00
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
00:00
PostgreSQL is open source
00:00
No License and a Large Community
Extensibility
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
00:00
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
00:00
PostgreSQL Databases
PostgreSQL Schemas
PostgreSQL Users and Roles
PostgreSQL Roles and Privileges
PostgreSQL Backup Methods
0/3
PostgreSQL Physical Backups
Pg Basebackup
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

Please follow the steps provided in the below url.

https://postgreshelp.com/how-to-install-postgresql-in-linux/

Installing contrib module:

  1. go to contrib folder under download directory.

cd  /root/postgresql-10.5/contrib

  1. Do, “configure, make and make install“ to install contrib modules.
Previous
Next