| Description |
1 online resource (744 pages) : illustrations |
| Bibliography |
Includes bibliographical references and index. |
| 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 -- Technical requirements -- 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 -- Summary -- Verify your knowledge -- References -- Chapter 3: Managing Users and Connections -- Technical requirements -- 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 -- Summary -- Verify your knowledge -- References -- Chapter 4: Basic Statements -- Technical requirements -- 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 -- Summary -- Verify your knowledge -- References |
| Subject |
PostgreSQL.
|
|
Database management.
|
|
SQL (Computer program language)
|
|
Bases de données -- Gestion. |
|
SQL (Langage de programmation) |
| Added Author |
Pirozzi, Enrico, author.
|
|
More Resources