PostgreSQL for DBA

alt text

The book PostgreSQL for DBA, PostgreSQL 12 starts from where PostgreSQL for DBA volume 1 left by adding more topics to the previous book and covering what were left untold.

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

Get the paperback here

Get the ebook here

Organised in parts the book covers how to manage and install PostgreSQL, the physical and logical layer along with the performance tuning, the maintenance and the HA/DR. Last but not least there is a part dedicated to upgrading the clusters for the minor and the major versions.

The book covers PostgreSQL version 12 compiled from source and running on Slackware GNU Linux 14.2.The install procedure for the packages covers either DEB and RPM based distributions. The DEB the operating system is Devuan GNU Linux 2.0 and for the RPM the operating system is CentOS 7.

PostgreSQL for DBA vol1

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.