Course: PostgreSQL for AdministratorsPgSQL-ADMIN

The course is available on demand.

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.

4.9/5 (59)
Stars
exempt from VAT

Price: 740 EUR

refreshments included

computer station included

Category: PostgreSQL

The course is intended for Linux system administrators who will be responsible for the installation, configuration and maintenance of the PostgreSQL database. The training programme covers all elements necessary for the effective cooperation with programmers team on the project based on PostgreSQL.

We focus on practical issues that system administrator has to face to successfully work as a database administrator. Starting from installation , through the most important configuration parameters, basic efficiency tuning, system security and users management. We will also discuss the tools used to diagnose the most common problems and we will tackle the problem of creating backups.

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. Installation
    • Packages or self-compilation?
    • Essential compilation parameters
    • File system
      • Directory layout
      • Configuration files location
      • System logs location
    • Command line client_psql_
  2. Configuration
    • Critical parameters
    • Kernel shared memory settings
    • Database restart modes
    • Processes started by PostgreSQL
      • postmaster
      • bgwriter
      • stats collector
      • autovacuum
      • clients processes (backends)
    • Data integrity guarantees
      • WAL files
      • _fsync_settings
      • Write-through and write-back caches
  3. Performance tuning
    • Hard drive and RAID type selection
    • Key parameters influencing performance
    • Performance and reliability balancing
    • Performance problems diagnosing
  4. Security
    • Users and roles
    • Granting permissions
    • Host Based Access control ( _pg_hba.conf_file)
    • Authentication methods
      • _ident_method
      • Password method
      • Authentication with SSL certificate
  5. Management
    • Current queries listing
    • Finding and eliminating the problematic processes
    • Database maintenance
      • VACUUM order and autovacuum service
      • statistics and_ANALYSE_command
  6. Backups
    • pg_dump program
      • Backups formats
      • Restoring data from a copy, including partial recover
    • _pg_dumpall_program
      • Backing up users and permissions
    • Other methods of creating backups

Download as PDF

Audience and prerequisites

We recommend that the participants are familiar with Linux administration.

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