Course: Advanced PostgreSQL for Administrators PgSQL-Admin-201

The course is available on demand.

No suitable dates? Suggest a time that suits your schedule

Remote training: online live with a trainer and a group. Available on demand, at time and place convenient to you, for groups of at least 5 participants.

exempt from VAT

Price: 740 EUR

refreshments included

computer station included

Category: PostgreSQL

The course is intended for administrators who are responsible for PostgreSQL databases and who want to discover advanced possibilities offered by that system. We will show how to achieve 100% efficiency for your database and we will introduce advanced backup and replication techniques. The training programme includes acccessing and interpreting internal metrics of the database and tips on tuning less known parameters.

For those who haven’t used PostgreSQL before, we recommend combining this course withPostgreSQL for Administrators to create a single comprehensive, intensive training.

Our instructors have many years of experience with PostgreSQL, both as administrators and as programmers. One of our trainers is a PostgreSQL contributor and a regular speaker at the world’s largest conference on the topic.

Duration

2 days

Agenda

  1. Installing extensions
    • Contrib extensions
    • Embedded programming languages
      • PL/Python
      • PL/Perl (trusted and untrusted)
      • PL/v8
    • External extensions
      • Compilation and extentions installation
    • Stored procedures in C
  2. Monitoring database work
    • System tools
      • vmstat, top, iostat
      • strace, systemtap
    • System perspectives
      • Monitoring index usage
      • Monitoring the bgwriter process
      • Troubleshooting deadlocks
      • Preventing transaction wraparound
    • Dedicated monitoring tools
      • _check_postgres.pl_script
      • Log parsers: pgFouine, pg_badger
      • Automatic erros notification: tail_n_mail
  3. Replications, backups, partitioning
    • Point in Time Recovery
    • Log shipping
    • Streaming replication
      • Monitoring replication stage
      • Replication parameters tuning
    • Built-in partitioning
  4. Projects working with PostgreSQL
    • PgBouncer connection pooling
    • Introduction to external replication with Slony, Bucardo, pgPool
    • Using distributed data sources
      • The PL/Proxy language
      • Foreign Data Wrappers
    • Traffic monitoring
      • Wireshark
      • pgshark

Download as PDF

Audience and prerequisites

Basic knowledge of PostgreSQL, Linux administration ability.

Certificates

Course participants receive completion certificates signed by ALX.

There are currently no entries
Enter your e-mail address and we will notify you about future dates