PostgreSQL, initiation

Training nature


Cycle certifiant

Training duration
4 jours
Training method
Training place


Moroni Union of the Comoros

Training Diploma and level
Training teaching type

This course will teach you how to use it efficiently, in particular to create and use a database.

Introduction to PostgreSQL

  • Project history
  • Presentation of projects and tools


Secure installation and configuration

  • Installation
  • Installing from sources
  • Installation with a package system
  • Configuration settings


User and Group Management

  • Add and remove users
  • Group Management
  • Authentication
  • Granting of privileges


Configuring PostgreSQL

  • Installing a Database
  • Starting a database
  • The Postmaster
  • The Postgresql.conf file
  • System Tables

Maintenance of data

  • Importing / exporting data
  • With COPY TO and COPY FROM
  • With Psql
  • Data backup and restore
  • Common Errors
  • Tools pg_dump

Query Optimization

  • The INDEX
  • The PostgreSQL Optimizer
  • The tools EXPLAIN and VACUUM

Public concerné:

  • Developers, operators
  • Anyone who wants to use PostgreSQL or migrate to PostgreSQL.

Others trainings proposed by Ganzatech