PostgreSQL 9 Admin Cookbook and over one million other books are available for Amazon Kindle. Learn more
Buy New
$44.99
Qty:1
  • List Price: $49.99
  • Save: $5.00 (10%)
In Stock.
Ships from and sold by Amazon.com.
Gift-wrap available.
Add to Cart
Trade in your item
Get a $17.31
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 2 images

PostgreSQL 9 Admin Cookbook Paperback – October 26, 2010


See all 2 formats and editions Hide other formats and editions
Amazon Price New from Used from
Kindle
"Please retry"
Paperback
"Please retry"
$44.99
$44.99 $34.99


Frequently Bought Together

PostgreSQL 9 Admin Cookbook + PostgreSQL 9.0 High Performance + PostgreSQL: Up and Running
Price for all three: $107.92

Buy the selected items together

Customers Who Bought This Item Also Bought

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.


Shop the New Digital Design Bookstore
Check out the Digital Design Bookstore, a new hub for photographers, art directors, illustrators, web developers, and other creative individuals to find highly rated and highly relevant career resources. Shop books on web development and graphic design, or check out blog posts by authors and thought-leaders in the design industry. Shop now

Product Details

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

Editorial Reviews

About the Author

Simon Riggs

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

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.



Simon Riggs

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

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.


More About the Authors

Discover books, learn about writers, read author blogs, and more.

Customer Reviews

4.0 out of 5 stars
Share your thoughts with other customers

Most Helpful Customer Reviews

9 of 9 people found the following review helpful 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 Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
4 of 4 people found the following review helpful By gabrielle on December 15, 2010
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 Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
1 of 1 people found the following review helpful By Mat on August 4, 2011
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 Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again

Customer Images

Most Recent Customer Reviews

Search

What Other Items Do Customers Buy After Viewing This Item?