PostgreSQL
![](https://upload.wikimedia.org/wikipedia/commons/thumb/2/29/Postgresql_elephant.svg/120px-Postgresql_elephant.svg.png)
PostgreSQL(orPostgresfor short) is an open-source relational database management systems (RDBMS). The purpose of the wikibook on hand is an introduction to PostgreSQL's capabilities, architecture, installing procedure, maintenance, and optimization tasks. Such aspects differ greatly from RDBMS to RDBMS. Thus the book is primarily aimed at database administrators - especially for students, occasional users, and novice DBAs who start to work with PostgreSQL. It only conveys basic knowledge and first steps. Many - even important - DBA topics are omitted. For a complete treatment, we recommend
- accomplish a professional training course offered by a consulting company
- use the excellent and completePostgreSQL documentationregularly
- consultPostgreSQL wikiwhich summarizes some special topics.
In addition to graphical interfaces, the main access method to an RDBMS isSQL,the standardized language for accessing relational databases. Because SQL does not differ that much from system to system, it's out of scope of this Wikibook: it's a topic of itself. If you are interested in the SQL syntax, you may want to refer to theWikibook SQL,which describes this standard independently from any RDBMS. PostgreSQL's implementation of SQL is very close to the standard.
Historical note: PostgreSQL is a follow-up (but independent) project ofIngresstarting at 1986. The roots of both systems go back to the University of California at Berkeley.
Content
[edit|edit source]Introduction
[edit|edit source]![](https://upload.wikimedia.org/wikipedia/commons/thumb/b/b0/PostgreSQL%27s_Internal_Architecture.svg/360px-PostgreSQL%27s_Internal_Architecture.svg.png)
First Steps
[edit|edit source]- Download, Installation
- Managing the Instance
- DBA Tools: psql, pgAdmin, phpAdmin,...
- Configuration
- Backup & Recovery
Concepts
[edit|edit source]Special Topics
[edit|edit source]- Client-Server Communication: The Client Side
- Client-Server Communication: The Server Side
- Security within the Database: Roles, Users, Privileges
- Replication
- Partitioning
- Tablespace
- Upgrade
- Glossary / Prominent Terms
Extensions
[edit|edit source]Implementation Details
[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,...)