Veze, linkovi
Kompjuter biblioteka
Korpa
PostgreSQL Cookbook

Baze podataka Baze podataka

PostgreSQL Cookbook

Autor: Chitij Chauhan
Broj strana: 286
ISBN broj: 9781783555338
Izdavač: PACKT PUBLISHING PACKT PUBLISHING
Godina izdanja: 2016.

                 
Twitter   Facebook   Linkedin   Pinterest   Email
                 
Predlog za prevod

 

What You Will Learn

  • Perform regular maintenance tasks to keep your database steady and achieve optimal performance
  • Design and implement various high availability and replication features to provide redundancy, fault tolerance, and failover
  • Diagnose and troubleshoot CPU, memory, and I/O related database performance issues
  • Perform database operations using languages such as Perl and Python
  • Discover the different backup and recovery strategies that can be implemented in PostgreSQL
  • Implement connection pooling methods to achieve load balancing

Book Description

PostgreSQL is an open source database management system. It is used for a wide variety of development practices such as software and web design, as well as for handling large datasets (big data).

With the goal of teaching you the skills to master PostgreSQL, the book begins by giving you a glimpse of the unique features of PostgreSQL and how to utilize them to solve real-world problems. With the aid of practical examples, the book will then show you how to create and manage databases. You will learn how to secure PostgreSQL, perform administration and maintenance tasks, implement high availability features, and provide replication. The book will conclude by teaching you how to migrate information from other databases to PostgreSQL.

Authors

Chitij Chauhan

Chitij Chauhan currently works as a senior database administrator at an IT-based MNC in Chandigarh. He has over 10 years of work experience in the field of database and system administration, with specialization in MySQL clustering, PostgreSQL, Greenplum, Informix DB2, SQL Server 2008, Sybase, and Oracle. He is a leading expert in the area of database security, with expertise in database security products such as IBM InfoSphere Guardium, Oracle Database Vault, and Imperva.

Table of Contents

Chapter 1: Managing Databases and the PostgreSQL Server
Chapter 2: Controlling Security
Chapter 3: Backup and Recovery
Chapter 4: Routine Maintenance Tasks
Chapter 5: Monitoring the System Using Unix Utilities
Chapter 6: Monitoring Database Activity and Investigating Performance Issues
Chapter 7: High Availability and Replication
Chapter 8: Connection Pooling
Chapter 9: Table Partitioning
Chapter 10: Accessing PostgreSQL from Perl
Chapter 11: Accessing PostgreSQL from Python
Chapter 12: Data Migration from Other Databases and Upgrading the PostgreSQL Cluster

 

Komentari

• Edin Husejnefendic
Rado bi kupio bilo koju knjigu o PotgreSQL jer ne postoji na nasem trzistu.

Ostavite komentar Ostavite komentar

 

Preporučujemo

Nema slike

Popust cena:
rsd

Veze, linkovi
Linkedin Twitter Facebook
 
     
 
© Sva prava pridržana, Kompjuter biblioteka, Beograd, Obalskih radnika 4a, Telefon: +381 11 252 0 272