Learn PostgreSQL : use, manage, and build secure and scalable databases with PostgreSQL 16 / Luca Ferrari, Enrico Pirozzi.

Format:

Book

Author/Creator:

Ferrari, Luca (Computer scientist), author.

Pirozzi, Enrico, author.

Language:

English

Subjects (All):

PostgreSQL.

Database management.

SQL (Computer program language).

Physical Description:

1 online resource (744 pages) : illustrations

Edition:

Second edition.

Place of Publication:

Birmingham, UK : Packt Publishing Ltd., 2023.

Summary:

The latest edition of this PostgreSQL book will help you to start using PostgreSQL from absolute scratch, helping you to quickly understand the internal workings of the database. With a structured approach and practical examples, go on a journey that covers the basics, from SQL statements and how to run server-side programs, to configuring, managing, securing, and optimizing database performance. This new edition will not only help you get to grips with all the recent changes within the PostgreSQL ecosystem but will also dig deeper into concepts like partitioning and replication with a fresh set of examples. The book is also equipped with Docker images for each chapter which makes the learning experience faster and easier. Starting with the absolute basics of databases, the book sails through to advanced concepts like window functions, logging, auditing, extending the database, configuration, partitioning, and replication. It will also help you seamlessly migrate your existing database system to PostgreSQL and contains a dedicated chapter on disaster recovery. Each chapter ends with practice questions to test your learning at regular intervals. By the end of this book, you will be able to install, configure, manage, and develop applications against a PostgreSQL database.

Contents:

Cover

Copyright

Contributors

Table of Contents

Preface

Chapter 1: Introduction to PostgreSQL

Technical requirements

PostgreSQL at a glance

A brief history of PostgreSQL

What's new in PostgreSQL 16?

PostgreSQL release policy, version numbers, and life cycle

Exploring PostgreSQL terminology

Installing PostgreSQL

What to install

Installing PostgreSQL from binary packages

Using the book's Docker images

Installing PostgreSQL on GNU/Linux Debian, Ubuntu, and derivatives

Installing PostgreSQL on Fedora Linux

Installing PostgreSQL on FreeBSD

Installing PostgreSQL from sources

Installing PostgreSQL via pgenv

Summary

References

Chapter 2: Getting to Know Your Cluster

Managing your cluster

pg_ctl

PostgreSQL processes

Connecting to the cluster

The template databases

The psql command-line client

Entering SQL statements via psql

A glance at the psql commands

Introducing the connection string

Solving common connection problems

Database "foo" does not exist

Connection refused

No pg_hba.conf entry

Exploring the disk layout of PGDATA

Objects in the PGDATA directory

Tablespaces

Exploring configuration files and parameters

Verify your knowledge

Chapter 3: Managing Users and Connections

Introduction to users and groups

Managing roles

Creating new roles

Role passwords, connections, and availability

Using a role as a group

Removing an existing role

Inspecting existing roles

Managing incoming connections at the role level

The syntax of pg_hba.conf

Order of rules in pg_hba.conf

Merging multiple rules into a single one

Using groups instead of single roles

Using files instead of single roles

Inspecting pg_hba.conf rules

Including other files in pg_hba.conf

Chapter 4: Basic Statements

Using the Docker image

Connecting the database

Creating and managing databases

Creating a database

Managing databases

Introducing schemas

PostgreSQL and the public schema

The search_path variable

The correct way to start working

Listing all tables

Making a new database from a modified template

Dropping tables and databases

Dropping tables

Dropping databases

Making a database copy

Confirming the database size

The psql method

The SQL method

Behind the scenes of database creation

Managing tables

The EXISTS option

Managing temporary tables

Managing unlogged tables

Creating a table

Understanding basic table manipulation statements

Inserting and selecting data

NULL values

Sorting with NULL values

Creating a table starting from another table

Updating data

Deleting data

References

Notes:

OCLC-licensed vendor bibliographic record.

ISBN:

9781837635641

1837635641

OCLC:

1407633395