- Paperback: 234 pages
- Publisher: O'Reilly Media; 2 edition (December 28, 2014)
- Language: English
- ISBN-10: 1449373194
- ISBN-13: 978-1449373191
- Product Dimensions: 7 x 0.5 x 9.2 inches
- Shipping Weight: 11.2 ounces (View shipping rates and policies)
- Average Customer Review: 17 customer reviews
- Amazon Best Sellers Rank: #361,580 in Books (See Top 100 in Books)
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 mobile phone number.
PostgreSQL: Up and Running: A Practical Introduction to the Advanced Open Source Database 2nd Edition
Use the Amazon App to scan ISBNs and compare prices.
There is a newer edition of this item:
See the Best Books of 2018 So Far
Looking for something great to read? Browse our editors' picks for the best books of the year so far in fiction, nonfiction, mysteries, children's books, and much more.
Frequently bought together
Customers who bought this item also bought
A Practical Guide to the Advanced Open Source Database
About the Author
Regina Obe is a co-principal of Paragon Corporation, a database consulting company based in Boston. She has over 15 years of professional experience in various programming languages and database systems, with special focus on spatial databases. She is a member of the PostGIS steering committee and the PostGIS core development team. Regina holds a BS degree in mechanical engineering from the Massachusetts Institute of Technology. She co-authored PostGIS in Action.
Leo Hsu is a co-principal of Paragon Corporation, a database consulting company based in Boston. He has over 15 years of professional experience developing and thinking about databases for organizations large and small. Leo holds an MS degree in engineering of economic systems from Stanford University and BS degrees in mechanical engineering and economics from the Massachusetts Institute of Technology. He co-authored PostGIS in Action.
Top customer reviews
There was a problem filtering reviews right now. Please try again later.
However, in teaching PostgreSQL administration, I find that there are still quite a few individuals who like a comprehensive introduction to a topic. Quite a few of these individuals like that comprehensive introduction to be in book form. This is a good resource for those individuals.
WHAT I LIKE:
1) The authors are active in using PostgreSQL
It is obvious from the tone in which the book is written. Small things, like knowing that Amazon's Redshift is a fork of a PostgreSQL fork . . . aren't monumental, but give the authors credibility in my mind since I use Postgres in its community, EnterpriseDB, and Redshift flavors.
2) Concise, quick tips for administrators
There is more to PostgreSQL administration than configuration of the pg_hba.conf, postgresql.conf, and pg_ident.conf files. However, a solid understanding of these will help a new PostgreSQL user troubleshoot 80% of the issues they will likely encounter. A good but brief coverage of these files' formats, psql, and interactive/non-interactive administration are the best reasons for a new admin to buy this book.
3) Datatype discussion, including new JSON types
There has been a lot of buzz in the community regarding the newer JSON data types that some feel make PostgreSQL a serious competitor in both the relational DB world as well as the unstructured data (MongoDB, Cassandra, etc) world. This book gives a great overview of all existing datatypes as well as the new ones available in 9.4.
WHAT I DON'T LIKE:
1) My preference, but I think the treatment of the PgAdmin tool is too extensive. But my default preference for almost all systems is all command line, all the time.
2) DBAs will always ask about replication. I think the chapter on replication is a VERY light treatment of the subject. So, don't buy this book if you expect a step-by-step guide with hints regarding possible problems, workarounds, tests, etc.
Overall, I'm pleased with this purchase. I bought this book to evaluate how appropriate it would be to give to my students as a reference manual. I like it for that and I wish I had something like this when I was new to PostgreSQL. If you're an active PostgreSQL DBA or power user, it might be an interesting read, but nothing amazing.
I have a few minor gripes. At times, I wanted more detailed explanations. For example, the flags for using pg_dump are complicated. An example used –C –F –b –v –f, but I had to look up each flag separately in an appendix. Knowing that this creates a ‘single, compressed database backup’ isn’t enough.
A second gripe was that references to more detailed articles by the authors were given as ‘bit.ly’ URLs which are annoying to type in. Surely they could have taken the trouble to create user-friendly pages on WordPress or, at the cost of a few dollars, put them onto a website dedicated to the book.
Overall, however, I would thoroughly recommend this book to anybody (except a novice in SQL) who wants to learn more about this powerful object relational database application.
I read this over this past Summer, and I can comfortably use Postgres features I'm likely to need, as well as some of the unusual ones I didn't even know SQL programs offered (although, perhaps I should say, "unusual ones Postgres offers", since MySQL, MariaDB, and even Oracle lack some of these features).
Postgres has a LOT of interesting and powerful features, and this book will help you to learn them.
Of course, with the sheer amount of features Postgres has, you could fill several encyclopaedic volumes, but this book will get you "up and running" with the system and ready to learn any other feature you might happen across and want to try.