Over 150 recipes to help you run an efficient PostgreSQL database in the cloud
PostgreSQL is a powerful, open source, object-relational database system, fast becoming one of the world's most popular server databases with an enviable reputation for performance and stability and an enormous range of advanced features.
Starting with short and simple recipes to get you back up and running with an exploration of the ins and outs of your database, you will soon dive into core features such as configuration, server control, tables, and data. This is a practical guide aimed at giving sysadmins and database administrators the necessary toolkit to be able to set up, run, and extend powerful databases with PostgreSQL.
What You Will Learn
Implement PostgreSQL features for reliability and performance
Harness the power of the latest PostgreSQL 9.4 features
Manage PostgreSQL versions 9.0, 9.1, 9.2, 9.3, and 9.4
Advanced technical tips for experienced users
Explore best practices for planning and designing live databases
Select and implement robust backup and recovery techniques
Concise and clear guidance on replication and high availability
Latest details on Logical Replication and Bi-Directional Replication
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.