CONTENUTI:

Installing & Configuring PostgreSQL

• Host access control with pg_hba.conf
• Configuring PostgreSQL for secure access with OpenSSL

 

Using the psql client

 

Creating & Managing Indexes

• Creating Indexes
• Indexes on expressions
• Partial indexes

 

Transactions and Concurrency

 

Managing database privileges

• Understanding PostgreSQL roles
• User Roles
• Assigning users to roles
• Understanding role access

 

Access control with GRANT

 

PostgreSQL data organization

• PostgreSQL storage
• Managing table space usage
• PostgreSQL log directories
• Other directories
• Managing PostgreSQL clusters

 

Creating & Managing PostgreSQL tablespaces and databases

 

PostgreSQL Schemas

 

PostgreSQL logging

 

Backup and recovery (pg_dump, pg_dumpall, file system backups, pg_basebackup)

 

Continuous Archiving and Point-in-time-recovery

• PostgreSQL Write-ahead logs
• Performing PITR backups
• Performing PITR recovery

 

Server monitoring & performance tuning

 

Understanding & Managing Auto-Vacuum

 

PostgreSQL Hot Standby & Streaming Replication

• Setting up streaming replication
• Understanding and Managing performance of streaming replication
• Synchronous and Asynchronous replication
• Monitoring replication