alt text

The book PostgreSQL for DBA volume 1 is the first of a book series covering PostgreSQL from the database administration point of view.

The book is available for purchase on amazon in paperback and ebook format.

Get the paperback here

Get the ebook here

The book covers PostgreSQL 11 on Linux analysing the install procedure either from source and with packages on Debian and RPM based systems.

A good part of the book explains the logical organisation and the physical structure in order to givethe reader a good starting point to understand the PostgreSQL internals.

Logical backup and restore with pg_dump are also analysed and performance tips for speeding up a disaster recovery are given.

The book also explain how PostgreSQL executes a query, the maintenance and the internal statistics in order to give the database administrators the know how for keeping PostgreSQL running efficiently at all time.