PostgreSQL 9 Administration Cookbook: LITE Edition


PostgreSQL 9 Administration Cookbook: LITE Edition
eBook: $9.99
Formats: PDF, PacktLib, ePub and Mobi formats
$8.49
save 15%!
Print + free eBook + free PacktLib access to the book: $29.98    Print cover: $19.99
$19.99
save 33%!
Free Shipping!
UK, US, Europe and selected countries in Asia.
Also available on:
Overview
Table of Contents
Author
Support
Sample Chapters
  • Learn the basics of working with PostgreSQL; connect to a server, explore the database, and adjust the size of your database to the space available.
  • Amend your database with the addition or removal of columns, schemas and tablespaces
  • Part of Packt's Cookbook series: Each recipe is a carefully organized sequence of instructions to complete the task as efficiently as possible

Book Details

Language : English
Paperback : 104 pages [ mm x mm ]
Release Date : May 2011
ISBN : 1849516200
ISBN 13 : 9781849516204
Author(s) : Simon Riggs, Hannu Krosing
Topics and Technologies : All Books, Big Data and Business Intelligence, Lite Editions

Table of Contents

Preface
Chapter 1: First Steps
Chapter 2: Exploring the Database
Chapter 3: Database Administration
Index
  • Chapter 1: First Steps
    • Introduction
    • Introducing PostgreSQL 9
    • Getting PostgreSQL
    • Connecting to PostgreSQL server
    • Enabling access for network/remote users
    • Using graphical administration tools
    • Using psql query and scripting tool
    • Changing your password securely
    • Avoiding hardcoding your password
    • Using a connection service file
    • Troubleshooting a failed connection
    • Chapter 2: Exploring the Database
      • Introduction
      • What version is the server?
      • What is the server uptime?
      • Locate the database server files
      • Locate the database server message log
      • List databases on this database server?
      • How many tables in a database?
      • How much disk space does a database use?
      • How much disk space does a table use?
      • Which are my biggest tables?
      • How many rows in a table?
      • Quick estimate of the number of rows in a table
      • Understanding object dependencies
      • Chapter 3: Database Administration
        • Introduction
        • Writing a script that either all succeeds or all fails
        • Writing a psql script that exits on first error
        • Performing actions on many tables
        • Adding/Removing the columns of a table
        • Changing datatype of a column
        • Adding/Removing schemas
        • Moving objects between schemas
        • Adding/Removing tablespaces
        • Moving objects between tablespaces
        • Accessing objects in other PostgreSQL databases
        • Making views updateable

        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 was a PostgreSQL user before it was rewritten to use SQL as its main query language in 1995. So, he has both the historic perspective of its development and almost 20 years of experience using it for solving various real-life problems. Hannu was the first Database Administrator and Database Architect at Skype, where he invented the sharding language PL/Proxy that allows scaling the user database to work with billions of users. Since leaving Skype at the end of 2006—about a year after it was bought up by eBay—Hannu has been working as a PostgreSQL consultant with 2ndQuadrant, the premier PostgreSQL consultancy with global reach and local presence in most of the world. Hannu has co-authored another Packt Publishing book, PostgreSQL 9 Administration Cookbook, together with one of the main PostgreSQL developers, Simon Riggs.
        Sorry, we don't have any reviews for this title yet.

        Submit Errata

        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.

        Sorry, there are currently no downloads available for this title.

        Compare Books

        See which product is right for you

        PostgreSQL 9 Administration Cookbook: LITE Edition PostgreSQL 9 Admin Cookbook

        Lite Edition

        Learn more

        Full Edition

        Learn more
        Learn the basics of working with PostgreSQL; connect to a server, explore the database, and adjust the size of your database to the space available.
        Amend your database with the addition or removal of columns, schemas and tablespaces
        eBook available as PDF downloads
        eBook available as ePub downloads
        Available on PacktLib
        Monitor your database ensuring that it performs as quickly as possible
        Tips for backup and recovery of your database
        Price £12.99
        £30.99

        Frequently bought together

        PostgreSQL 9 Administration Cookbook: LITE Edition +    Java EE 6 Development with NetBeans 7 =
        50% Off
        the second eBook
        Price for both: £19.64

        Buy both these recommended eBooks together and get 50% off the cheapest eBook.

        What you will learn from this book

        • Explore your database and discover where your server files and server message logs are stored, how much disk space your database is using, and what your object dependencies are 
        • Advanced technical tips and scripts for experienced users
        • Add or remove new columns, schemas, or tablespaces
        • Move your objects between tablespaces and access them in other PostgreSQL databases
        • Best practice for planning and designing live databases

        In Detail

        PostgreSQL is a powerful, open source, enterprise database.

        This PostgreSQL 9 Administration Cookbook LITE book describes key aspects of the PostgreSQL open source database system. The book will help a sysadmin or DBA to get started with key administration issues in PostgreSQL, going from an initial connection to a server, finding out about where your server stores vital information, to removing, adding, or moving objects and changing database schema. This hands-on guide will assist developers working on live databases supporting web or enterprise software applications.

        To find out more about upgrading to the full edition, visit www.packtpub.com/lite-editions and log into your account for offers and help. If you don’t have an account on PacktPub.com, visit today and set one up!

        Approach

        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 in 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. 

        Code Download and Errata
        Packt Anytime, Anywhere
        Register Books
        Print Upgrades
        eBook Downloads
        Video Support
        Contact Us
        Awards Voting Nominations Previous Winners
        Judges Open Source CMS Hall Of Fame CMS Most Promising Open Source Project Open Source E-Commerce Applications Open Source JavaScript Library Open Source Graphics Software
        Resources
        Open Source CMS Hall Of Fame CMS Most Promising Open Source Project Open Source E-Commerce Applications Open Source JavaScript Library Open Source Graphics Software