Update cookies preferences

PostgreSQL Administration Essentials [Paperback / softback]

4.22/5 (9 ratings by Goodreads)
  • Format: Paperback / softback, 142 pages, height x width: 93x75 mm
  • Pub. Date: 10-Oct-2014
  • Publisher: Packt Publishing Limited
  • ISBN-10: 1783988983
  • ISBN-13: 9781783988983
Other books in subject:
  • Paperback / softback
  • Price: 40,59 €
  • This book is not in stock. Book will arrive in about 2-4 weeks. Please allow another 2 weeks for shipping outside Estonia.
  • Quantity:
  • Add to basket
  • Delivery time 4-6 weeks
  • Add to Wishlist
PostgreSQL Administration EssentialsLarger Image
  • Format: Paperback / softback, 142 pages, height x width: 93x75 mm
  • Pub. Date: 10-Oct-2014
  • Publisher: Packt Publishing Limited
  • ISBN-10: 1783988983
  • ISBN-13: 9781783988983
Other books in subject:
Permanent link: https://www.kriso.ee/db/9781783988983.html
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.
Preface 1(4)
Chapter 1 Installing PostgreSQL
5(12)
Preparing your setup
5(8)
Understanding the PostgreSQL version numbers
6(1)
Choosing the right version
6(1)
Installing binary packages
6(1)
Installing PostgreSQL on Debian or Ubuntu
7(1)
Installing PostgreSQL on Red-Hat-based systems
8(1)
Compiling PostgreSQL from source
8(1)
How it works
9(1)
Installing the contrib packages
10(1)
Finalizing your installation
11(1)
Creating a database instance
11(1)
Firing up PostgreSQL
12(1)
Understanding the existing databases
13(1)
Creating databases
14(1)
Summary
15(2)
Chapter 2 Indexing and Performance Tuning
17(26)
Using simple binary trees
17(1)
Preparing the data
18(11)
Understanding the concept of execution plans
19(1)
Calculating costs
20(1)
Drawing important conclusions
21(1)
Creating indexes
22(1)
Analyzing the performance of a query
23(1)
The internal structure of a B-tree index
24(1)
Understanding the B-tree internals
25(1)
Providing a sorted order
25(1)
Combined indexes
26(2)
Partial indexes
28(1)
Dealing with different types of indexes
29(1)
Detecting missing indexes
29(3)
Detecting slow queries
32(3)
How to reset statistics
34(1)
Adjusting memory parameters
35(6)
Optimizing shared buffers
35(1)
Considering huge pages
36(1)
Tweaking work_mem
37(4)
Improving maintenance_work_mem
41(1)
Adjusting effective_cache_size
41(1)
Summary
41(2)
Chapter 3 Users and Permissions
43(22)
Understanding PostgreSQL security
43(20)
Configuring the TCP
44(1)
Managing network authentication
45(1)
Managing contradictions
46(1)
Authentication methods available
47(1)
Some more examples
48(1)
Handling SSL
49(1)
Changing pg_hba.conf
50(1)
Handling instance-level permissions
51(1)
Creating roles
51(3)
Modifying and dropping roles
54(2)
Controlling database-level permissions
56(1)
Understanding schema-level permissions
57(2)
Handling table-level permissions
59(2)
Managing column rights
61(1)
Improving security with SELinux
61(2)
Summary
63(2)
Chapter 4 Managing Logfiles
65(10)
Understanding the PostgreSQL log architecture
65(4)
Configuring log destinations
66(1)
Creating local logfiles
66(1)
Using syslog
67(1)
Configuring logs on Windows
68(1)
Performance considerations
68(1)
Configuring the amount of log output
69(3)
Making logs more readable
70(1)
Additional settings
71(1)
Making log creation more fine grained
72(2)
Logging selectively
72(1)
Focusing on slow queries
73(1)
Silencing notices
73(1)
Summary
74(1)
Chapter 5 Backup and Recovery
75(10)
Importing and exporting data
75(4)
Using the COPY command
75(1)
Basic operations of the COPY command
76(2)
Making use of pipes
78(1)
Performing backups
79(5)
Handling pg_dump
79(1)
More sophisticated dumping
79(1)
Performing partial replays
80(1)
Passing users and passwords
81(1)
Dumping an entire instance
82(1)
Understanding backups and user creation
83(1)
Summary
84(1)
Chapter 6 Handling Replication and Improving Performance
85(24)
Understanding the PostgreSQL transaction log
85(3)
The purpose of the transaction log
86(1)
Inspecting the size of the transaction log
87(1)
Configuring the checkpoints
88(4)
Optimizing the checkpoints
89(1)
Configuring the distance between checkpoints
89(1)
Controlling writes
90(2)
Setting up an asynchronous replication
92(6)
Obtaining a high-level overview
92(1)
Setting up replication step by step
93(1)
Preparing the slave
93(1)
Configuring the master
93(1)
Fetching an initial backup
94(2)
Creating and modifying the recovery.conf file
96(1)
Firing up the slave
96(1)
Turning slaves into masters
97(1)
Upgrading to synchronous replication
98(1)
Improving and monitoring the replication
99(4)
Keeping an eye on streaming
99(1)
Making things more robust
100(1)
Managing conflicts
101(2)
Handling point-in-time recovery
103(3)
Setting up PITR
103(2)
Replaying transaction logs
105(1)
Understanding timelines
106(2)
The importance of timelines
108(1)
Summary
108(1)
Chapter 7 Monitoring PostgreSQL
109(12)
Understanding the system statistics of PostgreSQL
109(8)
Checking out the pg_stat_activity file
110(1)
Monitoring databases
111(2)
Monitoring tables
113(1)
Monitoring indexes
114(1)
Checking out the information in the background writer
115(1)
Resetting statistics
116(1)
Integrating Nagios
117(1)
Handling Linux cgroups
118(2)
Setting up cgroups
118(2)
Summary
120(1)
Index 121
Hans-Jurgen Schonig and his company Cybertec Schonig & Schonig GmbH (www.postgresql-support.de) have been in professional PostgreSQL service, support, and consulting for over 15 years. He has written several books on PostgreSQL and has serviced customers around the globe. In his daily work, he focuses on performance optimization, PostgreSQL support, and training, as well as, on scalable solutions based on PostgreSQL. He likes working on complex PostgreSQL problemsespecially on large-scale systems and analytical problems. When he is not visiting customers, he is based in Wiener Neustadt, Austria.