PostgreSQL Administration

SpiralTrain BV

In the course PostgreSQL Administration participants learn to configure and manage PostgreSQL databases.

Price

from €2,999

Level

Not specified

Kind

Training

Subject

Automation and IT, Training and education

More information and registration at SpiralTrain BV

Description

PostgreSQL Intro The course PostgreSQL Administration starts with a discussion of the installation options and the tools pgAdmin and psql. Also the main features of PostgreSQL are covered such as table inheritance, sophisticated locking, nested transactions and asynchronous replication. PostgreSQL Architecture Subsequently the PostgreSQL Architecture and the processes that play a role in it, such as the Postmaster Daemon Process, Background and Backend Processes and Client Processes, are treated. Tablespaces and vacuum are also covered. Server and Database Objects Attention is also paid to the most commonly used server and database objects that PostgreSQL provides. It is important to get to know these objects, such as Server Service and Database Object, in order to be able to use their functionality. Backup and Restore Then it's time for the PostgreSQL backup tools pg_dump and pg_dumpall. Point-in-Time Database Restoration and Setting up WAL archiving are then explained. Indexes The use of indices in PostgreSQL and the differences between the indices B-Tree, Hash, GiSY, GIN and BRIN is also part of the course PostgreSQL Administration.