In the previous chapter, we covered the important processes and memory structures used internally by PostgreSQL. In this chapter, we will cover a few topics that will be more directly used when someone goes about initializing a cluster and creating objects in the cluster, such as tablespaces, databases, schemas, roles, and related items.

PostgreSQL for Data Architects
By :

PostgreSQL for Data Architects
By:
Overview of this book
Table of Contents (19 chapters)
PostgreSQL for Data Architects
Credits
About the Author
About the Reviewers
www.PacktPub.com
Preface
Installing PostgreSQL
Server Architecture
PostgreSQL – Object Hierarchy and Roles
Working with Transactions
Data Modeling with SQL Power Architect
Client Tools
SQL Tuning
Server Tuning
Tools to Move Data in and out of PostgreSQL
Scaling, Replication, and Backup and Recovery
PostgreSQL – Troubleshooting
PostgreSQL – Extras
Index
Customer Reviews