PacktPub – PostgreSQL Cookbook Review

Varinder Sandhu Others

PostgreSQL Cookbook published with over 90 hands-on recipes to effectively manage, administer, and design solutions using PostgreSQL cookbook written by Chitij Chauhan who is leading expert in the area of database security, with expertise in database security products such as IBM Infosphere Guardium, Oracle Database Vault and Imperva. You can know more about the Book here bit.ly/1CkxzNe

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 administration 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.

Get into the Details Below:

Managing databases and the PostgreSQL server
Controlling security
Backup and recovery
Routine maintenance tasks
Monitoring the system using Unix utilities
Monitoring database activity and investigating performance issues
High availability and replication
Connection pooling
Table partitioning
Accessing PostgreSQL from Perl
Accessing PostgreSQL from python
Data migration from other databases and upgrading the PostgreSQL cluster

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 SQL language.

Download the sample chapter :bit.ly/1CkxzNe