Enter your mobile number or email address below and we'll send you a link to download the free Kindle App. Then you can start reading Kindle books on your smartphone, tablet, or computer - no Kindle device required.
To get the free app, enter your email address or mobile phone number.
PostgreSQL 9 Admin Cookbook Paperback – October 26, 2010
|New from||Used from|
Top 20 lists in Books
View the top 20 best sellers of all time, the most reviewed books of all time and some of our editors' favorite picks. Learn more
Frequently Bought Together
Customers Who Bought This Item Also Bought
About the Author
More About the AuthorsDiscover books, learn about writers, read author blogs, and more.
Top Customer Reviews
Although it is titled PostgreSQL 9 -- it covers earlier versions as well.
This is one of those books I wish I had when training some of our customers or had early on. A lot of the questions - we are commonly asked or have stumbled on - like how to troubleshoot bad queries, how to tell what are my biggest tables, how to deal with data corruption etc, are all succinctly covered in this book.
Just to get a taste of what this book offers:
1. Chapter 1: First steps This is mostly a newbie chapter, that introduces you to PostgreSQL, guides you thru connecting to the database using commandline and PgAdmin. Some other examples of commonly used GUIs. Configuring access control, troubleshooting failed connections. It provides tips both for the Linux as well as the Windows user.
2. Chapter 2: Exploring the database starts to get into what I would call intermediate territory. It covers tasks such as determining where your database files are, how to determine disk space utilization for both whole database and individual tables. Getting quick estimate of number of rows for large tables where doing a count would be really slow. Using psql and the various system tables to determine object dependency.
3. Chapter 3: Configuration A good chapter not just for PostgreSQL users but I would say any database designer.Read more ›
The PostgreSQL community has been waiting for a "cookbook", and I'm really excited that we finally have one. The PostgreSQL 9 Admin Cookbook contains many tips & techniques I'm going to put to immediate use. Like, pgloader and the ON_ERROR_STOP option to psql. This book also reminded me that there's still a lot I don't know about Postgres: for example, I've never worked with pg_controldata or the quote_ident() function. If you're a Pg admin (or wannabe), you should give this book at least a run-through, even if you think you already know everything.
Most of the "recipes" in this cookbook will stand on their own; some require material from previous or other referenced sections to make sense. I am a sucker for conversational style, and while the book gets off to a rough start, it does even out after a bit. Big blocks of SQL are formatted consistently in a style that, while it's not one I use myself, is easy to read.
The authors give a great explanation of why they prefer their filesystem set up a specific way, and how to do it (of course, it probably helps that I agree with them on this point); and good advice about schema & relation names. Specific problem-solving tools I found useful are: the list of steps to troubleshoot failed connections; specific things to do if a backend is hung, or a query is taking too long; and generating test data and taking random samples of real-world data. They also give warnings where something you do might cause application downtime.
Sadly, this book suffers from inadequate editing, dragging the rating down from a solid four stars.Read more ›
The first couple of chapters are pretty rudimentary--getting started, setting up the database, configuration. Nothing too special, here.
The next three chapters covered server control, tables & data, security. To be honest, the chapter on security was the reason i wanted this book. I was curious to know about how to encrypt sensitive data in the database, and more so with encryption at rest. While the topics of encryption were covered with pgcrypto package, I just wish this section was a bit longer and provided more examples--especially on covering really sensitive information.
The next three chapters covered database administration, monitoring, and maintenance. I found the maintenance chapter quite useful for managing and repairing/removing indexes. Also, the monitoring session on who's doing what proved quite interesting.
Finally, we finish up with concurrency, backup/recovery, and replication. The other chapter I was really after in this book was over backup and recovery.Read more ›
Most Recent Customer Reviews
great info and helpful understanding of how to get started with postgresqlPublished 3 months ago by Ryan
It's a very good guide to start working with Postgres. Just meet its subtittle: "Quick answer to common problems". Its easy to read it and include a lot of examples.Published 16 months ago by Rafael Otero Lorenzo
If you're familiar with any other DB (for instance MySQL) and you want to move to PostgreSQL than this book is simply the best.Published 18 months ago by Pawel Biel
A good read where I found some inside information I am currently using in my jobPublished 19 months ago by Xavier
The other reviews pretty much cover everything, but I wanted to get my star rating in.
If you're a sysadmin who has had to deal with the basics of keeping PG running and... Read more
The book is good but kindle version is missing commands in a lots of places. Nothing follows after semicolumn ...Published on December 9, 2011 by jurgis
To the Publisher:
The 'How to do it...' section of 'Backup database object definitions' is missing three pieces of example code, which should follow the colon in the... Read more
This book does exactly what it advertises -- it tells you what to do and NOT to do if you want your PG application to fly. Read morePublished on September 5, 2011 by Karl Vogel