History
Rate of change
Main characteristics
Compliance with the SQL standard
Concept of cluster / instance
Bases, diagrams and objects
Main limits

Process of an instance
Tree structure of an instance

Configuration of the package manager (yum / apt)
Installation of the instance
Configuration of the associated service

Workshop: Install and discover an instance

Psql text
client pgAdmin graphical
client phpPgAdmin web client

Workshop: Create a workshop database

Configuration principle
Parameters and contexts
Configuration file
Examination of the current configuration
Dynamic reconfiguration

Workshop: Modifying the initial configuration

Global memory: shared_buffers
Memory per process
– temp_buffer
– work_mem
– maintenance_work_mem

Workshop: Configure, optimally, shared_buffers and work_mem

Logging mechanisms
Configuration
Naming Logged
functionalities
Maintenance

Workshop: Configure application logging

Management of roles
Predefined roles (depending on the version)
Management of role rights
Management of access to the instance: pg_hba.conf file

Workshop: Create different roles

Manage the maintenance of a database

Overview
Logical
backup and restore Physical backup and restore
Principles
pg_basebackup command
Archiving transaction logs  

Workshop: Perform a remote backup and restore of the workshop base

Passing of the certification (if foreseen in the financing)