PostgreSQL for Migrators

PostgreSQL for Migrators

Duration: 3 Tage
Level: Intermediate
Date: on request
11.09. – 13.09.2017 in Wiener Neustadt, Austria (German)
Audience: This course is designed especially for DBAs (Linux / Windows) and sysadmins who switch to PostgreSQL and want a training in advance.

Installing PostgreSQL

– Installing binary packages
– Installing from source

Migrating data structures:
– PostgreSQL data types
– Optimizing data structures

Transactions:
– The PostgreSQL transaction model
– Locking issues

Migrating data:
– Moving data to PostgreSQL
– Creating PostgreSQL foreign data wrappers

Migrating stored procedures:
– Writing PL/pgSQL code
– Optimizing server side code

Backup and recovery:
– Creating PostgreSQL backups
– Point-In-Time-Recovery
– Streaming replication

Troubleshooting:
– Finding slow queries
– Monitoring PostgreSQL