PostgreSQL for Data Architects

Table of Contents

1. Installation and directory structure
2. Server Architecture
3. Object Hierarchy and Security
4. Transactions
5. Data modelling with SQL Power Architect
6. Client Tools
7. SQL Tuning
8. Server Tuning
9. PostgreSQL inbuilt tools
10. Scaling, replication, backup and recovery
11. PostgreSQL - Troubleshooting
12. PostgreSQL - Extras