Amministrazione di database PostgreSQL

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

Questo corso è progettato Database Administrators and System Administrators che attualmente mantengono MySQL server, sviluppatori di database e programmatori che attualmente progettano e/o interagiscono con il database MySQL

• Conoscenza di base Linux (collegarsi in SSH, editare un file di configurazione, comandi basici).
• Conoscenza di base, anche minima di SQL (qualsiasi database relazionale). 

Al termine del corso i partecipanti saranno in grado di:

• installare e configurare 
• gestire gli utenti
• fare backup e recovery
• monitorare ed ottimizzare