PostgreSQL administration essentials :: discover efficient ways to administer, monitor, replicate, and handle your PostgreSQL databases /
Annotation
Gespeichert in:
| 1. Verfasser: | |
|---|---|
| Format: | Elektronisch E-Book |
| Sprache: | English |
| Veröffentlicht: |
Birmingham, England :
Packt Publishing,
2014.
|
| Schriftenreihe: | Community experience distilled.
|
| Schlagworte: | |
| Online-Zugang: | Volltext |
| Zusammenfassung: | Annotation |
| Beschreibung: | Includes index. |
| Beschreibung: | 1 online resource (129 pages) |
| ISBN: | 9781783988990 1783988991 1322208565 9781322208565 |
Internformat
MARC
| LEADER | 00000cam a2200000 i 4500 | ||
|---|---|---|---|
| 001 | ZDB-4-EBA-ocn896837316 | ||
| 003 | OCoLC | ||
| 005 | 20241004212047.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 |d UEJ |d OCLCQ | ||
| 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 | ||
| 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 | 7 | |a 005.74 |2 23 | |
| 049 | |a MAIN | ||
| 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 | |
| 630 | 0 | 0 | |a PostgreSQL. |0 http://id.loc.gov/authorities/names/n00067354 |
| 630 | 0 | 7 | |a PostgreSQL |2 fast |
| 650 | 0 | |a Database management. |0 http://id.loc.gov/authorities/subjects/sh85035848 | |
| 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. |0 http://id.loc.gov/authorities/names/no2011030603 | |
| 856 | 4 | 0 | |l FWS01 |p ZDB-4-EBA |q FWS_PDA_EBA |u https://search.ebscohost.com/login.aspx?direct=true&scope=site&db=nlebk&AN=870056 |3 Volltext |
| 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 GEBAY | ||
| 912 | |a ZDB-4-EBA | ||
| 049 | |a DE-863 | ||
Datensatz im Suchindex
| DE-BY-FWS_katkey | ZDB-4-EBA-ocn896837316 |
|---|---|
| _version_ | 1816882294852419584 |
| adam_text | |
| any_adam_object | |
| author | Schönig, Hans-Jürgen |
| author_facet | Schönig, Hans-Jürgen |
| author_role | aut |
| author_sort | Schönig, Hans-Jürgen |
| author_variant | h j s hjs |
| building | Verbundindex |
| bvnumber | localFWS |
| callnumber-first | Q - Science |
| callnumber-label | QA76 |
| callnumber-raw | QA76.9.D3 .S3 2014eb |
| callnumber-search | QA76.9.D3 .S3 2014eb |
| callnumber-sort | QA 276.9 D3 S3 42014EB |
| callnumber-subject | QA - Mathematics |
| collection | ZDB-4-EBA |
| contents | 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 |
| ctrlnum | (OCoLC)896837316 |
| dewey-full | 005.74 |
| dewey-hundreds | 000 - Computer science, information, general works |
| dewey-ones | 005 - Computer programming, programs, data, security |
| dewey-raw | 005.74 |
| dewey-search | 005.74 |
| dewey-sort | 15.74 |
| dewey-tens | 000 - Computer science, information, general works |
| discipline | Informatik |
| format | Electronic eBook |
| fullrecord | <?xml version="1.0" encoding="UTF-8"?><collection xmlns="http://www.loc.gov/MARC21/slim"><record><leader>06604cam a2200697 i 4500</leader><controlfield tag="001">ZDB-4-EBA-ocn896837316</controlfield><controlfield tag="003">OCoLC</controlfield><controlfield tag="005">20241004212047.0</controlfield><controlfield tag="006">m o d </controlfield><controlfield tag="007">cr cn|||||||||</controlfield><controlfield tag="008">141024t20142014enk o 001 0 eng d</controlfield><datafield tag="040" ind1=" " ind2=" "><subfield code="a">E7B</subfield><subfield code="b">eng</subfield><subfield code="e">rda</subfield><subfield code="e">pn</subfield><subfield code="c">E7B</subfield><subfield code="d">OCLCO</subfield><subfield code="d">OCLCQ</subfield><subfield code="d">YDXCP</subfield><subfield code="d">OCLCQ</subfield><subfield code="d">COCUF</subfield><subfield code="d">K6U</subfield><subfield code="d">CNNOR</subfield><subfield code="d">CCO</subfield><subfield code="d">PIFAG</subfield><subfield code="d">FVL</subfield><subfield code="d">N$T</subfield><subfield code="d">OCLCO</subfield><subfield code="d">N$T</subfield><subfield code="d">IDEBK</subfield><subfield code="d">EBLCP</subfield><subfield code="d">DEBSZ</subfield><subfield code="d">VT2</subfield><subfield code="d">COO</subfield><subfield code="d">REB</subfield><subfield code="d">FEM</subfield><subfield code="d">OCLCQ</subfield><subfield code="d">OCLCO</subfield><subfield code="d">ZCU</subfield><subfield code="d">OCLCF</subfield><subfield code="d">AGLDB</subfield><subfield code="d">MERUC</subfield><subfield code="d">OCLCQ</subfield><subfield code="d">OCLCO</subfield><subfield code="d">U3W</subfield><subfield code="d">D6H</subfield><subfield code="d">STF</subfield><subfield code="d">OCLCQ</subfield><subfield code="d">VTS</subfield><subfield code="d">ICG</subfield><subfield code="d">INT</subfield><subfield code="d">OCLCQ</subfield><subfield code="d">OCLCO</subfield><subfield code="d">G3B</subfield><subfield code="d">TKN</subfield><subfield code="d">OCLCQ</subfield><subfield code="d">OCLCO</subfield><subfield code="d">DKC</subfield><subfield code="d">OCLCQ</subfield><subfield code="d">HS0</subfield><subfield code="d">OCLCQ</subfield><subfield code="d">OCLCO</subfield><subfield code="d">OCLCQ</subfield><subfield code="d">OCLCO</subfield><subfield code="d">OCLCL</subfield><subfield code="d">UEJ</subfield><subfield code="d">OCLCQ</subfield></datafield><datafield tag="019" ind1=" " ind2=" "><subfield code="a">893652970</subfield><subfield code="a">907288861</subfield><subfield code="a">968042965</subfield><subfield code="a">969012226</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">9781783988990</subfield><subfield code="q">(e-book)</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">1783988991</subfield><subfield code="q">(e-book)</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">1322208565</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">9781322208565</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="z">9781783988983</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="z">1783988983</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(OCoLC)896837316</subfield><subfield code="z">(OCoLC)893652970</subfield><subfield code="z">(OCoLC)907288861</subfield><subfield code="z">(OCoLC)968042965</subfield><subfield code="z">(OCoLC)969012226</subfield></datafield><datafield tag="037" ind1=" " ind2=" "><subfield code="a">652136</subfield><subfield code="b">MIL</subfield></datafield><datafield tag="050" ind1=" " ind2="4"><subfield code="a">QA76.9.D3</subfield><subfield code="b">.S3 2014eb</subfield></datafield><datafield tag="072" ind1=" " ind2="7"><subfield code="a">COM</subfield><subfield code="x">051170</subfield><subfield code="2">bisacsh</subfield></datafield><datafield tag="072" ind1=" " ind2="7"><subfield code="a">COM</subfield><subfield code="x">021000</subfield><subfield code="2">bisacsh</subfield></datafield><datafield tag="082" ind1="7" ind2=" "><subfield code="a">005.74</subfield><subfield code="2">23</subfield></datafield><datafield tag="049" ind1=" " ind2=" "><subfield code="a">MAIN</subfield></datafield><datafield tag="100" ind1="1" ind2=" "><subfield code="a">Schönig, Hans-Jürgen,</subfield><subfield code="e">author.</subfield></datafield><datafield tag="245" ind1="1" ind2="0"><subfield code="a">PostgreSQL administration essentials :</subfield><subfield code="b">discover efficient ways to administer, monitor, replicate, and handle your PostgreSQL databases /</subfield><subfield code="c">Hans-Jürgen Schönig.</subfield></datafield><datafield tag="264" ind1=" " ind2="1"><subfield code="a">Birmingham, England :</subfield><subfield code="b">Packt Publishing,</subfield><subfield code="c">2014.</subfield></datafield><datafield tag="264" ind1=" " ind2="4"><subfield code="c">©2014</subfield></datafield><datafield tag="300" ind1=" " ind2=" "><subfield code="a">1 online resource (129 pages)</subfield></datafield><datafield tag="336" ind1=" " ind2=" "><subfield code="a">text</subfield><subfield code="b">txt</subfield><subfield code="2">rdacontent</subfield></datafield><datafield tag="337" ind1=" " ind2=" "><subfield code="a">computer</subfield><subfield code="b">c</subfield><subfield code="2">rdamedia</subfield></datafield><datafield tag="338" ind1=" " ind2=" "><subfield code="a">online resource</subfield><subfield code="b">cr</subfield><subfield code="2">rdacarrier</subfield></datafield><datafield tag="347" ind1=" " ind2=" "><subfield code="a">text file</subfield></datafield><datafield tag="490" ind1="1" ind2=" "><subfield code="a">Community Experience Distilled</subfield></datafield><datafield tag="588" ind1="0" ind2=" "><subfield code="a">Online resource; title from PDF title page (ebrary, viewed October 24, 2014).</subfield></datafield><datafield tag="500" ind1=" " ind2=" "><subfield code="a">Includes index.</subfield></datafield><datafield tag="520" ind1="8" ind2=" "><subfield code="a">Annotation</subfield><subfield code="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.</subfield></datafield><datafield tag="505" ind1="0" ind2=" "><subfield code="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</subfield></datafield><datafield tag="505" ind1="8" ind2=" "><subfield code="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</subfield></datafield><datafield tag="505" ind1="8" ind2=" "><subfield code="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</subfield></datafield><datafield tag="505" ind1="8" ind2=" "><subfield code="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</subfield></datafield><datafield tag="505" ind1="8" ind2=" "><subfield code="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</subfield></datafield><datafield tag="630" ind1="0" ind2="0"><subfield code="a">PostgreSQL.</subfield><subfield code="0">http://id.loc.gov/authorities/names/n00067354</subfield></datafield><datafield tag="630" ind1="0" ind2="7"><subfield code="a">PostgreSQL</subfield><subfield code="2">fast</subfield></datafield><datafield tag="650" ind1=" " ind2="0"><subfield code="a">Database management.</subfield><subfield code="0">http://id.loc.gov/authorities/subjects/sh85035848</subfield></datafield><datafield tag="650" ind1=" " ind2="6"><subfield code="a">Bases de données</subfield><subfield code="x">Gestion.</subfield></datafield><datafield tag="650" ind1=" " ind2="7"><subfield code="a">COMPUTERS</subfield><subfield code="x">Programming Languages</subfield><subfield code="x">SQL.</subfield><subfield code="2">bisacsh</subfield></datafield><datafield tag="650" ind1=" " ind2="7"><subfield code="a">COMPUTERS</subfield><subfield code="x">Databases</subfield><subfield code="x">General.</subfield><subfield code="2">bisacsh</subfield></datafield><datafield tag="650" ind1=" " ind2="7"><subfield code="a">Database management</subfield><subfield code="2">fast</subfield></datafield><datafield tag="758" ind1=" " ind2=" "><subfield code="i">has work:</subfield><subfield code="a">PostgreSQL administration essentials (Text)</subfield><subfield code="1">https://id.oclc.org/worldcat/entity/E39PD3WbTWXpDMHMyk8WgQF8Q3</subfield><subfield code="4">https://id.oclc.org/worldcat/ontology/hasWork</subfield></datafield><datafield tag="776" ind1="0" ind2="8"><subfield code="i">Print version:</subfield><subfield code="a">Schönig, Hans-Jürgen.</subfield><subfield code="t">PostgreSQL administration essentials : discover efficient ways to administer, monitor, replicate, and handle your PostgreSQL databases.</subfield><subfield code="d">Birmingham, England : Packt Publishing, ©2014</subfield><subfield code="h">iv, 125 pages</subfield><subfield code="k">Community experience distilled.</subfield><subfield code="z">9781783988983</subfield></datafield><datafield tag="830" ind1=" " ind2="0"><subfield code="a">Community experience distilled.</subfield><subfield code="0">http://id.loc.gov/authorities/names/no2011030603</subfield></datafield><datafield tag="856" ind1="4" ind2="0"><subfield code="l">FWS01</subfield><subfield code="p">ZDB-4-EBA</subfield><subfield code="q">FWS_PDA_EBA</subfield><subfield code="u">https://search.ebscohost.com/login.aspx?direct=true&scope=site&db=nlebk&AN=870056</subfield><subfield code="3">Volltext</subfield></datafield><datafield tag="938" ind1=" " ind2=" "><subfield code="a">EBL - Ebook Library</subfield><subfield code="b">EBLB</subfield><subfield code="n">EBL1818071</subfield></datafield><datafield tag="938" ind1=" " ind2=" "><subfield code="a">ebrary</subfield><subfield code="b">EBRY</subfield><subfield code="n">ebr10954710</subfield></datafield><datafield tag="938" ind1=" " ind2=" "><subfield code="a">EBSCOhost</subfield><subfield code="b">EBSC</subfield><subfield code="n">870056</subfield></datafield><datafield tag="938" ind1=" " ind2=" "><subfield code="a">ProQuest MyiLibrary Digital eBook Collection</subfield><subfield code="b">IDEB</subfield><subfield code="n">cis29914675</subfield></datafield><datafield tag="938" ind1=" " ind2=" "><subfield code="a">YBP Library Services</subfield><subfield code="b">YANK</subfield><subfield code="n">12124105</subfield></datafield><datafield tag="994" ind1=" " ind2=" "><subfield code="a">92</subfield><subfield code="b">GEBAY</subfield></datafield><datafield tag="912" ind1=" " ind2=" "><subfield code="a">ZDB-4-EBA</subfield></datafield><datafield tag="049" ind1=" " ind2=" "><subfield code="a">DE-863</subfield></datafield></record></collection> |
| id | ZDB-4-EBA-ocn896837316 |
| illustrated | Not Illustrated |
| indexdate | 2024-11-27T13:26:20Z |
| institution | BVB |
| isbn | 9781783988990 1783988991 1322208565 9781322208565 |
| language | English |
| oclc_num | 896837316 |
| open_access_boolean | |
| owner | MAIN DE-863 DE-BY-FWS |
| owner_facet | MAIN DE-863 DE-BY-FWS |
| physical | 1 online resource (129 pages) |
| psigel | ZDB-4-EBA |
| publishDate | 2014 |
| publishDateSearch | 2014 |
| publishDateSort | 2014 |
| publisher | Packt Publishing, |
| record_format | marc |
| series | Community experience distilled. |
| series2 | Community Experience Distilled |
| spelling | Schönig, Hans-Jürgen, author. PostgreSQL administration essentials : discover efficient ways to administer, monitor, replicate, and handle your PostgreSQL databases / Hans-Jürgen Schönig. Birmingham, England : Packt Publishing, 2014. ©2014 1 online resource (129 pages) text txt rdacontent computer c rdamedia online resource cr rdacarrier text file Community Experience Distilled Online resource; title from PDF title page (ebrary, viewed October 24, 2014). Includes index. Annotation 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. 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 PostgreSQL. http://id.loc.gov/authorities/names/n00067354 PostgreSQL fast Database management. http://id.loc.gov/authorities/subjects/sh85035848 Bases de données Gestion. COMPUTERS Programming Languages SQL. bisacsh COMPUTERS Databases General. bisacsh Database management fast has work: PostgreSQL administration essentials (Text) https://id.oclc.org/worldcat/entity/E39PD3WbTWXpDMHMyk8WgQF8Q3 https://id.oclc.org/worldcat/ontology/hasWork Print version: Schönig, Hans-Jürgen. PostgreSQL administration essentials : discover efficient ways to administer, monitor, replicate, and handle your PostgreSQL databases. Birmingham, England : Packt Publishing, ©2014 iv, 125 pages Community experience distilled. 9781783988983 Community experience distilled. http://id.loc.gov/authorities/names/no2011030603 FWS01 ZDB-4-EBA FWS_PDA_EBA https://search.ebscohost.com/login.aspx?direct=true&scope=site&db=nlebk&AN=870056 Volltext |
| spellingShingle | Schönig, Hans-Jürgen PostgreSQL administration essentials : discover efficient ways to administer, monitor, replicate, and handle your PostgreSQL databases / Community experience distilled. 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 PostgreSQL. http://id.loc.gov/authorities/names/n00067354 PostgreSQL fast Database management. http://id.loc.gov/authorities/subjects/sh85035848 Bases de données Gestion. COMPUTERS Programming Languages SQL. bisacsh COMPUTERS Databases General. bisacsh Database management fast |
| subject_GND | http://id.loc.gov/authorities/names/n00067354 http://id.loc.gov/authorities/subjects/sh85035848 |
| title | PostgreSQL administration essentials : discover efficient ways to administer, monitor, replicate, and handle your PostgreSQL databases / |
| title_auth | PostgreSQL administration essentials : discover efficient ways to administer, monitor, replicate, and handle your PostgreSQL databases / |
| title_exact_search | PostgreSQL administration essentials : discover efficient ways to administer, monitor, replicate, and handle your PostgreSQL databases / |
| title_full | PostgreSQL administration essentials : discover efficient ways to administer, monitor, replicate, and handle your PostgreSQL databases / Hans-Jürgen Schönig. |
| title_fullStr | PostgreSQL administration essentials : discover efficient ways to administer, monitor, replicate, and handle your PostgreSQL databases / Hans-Jürgen Schönig. |
| title_full_unstemmed | PostgreSQL administration essentials : discover efficient ways to administer, monitor, replicate, and handle your PostgreSQL databases / Hans-Jürgen Schönig. |
| title_short | PostgreSQL administration essentials : |
| title_sort | postgresql administration essentials discover efficient ways to administer monitor replicate and handle your postgresql databases |
| title_sub | discover efficient ways to administer, monitor, replicate, and handle your PostgreSQL databases / |
| topic | PostgreSQL. http://id.loc.gov/authorities/names/n00067354 PostgreSQL fast Database management. http://id.loc.gov/authorities/subjects/sh85035848 Bases de données Gestion. COMPUTERS Programming Languages SQL. bisacsh COMPUTERS Databases General. bisacsh Database management fast |
| topic_facet | PostgreSQL. PostgreSQL Database management. Bases de données Gestion. COMPUTERS Programming Languages SQL. COMPUTERS Databases General. Database management |
| url | https://search.ebscohost.com/login.aspx?direct=true&scope=site&db=nlebk&AN=870056 |
| work_keys_str_mv | AT schonighansjurgen postgresqladministrationessentialsdiscoverefficientwaystoadministermonitorreplicateandhandleyourpostgresqldatabases |