Enter your mobile number 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.
Getting the download link through email is temporarily not available. Please check back later.

  • Apple
  • Android
  • Windows Phone
  • Android

To get the free app, enter your mobile phone number.

Qty:1
In Stock.
Ships from and sold by Amazon.com. Gift-wrap available.
PostgreSQL 9 Admin Cookbo... has been added to your Cart
+ $3.99 shipping
Used: Like New | Details
Condition: Used: Like New
Comment: Unread copy in perfect condition.
Trade in your item
Get a $3.17
Gift Card.
Have one to sell? Sell on Amazon
Flip to back Flip to front
Listen Playing... Paused   You're listening to a sample of the Audible audio edition.
Learn more
See all 3 images

PostgreSQL 9 Admin Cookbook Paperback – October 26, 2010

4.1 out of 5 stars 12 customer reviews

See all 2 formats and editions Hide other formats and editions
Price
New from Used from
Kindle
"Please retry"
Paperback
"Please retry"
$49.99
$41.58 $29.98

Windows10ForDummiesVideo
Windows 10 For Dummies Video Training
Get up to speed with Windows 10 with this video training course from For Dummies. Learn more.
$49.99 FREE Shipping. In Stock. Ships from and sold by Amazon.com. Gift-wrap available.
click to open popover

Frequently Bought Together

  • PostgreSQL 9 Admin Cookbook
  • +
  • PostgreSQL 9.0 High Performance
  • +
  • PostgreSQL 9 High Availability Cookbook
Total price: $144.97
Buy the selected items together


Editorial Reviews

About the Author

Simon Riggs is one of the few Major Developers and Committers on the PostgreSQL database project, and is also CTO of 2ndQuadrant, providing 24x7 support and services to PostgreSQL users worldwide. Simon has worked with enterprise-class database applications for more than 20 years, with prior certifications on Oracle, Teradata and DB2. Simon is responsible for much of the database recovery and replication code in PostgreSQL, and designed or wrote many of the latest performance enhancements. He uses his operational experience to contribute to many aspects of both internal design and usability. Hannu Krosing is Principal Consultant at 2ndQuadrant and a Technical Advisor at Ambient Sound Investments. As the original database architect at Skype Technologies, Hannu was responsible for designing the Skytools suite of replication and scalability technologies. Hannu has more than 12 years experience working with, and contributing to, the PostgreSQL project.
If you buy a new print edition of this book (or purchased one in the past), you can buy the Kindle edition for only $2.99 (Save 84%). Print edition purchase must be sold by Amazon. Learn more.
For thousands of qualifying books, your past, present, and future print-edition purchases now lets you buy the Kindle edition for $2.99 or less. (Textbooks available for $9.99 or less.)
  • Thousands of books are eligible, including current and former best sellers.
  • Look for the Kindle MatchBook icon on print and Kindle book detail pages of qualifying books. You can also see more Kindle MatchBook titles here or look up all of your Kindle MatchBook titles here.
  • Read the Kindle edition on any Kindle device or with a free Kindle Reading App.
  • Print edition must be purchased new and sold by Amazon.com.
  • Gifting of the Kindle edition at the Kindle MatchBook price is not available.
Learn more about Kindle MatchBook.


Image
Interested in the Audiobook Edition?
If you’re the author, publisher, or rights holder of this book, let ACX help you produce the audiobook.Learn more.

Product Details

  • Paperback: 360 pages
  • Publisher: Packt Publishing (October 26, 2010)
  • Language: English
  • ISBN-10: 1849510288
  • ISBN-13: 978-1849510288
  • Product Dimensions: 7.5 x 0.8 x 9.2 inches
  • Shipping Weight: 1.7 pounds (View shipping rates and policies)
  • Average Customer Review: 4.1 out of 5 stars  See all reviews (12 customer reviews)
  • Amazon Best Sellers Rank: #987,915 in Books (See Top 100 in Books)

Customer Reviews

Top Customer Reviews

By Leo Hsu on November 22, 2010
Format: Paperback
As the book title suggests, it's a cookbook, but a cookbook that combines a question and answer style with a discussion style of writing. The tasks are neatly categorized into 12 chapters and each task smoothly builds on previous tasks discussed. It is still categorized in such a way that you can jump to a particular task you are currently having problems with without having read the other parts of the book.

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 ›
Comment 18 people found this helpful. Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse
Format: Paperback
Disclaimer/note: I received a free review copy of this book from the publisher, in pdf format.

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 ›
Comment 7 people found this helpful. Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse
Format: Paperback Verified Purchase
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.

I've read the pgsql-performance mailing list from Jan 2011 to now (Sep 5th), and you can find a lot of the stuff covered in the book, but it's not nearly as well organized. Save yourself the time and get more info by getting the book.
Comment 2 people found this helpful. Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse
Format: Paperback
First and foremost, this is not a beginners book to postgres. This book contains tips, tricks, and tweaks to the postgres database engine. I picked up this book to further my proficiency of postgres as well as learn more about securing and monitoring the system. What I liked most about this book was the authors approach to the problem--usually beginning in a section called "getting ready", then to "how to do it", and followed-up by "how it works". This provides a great point-based approach to the task at hand and not only tells you how to do it, but how it's actually working in the background to fully round-out one's understanding of the topic.

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 ›
Comment 2 people found this helpful. Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback.
Sorry, we failed to record your vote. Please try again
Report abuse

Most Recent Customer Reviews

Set up an Amazon Giveaway

PostgreSQL 9 Admin Cookbook
Amazon Giveaway allows you to run promotional giveaways in order to create buzz, reward your audience, and attract new followers and customers. Learn more about Amazon Giveaway
This item: PostgreSQL 9 Admin Cookbook