PDF, EPUB

Read Online 13.3 MB Download

Discover how to design, develop, and maintain your database application effectively with PostgreSQL

About This Book

Understand how to utilize the most frequently used PostgreSQL ecosystem-related tools and technologies

A hands-on guide focused primarily on providing a practical approach to learning about architecture and design considerations for database architects

The book covers PostgreSQL from a data architect's perspective – covering topics from installation from source to designing tables using SQL Power Architect, as well as deciding replication and failover strategies.

Who This Book Is For

This book is for developers and data architects who have some exposure to databases. It is assumed that you understand the basic concepts of tables and common database objects, including privileges and security.

What You Will Learn

Compile PostgreSQL from source and understand the PostgreSQL architecture

Configure parameters and change default settings for a PostgreSQL server

Leverage the logging mechanism to identify errors and suboptimal queries

Use replication to scale horizontally

Set up backup and recovery processes

Tweak parameters to optimize queries and processes

Troubleshoot connection errors

Use indexes and rewrite queries to improve performance

Install and use PostgreSQL extensions

Learn how to leverage the command-line client (psql)