You're reading from PostgreSQL 16 Administration Cookbook Solve real-world Database Administration challenges with 180+ practical recipes and best practices

Product type Paperback

Published in Dec 2023

Publisher Packt

ISBN-13 9781835460580

Length 636 pages

Edition 1st Edition

Languages

SQL

Tools

PostgreSQL

Concepts

Database Administration

Authors (5):

Boriss Mejías

Jimmy Angelakos

Simon Riggs

Gianni Ciolli

Vibhor Kumar

+1 more

View More author details

Table of Contents (15) Chapters

Preface

1. First Steps

2. Exploring the Database FREE CHAPTER

3. Server Configuration

4. Server Control

5. Tables and Data

6. Security

7. Database Administration

8. Monitoring and Diagnosis

9. Regular Maintenance

10. Performance and Concurrency

11. Backup and Recovery

12. Replication and Upgrades

13. Other Books You May Enjoy

14. Index

To get the most out of this book

In order for this book to be useful, you need access to a PostgreSQL client that is allowed to execute queries on a server. Ideally, you’ll also be the server administrator. Full client and server packages for PostgreSQL are available for most popular operating systems at https://www.postgresql.org/download/. All the examples here are executed at the Command Prompt, usually running the psql program. This makes them applicable to most platforms. It’s straightforward to do most of these operations by using a GUI tool for PostgreSQL, such as pgAdmin:

pgAdmin: https://www.pgadmin.org/download/

Download the color images

We also provide a PDF file that has color images of the screenshots/diagrams used in this book. You can download it here: https://packt.link/gbp/9781835460580.

Conventions used

There are a number of text conventions used throughout this book.

Code in text: Indicates code words in text, database table names, folder names, filenames, file extensions, pathnames, dummy URLs, user input, and Twitter handles. Here is an example: “Many experienced PostgreSQL DBAs will prefer to execute their own VACUUM commands.”

A block of code is set as follows:

autovacuum = on
track_counts = on

Any command-line input or output is written as follows:

VACUUM (DISABLE_PAGE_SKIPPING);

Warnings or important notes appear like this.

Tips and tricks appear like this.

Sections

In this book, you will find several headings that appear frequently (Getting ready, How to do it..., How it works..., There’s more..., and See also).

To give clear instructions on how to complete a recipe, use these sections as follows:

Getting ready

This section tells you what to expect in the recipe and describes how to set up any software or any preliminary settings required for the recipe.

How to do it…

This section contains the steps required to follow the recipe.

How it works…

This section usually consists of a detailed explanation of what happened in the previous section.

There’s more…

This section consists of additional information about the recipe in order to make you more knowledgeable about the recipe.