Free Trial

Safari Books Online is a digital library providing on-demand subscription access to thousands of learning resources.

Help

PostgresSQL


1. 

PostgreSQL Replication

PostgreSQL Replication

By: Zoltan Böszörmenyi; Hans-Jürgen Schönig

Publisher: Packt Publishing

Publication Date: 26-AUG-2013

Insert Date: 07-SEP-2013

Slots: 1.0

Table of Contents • Start Reading

Understand basic replication concepts and efficiently replicate PostgreSQL using high-end techniques to protect your data and run your server without interruptions Explains the new replication features introduced in PostgreSQL 9 Contains easy to understand explanations and lots of screenshots that simplify an advanced topic like replication Teaches PostgreSQL administrators how to maintain consistency between redundant resources and to improve reliability, fault-tolerance, and accessibility In Detail PostgreSQL offers a comprehensive set of replication related...

2. 

PostgreSQL Server Programming

PostgreSQL Server Programming

By: Hannu Krosing; Kirk Roybal; Jim Mlodgenski

Publisher: Packt Publishing

Publication Date: 25-JUN-2013

Insert Date: 03-JUL-2013

Slots: 1.0

Table of Contents • Start Reading

Extend PostgreSQL and integrate the database layer into your development framework Understand the extension framework of PostgreSQL, and leverage it in ways that you haven't even invented yet Write functions, create your own data types, all in your favourite programming language Step-by-step tutorial with plenty of tips and tricks to kick-start server programming In Detail Learn how to work with PostgreSQL as if you spent the last decade working on it. PostgreSQL is capable of providing you with all of the options that you have in your favourite development language and...

3. 

Instant PostgreSQL Starter

Instant PostgreSQL Starter

By: Daniel K. Lyons;

Publisher: Packt Publishing

Publication Date: 24-APR-2013

Insert Date: 30-APR-2013

Slots: 1.0

Table of Contents • Start Reading

Discover how to get started using PostgreSQL with minimal hassle! Learn something new in an Instant! A short, fast, focused guide delivering immediate results. Get your database online, back it up, and make it useful as quickly as possible Discover how you can utilize PostgreSQL's simple and dependable backup mechanism Illustrated platform-independent instructions that show you how to complete each step with confidence In Detail PostgreSQL is an incredibly flexible and dependable open source relational database. Harnessing its power will make your applications...

4. 

Instant PostgreSQL Backup and Restore How-to

Instant PostgreSQL Backup and Restore How-to

By: Shaun M. Thomas;

Publisher: Packt Publishing

Publication Date: 26-MAR-2013

Insert Date: 01-APR-2013

Slots: 1.0

Table of Contents • Start Reading

A step-by-step guide to backing up and restoring your database using safe, efficient, and proven recipes Learn something new in an Instant! A short, fast, focused guide delivering immediate results. Back up and restore PostgreSQL databases Use built-in tools to create simple backups Restore the easy way with internal commands Cut backup and restore time with advanced techniques In Detail Backing up a database is something that all system admins must eventually face. Larger warehouses and critical enterprise data requires advanced techniques and tools to handle this...

5. 

PostgreSQL-Administration, 3rd Edition

PostgreSQL-Administration, 3rd Edition

By: Peter Eisentraut; Bernd Helmle

Publisher: O'Reilly Verlag

Publication Date: 21-MAR-2013

Insert Date: 22-MAR-2013

Slots: 1.0

Table of Contents • Start Reading

PostgreSQL hat sich bei professionellen Datenbankadministratoren als hoch performantes und robustes Datenbanksystem durchgesetzt. PostgreSQL ist freie Software, wird seit Ende der 80er Jahre von einer engagierten Community ständig weiterentwickelt und besitzt die Eigenschaften, Zuverlässigkeit und Performance kommerzieller Datenbanksysteme. Die Autoren sind aktive Entwicklungsmitglieder der PostgreSQL Community und geschätzte Datenbankexperten. Die 3. Auflage von PostgreSQL Administration behandelt die im September 2012 erschienene Version 9.2. Die neue Version enthält gerade im Bereich...

6. 

Bases de données PostgreSQL: Gestion des performances

Bases de données PostgreSQL: Gestion des performances

By: Gregory Smith

Publisher: Pearson France

Publication Date: 01-MAY-2011

Insert Date: 16-OCT-2012

Slots: 1.0

Table of Contents • Start Reading

PostgreSQL est réputé pour sa richesse fonctionnelle, sa stabilité et, depuis la version 8.1, l'amélioration sérieuse de ses performances. Cela satisfait les utilisateurs exigeants, mais peut aussi dérouter ceux n'ayant pas l'expérience d'un SGBD aussi complet. Cet ouvrage détaille les points essentiels à connaître pour obtenir les meilleures performances avec PostgreSQL, de la version 8.1 à la 9.0. Il s'adresse aux administrateurs qui utilisent ou vont utiliser PostgreSQL, ainsi qu'aux développeurs souhaitant des informations sur son fonctionnement interne pour la conception...

7. 

PostgreSQL: Up and Running

PostgreSQL: Up and Running

By: ;

Publisher: O'Reilly Media, Inc.

Publication Date: 11-JUL-2012

Insert Date: 07-JUL-2012

Slots: 1.0

Table of Contents • Start Reading

If you’re thinking about migrating to the PostgreSQL open source database system, this guide provides a concise overview to help you quickly understand and use PostgreSQL’s unique features. Not only will you learn about the enterprise class features in the 9.2 release, you’ll also discover that PostgeSQL is more than just a database system—it’s also an impressive application platform. With numerous examples throughout this book, you’ll learn how to achieve tasks that are difficult or impossible in other databases....

8. 

PostgreSQL-Administration, 2nd Edition

PostgreSQL-Administration, 2nd Edition

By: Peter Eisentraut; Bernd Helmle

Publisher: O'Reilly Verlag

Publication Date: 30-MAY-2012

Insert Date: 06-APR-2012

Slots: 1.0

Table of Contents • Start Reading

PostgreSQL - das fortschrittlichste Open-Source-Datenbankmanagementsystem der Welt. So lautet weithin unangefochten seit einem Jahrzehnt der Untertitel zu PostgreSQL. Mittlerweile ist es millionenfach im Einsatz, Teil der kritischen öffentlichen Infrastruktur des Internets und ein zentrales Element in der Zukunft der Datenbankwelt. Die zweite Auflage wurde von den Autoren, die auch Core-Entwickler sind, auf Version 9 aktualisiert....

9. 

Practical PostgreSQL

Practical PostgreSQL

By: ;

Publisher: O'Reilly Media, Inc.

Publication Date: 07-JAN-2002

Insert Date: 26-MAY-2011

Slots: 1.0

Table of Contents • Start Reading

Arguably the most capable of all the open source databases, PostgreSQL is an object-relational database management system that--until now--lacked comprehensive, easy-to-use documentation. Practical PostgreSQL is a fast-paced guide that shows you how to get PostgreSQL installed, configured, and running. This comprehensive book delves into the many advanced features of the PostgreSQL Application Server, LXP, including the the use of SQL within PostgreSQL, and covers basic PostgreSQL database administration....

10. 

PostgreSQL 9.0 High Performance

PostgreSQL 9.0 High Performance

By: Gregory Smith;

Publisher: Packt Publishing

Publication Date: 20-OCT-2010

Insert Date: 10-FEB-2011

Slots: 1.0

Table of Contents • Start Reading

Accelerate your PostgreSQL system Learn the right techniques to obtain optimal PostgreSQL database performance, from initial design to routine maintenance Discover the techniques used to scale successful database installations Avoid the common pitfalls that can slow your system down Filled with advice about what you should be doing; how to build experimental databases to explore performance topics, and then move what you've learned into a production database environment Covers versions 8.1 through 9.0 In Detail PostgreSQL database servers have a common set of problems...

11. 

PostgreSQL 9 Administration Cookbook

PostgreSQL 9 Administration Cookbook

By: Simon Riggs; Hannu Krosing

Publisher: Packt Publishing

Publication Date: 26-OCT-2010

Insert Date: 10-FEB-2011

Slots: 1.0

Table of Contents • Start Reading

Over 80 recipes to help you run an efficient PostgreSQL 9.0 database 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 In Detail 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...

12. 

PostgreSQL-Administration

PostgreSQL-Administration

By: Peter Eisentraut; Bernd Helmle

Publisher: O'Reilly Verlag

Publication Date: 15-OCT-2008

Insert Date: 18-MAR-2009

Slots: 1.0

Table of Contents • Start Reading

PostgreSQL - das fortschrittlichste Open-Source-Datenbankmanagementsystem der Welt. So lautet weithin unangefochten seit einem Jahrzehnt der Untertitel zu PostgreSQL. Mittlerweile ist es millionenfach im Einsatz, Teil der kritischen öffentlichen Infrastruktur des Internets und ein zentrales Element in der Zukunft der Datenbankwelt. PostgreSQL ist Open Source, es ist kostenlos verfügbar und wird von einer großen, offenen Community aus Anwendern und Entwicklern vorangetrieben. Stabile und performante Datenbank PostgreSQL-Administration richtet sich primär an Administratoren von...

13. 

PostgreSQL, Second Edition

PostgreSQL, Second Edition

By: Korry Douglas; Susan Douglas

Publisher: Sams

Publication Date: 26-JUL-2005

Insert Date: 06-AUG-2005

Slots: 1.0

Table of Contents • Start Reading

The second edition of the best-selling PostgreSQL has been updated to completely cover new features and capabilities of the 8.0 version of PostgreSQL. You will be lead through the internals of the powerful PostgreSQL open source database chapter, offering an easy-to-read, code-based approach that makes it easy to understand how each feature is implemented, how to best use each feature, and how to get more performance from database applications. This definitive guide to building, programming and administering the powerful PostgreSQL open-source database system will help you harness one of the...

14. 

PostgreSQL

PostgreSQL

By: 

Publisher: Sams

Publication Date: 13-FEB-2003

Insert Date: 20-JUN-2003

Slots: 1.0

Table of Contents • Start Reading

PostgreSQL is the world¿s most advanced open-source database. PostgreSQL is the most comprehensive, in-depth, and easy-to-read guide to this award-winning database. This book starts with a thorough overview of SQL, a description of all PostgreSQL data types, and a complete explanation of PostgreSQL commands. If you are a developer or an administrator, you¿ll love the chapter that explores PostgreSQL performance. The authors explain how PostgreSQL stores data on disk (and in memory) and how to measure and influence the effectiveness of PostgreSQL¿s caching mechanisms. You¿ll also learn how...

15. 

PostgreSQL Essential Reference

PostgreSQL Essential Reference

By: 

Publisher: Sams

Publication Date: 15-OCT-2001

Insert Date: 21-NOV-2002

Slots: 1.0

Table of Contents • Start Reading

PostgreSQL Essential Reference is a reference book for developers and system administrators who are already familiar with SQL database concepts but that need clear and concise documentation that is specific to PostgreSQL. The book is divided into 3 parts; Basic SQL Reference, PostgreSQL specifics, and PostgreSQL administration. On a whole, it provides a command, the syntax, available options, description, and example code. Readers will be able to easily utilize the code and concepts into their use f the product. An added advantage to this book is that provides all reference material in two...

16. 

PostgreSQL Developer's Handbook

PostgreSQL Developer's Handbook

By: 

Publisher: Sams

Publication Date: 18-DEC-2001

Insert Date: 12-OCT-2002

Slots: 1.0

Table of Contents • Start Reading

PostgreSQL is an object-relational database server that is widely considered to be the world¿s most advanced open-source database system. It is ANSI SQL-compatible, and it offers powerful features to enable more complex software design than would be possible with relational databases that are not object-oriented. PostgreSQL is extremely modular, it supports a large number of datatypes, and programming interfaces for PostgreSQL are available for all important programming languages, including C, Perl, Python, Tcl, Java, and PHP. PostgreSQL Developer¿s Handbook provides a complete overview of...