PostgreSQL Tutorial Objective

Session 01: Installation from Source Code

Session 02: Installation from Source Code on Windows

Session 03: Server Setup and Operation

Session 04: Server Configuration

Session 05: Client Authentication

Session 06: Database Roles

Session 07: Managing Databases

Session 08: Localization

Session 09: Routine Database Maintenance Tasks

Session 10: Backup and Restore

Session 11: High Availability, Load Balancing, and Replication

Session 12: Recovery Configuration

Session 13: Monitoring Database Activity

Session 14: Monitoring Disk Usage

Session 15: Reliability and the Write-Ahead Log

Session 16: Logical Replication

Session 17: Just-in-Time Compilation (JIT)

Session 18: Regression Tests

Detailed Syllabus:

Session 01: Installation from Source Code

Getting The Source
Installation Procedure
Post-Installation Setup
Supported Platforms

Session 02: Installation from Source Code on Windows

Requirements
Special Considerations for 64-bit Windows
Building
Cleaning and Installing
Running the Regression Tests
Building the Documentation

Session 03: Server Setup and Operation

The PostgreSQL User Account
Creating a Database Cluster
Starting the Database Server
Managing Kernel Resources
Shutting Down the Server
Upgrading a PostgreSQL Cluster
Preventing Server Spoofing
Encryption Options
Secure TCP/IP Connections with SSL
Secure TCP/IP Connections with SSH Tunnels
Registering Event Log on Windows

Session 04: Server Configuration

Setting Parameters
File Locations
Connections and Authentication
Resource Consumption
Write Ahead Log
Replication
Query Planning
Error Reporting and Logging
Run-time Statistics
Automatic Vacuuming
Client Connection Defaults
Lock Management
Version and Platform Compatibility
Error Handling
Preset Options
Customized Options
Developer Options
Short Options

Session 05: Client Authentication

The pg_hba.conf File
User Name Maps
Authentication Methods
Trust Authentication
Password Authentication
GSSAPI Authentication
SSPI Authentication
Ident Authentication
Peer Authentication
LDAP Authentication
RADIUS Authentication
Certificate Authentication
PAM Authentication
BSD Authentication
Authentication Problems

Session 06: Database Roles

Database Roles
Role Attributes
Role Membership
Dropping Roles
Default Roles
Function Security

Session 07: Managing Databases

Overview
Creating a Database
Template Databases
Database Configuration
Destroying a Database
Tablespaces

Session 08: Localization

Locale Support
Collation Support
Character Set Support

Session 09: Routine Database Maintenance Tasks

Routine Vacuuming
Routine Reindexing
Log File Maintenance

Session 10: Backup and Restore

SQL Dump
File System Level Backup
Continuous Archiving and Point-in-Time Recovery (PITR)

Session 11: High Availability, Load Balancing, and Replication

Comparison of Different Solutions
Log-Shipping Standby Servers
Failover
Alternative Method for Log Shipping
Hot Standby

Session 12: Recovery Configuration

Archive Recovery Settings
Recovery Target Settings
Standby Server Settings

Session 13: Monitoring Database Activity

Standard Unix Tools
The Statistics Collector
Viewing Locks
Progress Reporting
Dynamic Tracing

Session 14: Monitoring Disk Usage

Determining Disk Usage
Disk Full Failure

Session 15: Reliability and the Write-Ahead Log

Reliability
Write-Ahead Logging (WAL)
Asynchronous Commit
WAL Configuration
WAL Internals

Session 16: Logical Replication

Publication
Subscription
Conflicts
Restrictions
Architecture
Monitoring
Security
Configuration Settings
Quick Setup

Session 17: Just-in-Time Compilation (JIT)

What is JIT compilation?
When to JIT?
Configuration
Extensibility

Session 18: Regression Tests

Running the Tests
Test Evaluation
Variant Comparison Files
TAP Tests
Test Coverage Examination

If You Like What We Do Here On DatabaseConcept, You Should Consider:

Stay Connected to: Twitter | Facebook

Subscribe to our email updates: Sign Up Now

 

We are thankful for your support.