PostgreSQL 9 Admin Cookbook
|Also available on:|
- Administer and maintain a healthy database
- Monitor your database ensuring that it performs as quickly as possible
- Tips for backup and recovery of your database
Table of Contents
Chapter 1: First Steps
Chapter 2: Exploring the Database
Chapter 3: Configuration
Chapter 4: Server Control
Chapter 5: Tables & Data
Chapter 6: Security
Chapter 7: Database Administration
Chapter 8: Monitoring and Diagnosis
Chapter 9: Regular Maintenance
Chapter 10: Performance & Concurrency
Chapter 11: Backup & Recovery
Chapter 12: Replication & Upgrades
The book gave me the opportunity to look over the shoulder of experienced PostgreSQL users and administrators to see how they go about doing things, and compare to how I've done them. I'm glad to have had the opportunity. Read more
Download the code and support files for this book.
Please let us know if you have found any errors not listed on this list by completing our errata submission form. Our editors will check them and add them to this list. Thank you.
Errata- 4 submitted: last submission 10 Feb 2014
Errata type: Code | Page numbers: 90
)The following statement (sudo pg_createcluster 9.0 > database2) is repeated. > > To create an additional data directory, run the following: > sudo pg_createcluster 9.0 database2 > > which can then be started using the following: > sudo pg_createcluster 9.0 database2 The proper start command should be sudo pg_ctlcluster 9.0 database2 start
Errata type: Typo | Page numbers: 136
To give the role bob the ability to create new users, run the following:
ALTER ROLE BOB WITH CREATEUSER;
but it should be noted that the correct word is "CREATEROLE", not "CREATEUSER".
Errata type: Typo | Page numbers: 309
Under point 3: The sentence "Add the following line to the " is missing "Master node"
Under point 5: The configuration values erroneously lists "wal_mode", which should be "wal_level".
Errata type: Typo | Page numbers: 66
the line that start with "ALTER ROLE saas" should be "ALTER ROLE simon"
Errata type: Typo | Page numbers: 27
The line in the middle that goes like "you can use just onr or the other" should probably be "you can use just one or the other"
Errata type: Typo | Page numbers: 309
Under point 3: The sentence "Add the following line to the " is missing "Master node" Under point 5: The configuration values erroneously lists "wal_mode", which should be "wal_level".
Errata type: Typo | Page numbers: 147
The line "There was also a nice presentacion named "Encrypted PostgreSQL" explaining these issues
at pgcon2009." should probably be "There was also a nice presentation named "Encrypted PostgreSQL" explaining these issues
Errata Typo: Code related | Page no: 278
It is: archive_command = 'test ! ../standalone/archiving_active || cp -i %p
It should be: archive_command = 'test ! -f ../standalone/archiving_active || cp -i %p
What you will learn from this book
- How to implement PostgreSQL features for reliability and performance
- How to use the latest PostgreSQL 9.0 features
- Summaries to help DBAs with experience of other database systems
- Advanced technical tips and scripts for experienced users
- Best practice for planning and designing live databases
- How and when to VACUUM your databases
- Selecting and implementing robust backup techniques
- Concise and clear guidance on replication and high availability
PostgreSQL is a powerful, open source object-relational database system. An enterprise database, PostgreSQL includes features such as Multi-Version Concurrency Control (MVCC), point-in-time recovery, tablespaces, asynchronous replication, nested transactions (savepoints), online/hot backups, a sophisticated query planner/optimizer, and write-ahead logging for fault tolerance. PostgreSQL 9 Admin cookbook covers everything a database administrator needs to protect, manage and run a healthy and efficient PostgreSQL 9.0 database.
PostgreSQL 9 Admin Cookbook describes key aspects of the PostgreSQL open source database system. The book covers everything a sysadmin or DBA needs to protect, manage, and run a healthy and efficient PostgreSQL 9 database. This hands-on guide will assist developers working on live databases, supporting web or enterprise software applications using Java, Python, Ruby, or .Net from any development framework. It's easy to manage your database when you've got PostgreSQL 9 Admin Cookbook to hand.
PostgreSQL is fast becoming one of the world's most popular server databases with an enviable reputation for performance, stability, and an enormous range of advanced features. PostgreSQL is one of the oldest open source projects, completely free to use and developed by a very diverse worldwide community. Most of all, It Just Works!
PostgreSQL 9 Admin Cookbook offers the information you need to manage your live production databases on PostgreSQL. The book contains insights direct from the main author of the PostgreSQL replication and recovery features, and the database architect of the most successful startup using PostgreSQL, Skype.
This practical guide gives quick answers to common questions and problems, building on the authors' experience as trainers, users, and core developers of the PostgreSQL database server.
Each technical aspect is broken down into short recipes that demonstrate solutions with working code then explain why and how that works. The book is intended to be a desk reference for both new users and technical experts.
The book covers all the latest features in PostgreSQL 9. Soon you will be running a smooth database with ease!
A practical guide, this cookbook will ensure you run a smooth PostgreSQL database
Written in the cookbook style, this book offers learning and techniques through recipes. It contains step-by-step instructions for administrators and developers to manage databases on PostgreSQL. The book is designed in such a way that you can read it chapter by chapter or refer to recipes in no particular order.
Who this book is for
This book is for Sysadmins, Database Administrators, Architects, Developers, and anyone with an interest in planning for or running live production databases. This book is most suited to those who have some technical experience.