Over 90 hands-on recipes to effectively manage, administer, and design solutions using PostgreSQL
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.
What You Will Learn
Perform regular maintenance tasks to keep your database steady and achieve optimal performance
Design and implement various high availability and replication features to provide redundancy, fault tolerance, and failover
Diagnose and troubleshoot CPU, memory, and I/O related database performance issues
Perform database operations using languages such as Perl and Python
Discover the different backup and recovery strategies that can be implemented in PostgreSQL
Implement connection pooling methods to achieve load balancing
Downloading the example code for this book. You can download the example code files for all Packt books you have purchased from your account at http://www.PacktPub.com. If you purchased this book elsewhere, you can visit http://www.PacktPub.com/support and register to have the files e-mailed directly to you.