The book Practical PostgreSQL, by John Worsley and Joshua Drake, gives better understanding of PostgreSQL and to the associated functionality. The book is devoted to PostgreSQL v7.1.x. The content allows you to get easy with PostgreSQL and also to touch academic database subjects. The main target of the writers was to provide the reader with enough understanding of PostgreSQL to create a fully operational PostgreSQL database.
PostgreSQL is an object-relational database management system with long history (from 1977). Practical PostgreSQL provides with full, well arranged information on how to install, configurate, and use PostgreSQL database.
The book guides you in compiling PostgreSQL from source, creating a database, and configurating PostgreSQL to take client-server connections. There are thoroughly made descriptions of the application, including support for transactions, versioning, replication, and referential integrity in the book.
The book contains the chapters on user management, database maintenance, and backup and recovery.
This book is for those readers who are enthusiastic in utilizing the PostgreSQL database management system.