PostgreSQL Database Administration
Buy now
Learn more
Course Materials
Slides-v2.0
Activity Guide - v11
Introduction to PostgreSQL Server
Introduction to PostgreSQL Server
PostgreSQL Server Architecture
PostgreSQL Server Architecture
Installing PostgreSQL
Links to download pre-built Linux VM
Overview of Installing PostgreSQL
Lab Practice: Installing PostgreSQL on Linux
PostgreSQL File Layout
PostgreSQL File Layout
Using psql
Using psql
Starting/Stopping PostgreSQL Server
Overview of Starting/Stopping PostgreSQL Server
Lab Practice: Starting/Stopping the PostgreSQL Server
System Catalogs and System Views
About System Catalogs and System Views
Lab Practice: System Catalogs and System Views
Server Configuration
About Server Configuration Settings
Lab Practice: Server Configuration Settings
Client Authentication
Overview of Client Authentication
Lab Practice: Configuring Client Authentication
Database Roles and Privileges
About Roles
About Privileges
About Groups
Lab Practices: Roles, Privileges, Groups
Managing Schemas
Overview of Managing Schemas
Lab Practice: Managing Schemas
Managing Databases
Overview of Managing Databases
Lab Practices: Managing Databases
Managing Tablespaces
Overview of Managing Tablespaces
Lab Practices: Managing Tablespaces
Write-Ahead Log (WAL) and WAL Archiving
Overview of WAL and WAL Archiving
Lab Practices: WAL and Configuring WAL Archiving
Control File
Control File
Vacuuming
Vacuuming
Backup and Recovery
Overview of Backup and Recovery
Lab Practices: Backup and Recovery
Upgrading PostgreSQL Server
Overview of Upgrading PostgreSQL Server
Lab Practice: Upgrading PostgreSQL Server
Deinstalling PostgreSQL Server on Linux
Deinstalling PostgreSQL Server on Linux
Deploying Multiple Clusters on the same Host
Creating Second Database Cluster
Installing different version of PostgreSQL Server
PostgreSQL Server on Windows
Installing PostgreSQL Server on Windows
Deinstalling PostgreSQL Server on Windows
Replication
Overview of PostgreSQL Replication
Streaming Replication
Links to download pre-built VMs
Lab Practice: Implementing Streaming Replication
Overview of Logical Replication
Lab Practice: Implementing Logical Replication
Products
Course
Section
Replication
Replication
PostgreSQL Database Administration
Buy now
Learn more
Course Materials
Slides-v2.0
Activity Guide - v11
Introduction to PostgreSQL Server
Introduction to PostgreSQL Server
PostgreSQL Server Architecture
PostgreSQL Server Architecture
Installing PostgreSQL
Links to download pre-built Linux VM
Overview of Installing PostgreSQL
Lab Practice: Installing PostgreSQL on Linux
PostgreSQL File Layout
PostgreSQL File Layout
Using psql
Using psql
Starting/Stopping PostgreSQL Server
Overview of Starting/Stopping PostgreSQL Server
Lab Practice: Starting/Stopping the PostgreSQL Server
System Catalogs and System Views
About System Catalogs and System Views
Lab Practice: System Catalogs and System Views
Server Configuration
About Server Configuration Settings
Lab Practice: Server Configuration Settings
Client Authentication
Overview of Client Authentication
Lab Practice: Configuring Client Authentication
Database Roles and Privileges
About Roles
About Privileges
About Groups
Lab Practices: Roles, Privileges, Groups
Managing Schemas
Overview of Managing Schemas
Lab Practice: Managing Schemas
Managing Databases
Overview of Managing Databases
Lab Practices: Managing Databases
Managing Tablespaces
Overview of Managing Tablespaces
Lab Practices: Managing Tablespaces
Write-Ahead Log (WAL) and WAL Archiving
Overview of WAL and WAL Archiving
Lab Practices: WAL and Configuring WAL Archiving
Control File
Control File
Vacuuming
Vacuuming
Backup and Recovery
Overview of Backup and Recovery
Lab Practices: Backup and Recovery
Upgrading PostgreSQL Server
Overview of Upgrading PostgreSQL Server
Lab Practice: Upgrading PostgreSQL Server
Deinstalling PostgreSQL Server on Linux
Deinstalling PostgreSQL Server on Linux
Deploying Multiple Clusters on the same Host
Creating Second Database Cluster
Installing different version of PostgreSQL Server
PostgreSQL Server on Windows
Installing PostgreSQL Server on Windows
Deinstalling PostgreSQL Server on Windows
Replication
Overview of PostgreSQL Replication
Streaming Replication
Links to download pre-built VMs
Lab Practice: Implementing Streaming Replication
Overview of Logical Replication
Lab Practice: Implementing Logical Replication
6 Lessons
Overview of PostgreSQL Replication
Streaming Replication
Links to download pre-built VMs
Lab Practice: Implementing Streaming Replication
Overview of Logical Replication
Lab Practice: Implementing Logical Replication