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

To start the cluster use the following command

pg_ctl start -D DATA_DIRECTORY

To stop the cluster use the following command

pg_ctl stop -D DATA_DIRECTORY

There are 3 modes in stopping the cluster. They are

Shutdown modes are:

  1. smart             quit after all clients have disconnected
  2. fast                  quit directly, with proper shutdown (default)
  3. immediate     quit without complete shutdown; will lead to recovery on restart

More information:  https://postgreshelp.com/operating-system-kill-signals-on-postgresql/

Previous
Next