PostgreSQL Cookbook

Description

Over 90 hands-on recipes to effectively manage, administer, and design solutions using PostgreSQL About This BookImplement a highly available PostgreSQL database server and perform administrative and development functions with PostgreSQLPerform database operations in PostgreSQL using Perl and PythonStep-by-step recipes focusing on providing real-world Postgresql solutionsWho 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 SQL language. In Detail PostgreSQL is an open source database management system. It is used for a wide variety of development practices such as software and web design, as well as for handling large datasets (big data). 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.