PostgreSQL 9 Admin Cookbook - Riggs_ Simon.pdf

(2622 KB) Pobierz
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd">
859640757.029.png
PostgreSQL 9
Administration Cookbook
Solve real-world PostgreSQL problems with over 100
simple, yet incredibly effective recipes
Simon Riggs
Hannu Krosing
BIRMINGHAM - MUMBAI
859640757.030.png 859640757.031.png 859640757.032.png 859640757.001.png 859640757.002.png 859640757.003.png 859640757.004.png 859640757.005.png 859640757.006.png 859640757.007.png 859640757.008.png 859640757.009.png 859640757.010.png 859640757.011.png 859640757.012.png 859640757.013.png 859640757.014.png 859640757.015.png 859640757.016.png 859640757.017.png 859640757.018.png 859640757.019.png 859640757.020.png 859640757.021.png
PostgreSQL 9 Administration Cookbook
Copyright © 2010 Packt Publishing
All rights reserved. No part of this book may be reproduced, stored in a retrieval system,
or transmitted in any form or by any means, without the prior written permission of the
publisher, except in the case of brief quotations embedded in critical articles or reviews.
Every effort has been made in the preparation of this book to ensure the accuracy of the
information presented. However, the information contained in this book is sold without
warranty, either express or implied. Neither the authors, nor Packt Publishing, and its
dealers and distributors will be held liable for any damages caused or alleged to be
caused directly or indirectly by this book.
Packt Publishing has endeavored to provide trademark information about all of the
companies and products mentioned in this book by the appropriate use of capitals.
However, Packt Publishing cannot guarantee the accuracy of this information.
First published: October 2010
Production Reference: 1191010
Published by Packt Publishing Ltd.
32 Lincoln Road
Olton
Birmingham, B27 6PA, UK.
ISBN 978-1-849510-28-8
www.packtpub.com
Cover Image by John M. Quick ( john.m.quick@gmail.com )
859640757.022.png
Credits
Authors
Simon Riggs
Editorial Team Leader
Akshara Aware
Hannu Krosing
Project Team Leader
Ashwin Shetty
Reviewers
Gabriele Bartolini
Project Coordinator
Zainab Bagasrawala
Dimitri Fontaine
Acquisition Editor
Sarah Cullington
Proofreader
Clyde Jenkins
Development Editor
Eleanor Duffy
Production Coordinator
Kruthika Bangera
Technical Editor
Azharuddin Sheikh
Cover Work
Kruthika Bangera
Copy Editor
Neha Shetty
Indexer
Hemangini Bari
859640757.023.png 859640757.024.png 859640757.025.png 859640757.026.png
 
859640757.027.png
About the Authors
Simon Riggs is a major developer and one of the few committers on the PostgreSQL
database project, as well as CTO of 2ndQuadrant, providing 24x7 support and services
to PostgreSQL users worldwide.
Simon works actively as a database architect and support troubleshooter, skills which drive
and shape his contributions to the development of operational features for PostgreSQL.
Feature credits include Point in Time Recovery, Warm Standby replication, Hot Standby,
Asynchronous Commit, Partitioning and many other performance and tuning features. His
designs and solutions can be found throughout the PostgreSQL code and documentation.
Simon has also previously worked with Oracle, Teradata, and DB2 and holds multiple
certiications. His previous experience covers management and senior technical roles in
the banking, telecommunications and software industries. Simon's early research work
has been published by the Royal Society.
Hannu Krosing is a 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.
859640757.028.png
Zgłoś jeśli naruszono regulamin