Cargando…
PostgreSQL administration essentials : discover efficient ways to administer, monitor, replicate, and handle your PostgreSQL databases /
Annotation
| Clasificación: | Libro Electrónico |
|---|---|
| Autor principal: | |
| Formato: | Electrónico eBook |
| Idioma: | Inglés |
| Publicado: |
Birmingham, England :
Packt Publishing,
2014.
|
| Colección: | Community experience distilled.
|
| Temas: | |
| Acceso en línea: | Texto completo Texto completo |
MARC
| LEADER | 00000cam a2200000 i 4500 | ||
|---|---|---|---|
| 001 | EBOOKCENTRAL_ocn896837316 | ||
| 003 | OCoLC | ||
| 005 | 20240329122006.0 | ||
| 006 | m o d | ||
| 007 | cr cn||||||||| | ||
| 008 | 141024t20142014enk o 001 0 eng d | ||
| 040 | |a E7B |b eng |e rda |e pn |c E7B |d OCLCO |d OCLCQ |d YDXCP |d OCLCQ |d COCUF |d K6U |d CNNOR |d CCO |d PIFAG |d FVL |d N$T |d OCLCO |d N$T |d IDEBK |d EBLCP |d DEBSZ |d VT2 |d COO |d REB |d FEM |d OCLCQ |d OCLCO |d ZCU |d OCLCF |d AGLDB |d MERUC |d OCLCQ |d OCLCO |d U3W |d D6H |d STF |d OCLCQ |d VTS |d ICG |d INT |d OCLCQ |d OCLCO |d G3B |d TKN |d OCLCQ |d OCLCO |d DKC |d OCLCQ |d HS0 |d OCLCQ |d OCLCO |d OCLCQ |d OCLCO |d OCLCL | ||
| 019 | |a 893652970 |a 907288861 |a 968042965 |a 969012226 | ||
| 020 | |a 9781783988990 |q (e-book) | ||
| 020 | |a 1783988991 |q (e-book) | ||
| 020 | |a 1322208565 | ||
| 020 | |a 9781322208565 | ||
| 020 | |z 9781783988983 | ||
| 020 | |z 1783988983 | ||
| 029 | 1 | |a AU@ |b 000058967127 | |
| 029 | 1 | |a AU@ |b 000065313210 | |
| 029 | 1 | |a AU@ |b 000067097816 | |
| 029 | 1 | |a CHNEW |b 000688080 | |
| 029 | 1 | |a CHNEW |b 000688081 | |
| 029 | 1 | |a CHNEW |b 000889122 | |
| 029 | 1 | |a CHVBK |b 374478414 | |
| 029 | 1 | |a DEBBG |b BV043613102 | |
| 029 | 1 | |a DEBSZ |b 420089373 | |
| 029 | 1 | |a DEBSZ |b 493154221 | |
| 035 | |a (OCoLC)896837316 |z (OCoLC)893652970 |z (OCoLC)907288861 |z (OCoLC)968042965 |z (OCoLC)969012226 | ||
| 037 | |a 652136 |b MIL | ||
| 050 | 4 | |a QA76.9.D3 |b .S3 2014eb | |
| 072 | 7 | |a COM |x 051170 |2 bisacsh | |
| 072 | 7 | |a COM |x 021000 |2 bisacsh | |
| 082 | 0 | 4 | |a 005.74 |2 23 |
| 049 | |a UAMI | ||
| 100 | 1 | |a Schönig, Hans-Jürgen, |e author. | |
| 245 | 1 | 0 | |a PostgreSQL administration essentials : |b discover efficient ways to administer, monitor, replicate, and handle your PostgreSQL databases / |c Hans-Jürgen Schönig. |
| 264 | 1 | |a Birmingham, England : |b Packt Publishing, |c 2014. | |
| 264 | 4 | |c ©2014 | |
| 300 | |a 1 online resource (129 pages) | ||
| 336 | |a text |b txt |2 rdacontent | ||
| 337 | |a computer |b c |2 rdamedia | ||
| 338 | |a online resource |b cr |2 rdacarrier | ||
| 347 | |a text file | ||
| 490 | 1 | |a Community Experience Distilled | |
| 588 | 0 | |a Online resource; title from PDF title page (ebrary, viewed October 24, 2014). | |
| 500 | |a Includes index. | ||
| 520 | 8 | |a Annotation |b If you are a database administrator who needs to get to grips with PostgreSQL quickly and efficiently, then this book is for you. This book will also be highly beneficial if you are a project leader or a developer who is interested in knowing more about database systems or bottleneck detection, as it will enable you to work more closely and cooperatively with your administrators. | |
| 505 | 0 | |a 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 | |
| 505 | 8 | |a 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 | |
| 505 | 8 | |a 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 | |
| 505 | 8 | |a 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 | |
| 505 | 8 | |a 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 | |
| 590 | |a O'Reilly |b O'Reilly Online Learning: Academic/Public Library Edition | ||
| 590 | |a eBooks on EBSCOhost |b EBSCO eBook Subscription Academic Collection - Worldwide | ||
| 590 | |a ProQuest Ebook Central |b Ebook Central Academic Complete | ||
| 630 | 0 | 0 | |a PostgreSQL. |
| 630 | 0 | 7 | |a PostgreSQL |2 fast |
| 650 | 0 | |a Database management. | |
| 650 | 6 | |a Bases de données |x Gestion. | |
| 650 | 7 | |a COMPUTERS |x Programming Languages |x SQL. |2 bisacsh | |
| 650 | 7 | |a COMPUTERS |x Databases |x General. |2 bisacsh | |
| 650 | 7 | |a Database management |2 fast | |
| 758 | |i has work: |a PostgreSQL administration essentials (Text) |1 https://id.oclc.org/worldcat/entity/E39PD3WbTWXpDMHMyk8WgQF8Q3 |4 https://id.oclc.org/worldcat/ontology/hasWork | ||
| 776 | 0 | 8 | |i Print version: |a Schönig, Hans-Jürgen. |t PostgreSQL administration essentials : discover efficient ways to administer, monitor, replicate, and handle your PostgreSQL databases. |d Birmingham, England : Packt Publishing, ©2014 |h iv, 125 pages |k Community experience distilled. |z 9781783988983 |
| 830 | 0 | |a Community experience distilled. | |
| 856 | 4 | 0 | |u https://learning.oreilly.com/library/view/~/9781783988983/?ar |z Texto completo |
| 856 | 4 | 0 | |u https://ebookcentral.uam.elogim.com/lib/uam-ebooks/detail.action?docID=1818071 |z Texto completo |
| 938 | |a EBL - Ebook Library |b EBLB |n EBL1818071 | ||
| 938 | |a ebrary |b EBRY |n ebr10954710 | ||
| 938 | |a EBSCOhost |b EBSC |n 870056 | ||
| 938 | |a ProQuest MyiLibrary Digital eBook Collection |b IDEB |n cis29914675 | ||
| 938 | |a YBP Library Services |b YANK |n 12124105 | ||
| 994 | |a 92 |b IZTAP | ||