PostgreSQL for migrators

Level:

Intermediate

Date:

11.09 - 13.09.17

Duration:

3 Days

Sign up for this course

Audience

This course is designed especially for DBAs (Linux / Windows) and sysadmins who switch to PostgreSQL and want a training in advance.

Content

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
Sign up for this course