PostgreSQL administration essentials : discover efficient ways to administer, monitor, replicate, and handle your PostgreSQL databases /

Mostrar otras versiones (2)

Annotation

Detalles Bibliográficos
Clasificación:Libro Electrónico
Autor principal: Schönig, Hans-Jürgen (Autor)
Formato: Electrónico eBook
Idioma:Inglés
Publicado: Birmingham, England : Packt Publishing, 2014.
Colección:Community experience distilled.
Temas:
PostgreSQL.
PostgreSQL
Database management.
Bases de données > Gestion.
COMPUTERS > Programming Languages > SQL.
COMPUTERS > Databases > General.
Database management
Acceso en línea:Texto completo
Texto completo
Tabla de Contenidos:
  • Cover; Copyright; Credits; About the Author; About the Reviewers; www.PacktPub.com; Table of Contents; Preface; Chapter 1: Installing PostgreSQL; Preparing your setup; Understanding the PostgreSQL version numbers; Choosing the right version; Installing binary packages; Installing PostgreSQL on Debian or Ubuntu; Installing PostgreSQL on Red-Hat-based systems; Compiling PostgreSQL from source; How it works; Installing the contrib packages; Finalizing your installation; Creating a database instance; Firing up PostgreSQL; Understanding the existing databases; Creating databases; Summary
  • Chapter 2: Indexing and Performance TuningUsing simple binary trees; Preparing the data; Understanding the concept of execution plans; Calculating costs; Drawing important conclusions; Creating indexes; Analyzing the performance of a query; The internal structure of a B-tree index; Understanding the B-tree internals; Providing a sorted order; Combined indexes; Partial indexes; Dealing with different types of indexes; Detecting missing indexes; Detecting slow queries; How to reset statistics; Adjusting memory parameters; Optimizing shared buffers; Considering huge pages; Tweaking work_mem
  • Improving maintenance_work_memAdjusting effective_cache_size; Summary; Chapter 3: Users and Permissions; Understanding PostgreSQL security; Configuring the TCP; Managing network authentication; Managing contradictions; Authentication methods available; Some more examples; Handling SSL; Changing pg_hba.conf; Handling instance-level permissions; Creating roles; Modifying and dropping roles; Controlling database-level permissions; Understanding schema-level permissions; Handling table-level permissions; Managing column rights; Improving security with SELinux; Summary
  • Chapter 4: Managing LogfilesUnderstanding the PostgreSQL log architecture; Configuring log destinations; Creating local logfiles; Using syslog; Configuring logs on Windows; Performance considerations; Configuring the amount of log output; Making logs more readable; Additional settings; Making log creation more fine grained; Logging selectively; Focusing on slow queries; Silencing notices; Summary; Chapter 5: Backup and Recovery; Importing and exporting data; Using the COPY command; Basic operations of the COPY command; Making use of pipes; Performing backups; Handling pg_dump
  • More sophisticated dumpingPerforming partial replays; Passing users and passwords; Dumping an entire instance; Understanding backups and user creation; Summary; Chapter 6: Handling Replication and Improving Performance; Understanding the PostgreSQL transaction log; The purpose of the transaction log; Inspecting the size of the transaction log; Configuring the checkpoints; Optimizing the checkpoints; Configuring the distance between checkpoints; Controlling writes; Setting up an asynchronous replication; Obtaining a high-level overview; Setting up replication step by step; Preparing the slave

Ejemplares similares