PostgreSQL (or Postgres for short) is an open source relational database management systems (RDBMS). In nearly all cases the main application interface to an RDBMS is SQL, the standardized language for accessing relational databases. Beyond SQL every RDBMS needs additional tools to handle the installation process as well as maintenance and optimization tasks. As such tasks act closely to the implementation of each RDBMS, they greatly differ from RDBMS to RDBMS - unlike SQL.
The purpose of this book is an introduction to the PostgreSQL specific aspects: its architecture, installing procedure, maintenance and optimization tasks. Thus it is primarily aimed to database administrators. But it is only a starting point in these objectives and many topics are omitted. For a complete treatment we recommend to get through professional training courses offered by many consulting companies. And don't forget: there is a great and complete documentation of all the stuff we try to explain in the Wikibook on hand. Additionally some special topics are summarized in the PostgreSQL wiki.
The SQL interface is out of the scope of the Wikibook on hand. If you are interested in this specific topic, you may want to refer to the Wikibook SQL, which describes the SQL standard independent from any RDBMS implementation. It's a good starting point for PostgreSQL as its implementation of SQL is very close to the standard.
The Wikibook on hand is based on PostgreSQL version 10.
Chapters[edit | edit source]
Fundamentals[edit | edit source]
- Introduction to PostgreSQL
- Featured Platforms
- Download, Installation, First Steps
- Glossary / Prominent Terms
- Managing the Instance
- Multiversion Concurrency Control (MVCC) and Vacuum
- Write-Ahead-Log files (WAL)
Special Topics[edit | edit source]
- DBA Tools (psql, pgAdmin, phpAdmin, ...)
- Client-Server Communication: The Client Side
- Client-Server Communication: The Server Side
- Security within the Database: Roles, Users, Privileges
- Backup & Recovery
Extensions[edit | edit source]
Topics for Application Developers[edit | edit source]
See also[edit | edit source]
- Wikibook: SQL
- Wikipedia: PostgreSQL
- Wikibook: Converting MySQL to PostgreSQL
- PostgeSQL Wiki: Converting to PostgreSQL (DB2, Oracle, MySQL, ...)