代码拉取完成，页面将自动刷新
同步操作将从 xuejianxinokok/Learn-PostgreSQL-Second-Edition 强制同步，此操作会覆盖自 Fork 仓库以来所做的任何修改，且无法恢复！！！
确定后同步将在后台操作，完成时将刷新页面，请耐心等待。
Build and manage high-performance database solutions using PostgreSQL 16
PostgreSQL is one of the fastest-growing open source object-relational Database Management Systems (DBMS) in the world. PostgreSQL provides enterprise level features, it’s scalable, secure and highly efficient, as well as easy to use and with a very rich ecosystem that include application drivers and tools. In this book, you will explore PostgreSQL 16, the latest stable release, learning how to build secure, reliable and scalable database solutions using it. Complete with hands-on tutorials and examples, a set of Docker images to follow step-by-step every example, this book will teach you how to achieve the right database design required for a reliable environment.
You will learn how to install, configure and manage a PostgreSQL server, managing users and connections and inspecting the server activity to seek for performance optimization needs. Thanks to a per-chapter summary and set of questions and answers, you will be able to check your acquired knowledge.
The book starts introducing the main concepts around PostgreSQL and how to install and connect to the database, and then progresses to the management of users, permissions and basic objects like tables. You will be taught about the Data Definition Language (DDL) and most common and useful statements and commands, as well as all the needed and common relational database concepts like foreign keys, trigger, functions and so on. Later, you will explore how to configure and tune your cluster to get the best out of your PostgreSQL service, how to create and manage indexes to fast data retrieval, and how to make and restore backup copies of your data. Last, you will learn how to create your own high availability solution by means of replications, either physical or logical, and you will get a glance at some of the most common and useful tools and extension you can apply to your cluster. By the end of this book, you'll be well-versed in the Postgres database and be able to set up your own PostgreSQL instance and use it to build robust data-centric solutions.
If you feel this book is for you, get your copy today!
This book is for anyone interested in learning about the PostgreSQL database from scratch or anyone looking to build robust, scalable and highly available database applications. All the newest and coolest features of PostgreSQL will be presented, along with all the concepts a database administrator or an application developer need to get the best out of a PostgreSQL instance. Although prior knowledge of PostgreSQL is not required, familiarity with databases and the SQL language is expected.
The book is divided into five main parts. The following is a list of the book chapters.
Every chapter will have the following main structure:
This repository contains also a set of Docker images that are already configured and ready to run, so that readers can follow examples directly without any need to install PostgreSQL directly on their machine. In order to run the images, you need to have installed Docker and you must have enough privileges to run it with port forwarding enabled.
Within the folder docker-images there are folders specific to pretty much every chapter that contain the image(s) to run for the related chapter.
The special folder standalone contains the base Docker machine that can be used as starting point or when no specific per-chapter container is provided (tipycally for the Part 1 of the book).
In order to ease the execution of every container, a shell script named run-pg-docker.sh has been built, so that you can run such script passing as argument the name of the per-chapter Docker folder. As an example, in order to launch the Docker container related to Chapter 5 you have to:
$ cd docker-images
$ sh run-pg-docker.sh chapter_05
The script will start the Docker container, downloading and installing required software within the container, and providing you to a shell prompt within the container. from such a prompt, you will be able to execute shell commands and connect to the database as explained in the book.
If you don't specify any particular chapter, the script will run the standalone image that is a book specific default PostgreSQL installation useful for the very first chapters and when no other specific per-chapter image has been developed. The following commands are equivalent:
$ cd docker-images
$ sh run-pg-docker.sh
$ cd docker-images
$ sh run-pg-docker.sh standalone
All the code examples are contained in this repository.
Every chapter with specific code examples has its own folder named after the chapter number, for instance Chapter_04 .
In order to ease the execution of the code examples by readers, every chapter will have a set of source scripts that the reader can immediatly load into her database.
Every file is named after its type, for example .sql for an SQL script or a collection of SQL statements.
Any picture will be named with the pattern Chapter<CC>_picture<PP>.<type> where:
CC is the chapter number;PP is the picture number as listed within the chapter;type is a suffix related to the picture file type (e.g., png for a Portable Network Graphic image).Images could appear differently from the printed book due to graphical needs.
In the book code listings and examples, the command prompts are one of the two that follows:
$ stands for an Unix shell prompt (like Bourne, Bash, Zsh);forumdb=> stands for the psql(1) command prompt when an active connection to the database is opened.As an example, the following is a command issued on the operating system:
$ sudo service postgresql restart
while the following is a query issued within an active database connection:
forumdb=> SELECT CURRENT_TIMESTAMP;
Whenere there is the need to execute a command or a statement with administrative privileges, the command prompt will reflect it using a # sign as the end part of the command prompt. For example, the following is an SQL statement issued as PostgreSQL administrator:
forumdb=# SELECT pg_terminate_backend( 987 );
ùPlease note the presence of the # in the forumdb=# prompt, as opposed to the > sign in the normal user forumdb=> prompt.
In the case a command on the operating system must be run with superuser (root) privileges, the command will be run via sudo(1), as in:
$ sudo initdb -D /postgres/data/16
and therefore in this case the command prompt will not change, rather the presence of the sudo(1) command indicates root privileges are required.
The book is built over an example database that implements an online forum storage. In order to be able to execute any example of any chapter, the reader has to initialize the forum database. If you use the Docker images, the forum database is already available to you, otherwise if you want to run the examples on your own PostgreSQL installation, it is better to run the initialization of the database.
The scripts in the folder setup, executed in lexicographically order, implement the example database and setup the environment so that other examples can be run against the database.
In particular, in order to get the database structure as shown in the book, you have to do at least the following two steps:
$ cd setup
$ sh 001-create-database-users.sh
$ psql -U postgres < 002-forum-database.sql
where
luca and enrico)forum, the database forumdb and will load a few tuples into the tables.Please note that in order to create the database (as per second step) you need access with a database user that has the capability of create new databases, hence the usage of the user postgres. If you are not sure about what you are doing, please use the Docker images until you have understood how to create and populate a new database and new users.
Luca Ferrari has been passionate about computer science since the Commodore 64 era, and today holds a master's degree (with honors) and a Ph.D. from the University of Modena and Reggio Emilia. He has written several research papers, technical articles, and book chapters. In 2011, he was named an Adjunct Professor by Nipissing University. An avid Unix user, he is a strong advocate of open source, and in his free time, he collaborates with a few projects. He met PostgreSQL back in release 7.3 days; he was a founder and former president of the Italian PostgreSQL Users’ Group (ITPUG). He also talks regularly at technical conferences and events and delivers professional training.
Enrico Pirozzi has been passionate about computer science since he was a 13-year-old, his first computer was a Commodore 64, and today he holds a master's degree from the University of Bologna. He has participated as a speaker at national and international conferences on PostgreSQL. He met PostgreSQL back in release 7.2, he was a co-founder of the first PostgreSQL Italian mailing list and the first Italian PostgreSQL website, and he talks regularly at technical conferences and events and delivers professional training. Right now, he is employed as a PostgreSQL database administrator at Zucchetti Hospitality (Zucchetti Group S.p.a).
Click here if you have any feedback or suggestions.
此处可能存在不合适展示的内容，页面不予展示。您可通过相关编辑功能自查并修改。
如您确认内容无涉及 不当用语 / 纯广告导流 / 暴力 / 低俗色情 / 侵权 / 盗版 / 虚假 / 无价值内容或违法国家有关法律法规的内容，可点击提交进行申诉，我们将尽快为您处理。
马建仓 AI 助手