PostgreSQL Cookbook

PostgreSQL Cookbook Front Cover
3 Reviews
2015-01-31
286 pages

Book Description

Over 90 hands-on recipes to effectively manage, administer, and design solutions using PostgreSQL

About This Book

  • Implement a highly available PostgreSQL database server and perform administrative and development functions with PostgreSQL
  • Perform database operations in PostgreSQL using Perl and Python
  • Step-by-step recipes focusing on providing real-world Postgresql solutions

Who This Book Is For

If you are a system administrator, database administrator, architect, developer, or anyone with an interest in planning, managing, and designing database solutions using PostgreSQL, this is the book for you. This book is suited for you if you have some prior experience with any relational database or with the language.

In Detail

PostgreSQL is an open source database management system. It is used for a wide variety of development practices such as and , as well as for handling large datasets ().

With the goal of teaching you the skills to master PostgreSQL, the book begins by giving you a glimpse of the unique features of PostgreSQL and how to utilize them to solve real-world problems. With the aid of practical examples, the book will then show you how to create and manage databases. You will learn how to secure PostgreSQL, perform and maintenance tasks, implement high availability features, and provide replication. The book will conclude by teaching you how to migrate information from other databases to PostgreSQL.

Table of Contents

Chapter 1: Managing Databases and the PostgreSQL Server
Chapter 2: Controlling Security
Chapter 3: Backup and Recovery
Chapter 4: Routine Maintenance Tasks
Chapter 5: Monitoring the System Using Unix Utilities
Chapter 6: Monitoring Database Activity and Investigating Issues
Chapter 7: High Availability and Replication
Chapter 8: Connection Pooling
Chapter 9: Table Partitioning
Chapter 10: Accessing PostgreSQL from Perl
Chapter 11: Accessing PostgreSQL from Python
Chapter 12: Data Migration from Other Databases and Upgrading PostgreSQL Cluster

Book Details

  • Title: PostgreSQL Cookbook
  • Author:
  • Length: 286 pages
  • Edition: 1
  • Language: English
  • Publisher:
  • Publication Date: 2015-01-31
  • ISBN-10: 1783555335
  • ISBN-13: 9781783555338
Download LinkFormatSize (MB)Upload Date
Direct download (Recommended!)PDF, EPUB4.605/15/2019
Download from NitroFlarePDF, EPUB4.512/08/2016
Download from UpLoadedPDF, EPUB4.501/05/2017
Download from ZippySharePDF, EPUB4.512/05/2016
How to Download? Report Dead Links & Get a Copy

Leave a Reply