PostgreSQL Administrator for DBA of other DBMS

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