PostgreSQL for Data Architects

PostgreSQL for Data Architects Front Cover
1 Reviews
290 pages

Book Description

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 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
  • 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
  • connection errors
  • Use indexes and rewrite queries to improve
  • Install and use PostgreSQL extensions
  • Learn how to leverage the command-line client (psql)

In Detail

PostgreSQL is an incredibly flexible and dependable relational database. Harnessing its power will make your applications more reliable and extensible without increasing costs. Using PostgreSQL's advanced features will save you work and increase performance, once you've discovered how to set it up.

PostgreSQL for Data Architects will teach you everything you need to learn in order to get a scalable and optimized PostgreSQL server up and running.

The book starts with basic concepts like installing PostgreSQL from source and covers theoretical aspects such as concurrency and transaction . After this, you'll learn how to set up replication, use load balancing to scale horizontally, and troubleshoot errors.

Finally, you will get acquainted with useful tools available in the PostgreSQL ecosystem used for analyzing PostgreSQL logs, setting up load balancing, and recovery.

Table of Contents

Chapter 1: Installing PostgreSQL
Chapter 2: Server Architecture
Chapter 3: PostgreSQL – Object Hierarchy and Roles
Chapter 4: Working with Transactions
Chapter 5: Data Modeling with SQL Power Architect
Chapter 6: Client Tools
Chapter 7: SQL Tuning
Chapter 8: Server Tuning
Chapter 9: Tools to Move Data in and out of PostgreSQL
Chapter 10: Scaling, Replication, and Backup and Recovery
Chapter 11: PostgreSQL – Troubleshooting
Chapter 12: PostgreSQL – Extras

Book Details

  • Title: PostgreSQL for Data Architects
  • Author:
  • Length: 290 pages
  • Edition: 1
  • Language: English
  • Publisher:
  • Publication Date: 2015-03-27
  • ISBN-10: 1783288604
  • ISBN-13: 9781783288601
Download LinkFormatSize (MB)Upload Date
Download from FilePiTrue PDF, EPUB13.207/15/2015
Download from UpLoadedTrue PDF, EPUB13.201/05/2017
Download from ZippyShareTrue PDF, EPUB13.212/05/2016
How to Download? Report Dead Links & Get a Copy