Free Sample
+ Collection
Code Files

PostgreSQL 9 Administration Cookbook: LITE Edition

Simon Riggs, Hannu Krosing

RRP $9.99
RRP $19.99
Print + eBook

Want this title & more?

$12.99 p/month

Subscribe to PacktLib

Enjoy full and instant access to over 2000 books and videos – you’ll find everything you need to stay ahead of the curve and make sure you can always get the job done.

Book Details

ISBN 139781849516204
Paperback104 pages

About This Book

  • 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

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. 

Table of Contents

What You Will Learn

  • 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 and log into your account for offers and help. If you don’t have an account on, visit today and set one up!


Read More