PostgreSQL Administration Essentials

 
9781783988983: PostgreSQL Administration Essentials
View all copies of this ISBN edition:
 
 

Discover efficient ways to administer, monitor, replicate, and handle your PostgreSQL databases

About This Book

  • Learn how to detect bottlenecks and make sure your database systems offer superior performance to your end users
  • Replicate your databases to achieve full redundancy and create backups quickly and easily
  • Optimize PostgreSQL configuration parameters and turn your database server into a high-performance machine capable of fulfilling your needs

Who This Book Is For

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.

What You Will Learn

  • Perform routine backups and restore your databases safely
  • Set up replication quickly and easily
  • Handle logfiles and extract information from PostgreSQL
  • Monitor PostgreSQL and integrate it into the existing infrastructure
  • Build desktop applications using C#
  • Optimize PostgreSQL for high speed and tune your database parameters
  • Adjust your user permissions and lock out intruders
  • Detect bottlenecks and find missing indexes with ease

In Detail

With more than a quarter of a century of development and innovation, PostgreSQL has gained a reputation for stability, robustness, and ease of use. The variety of features available within PostgreSQL makes it a powerful tool for your professional relational database infrastructure.

With the database administrator in mind, this compact, easy-to-read, and practically-oriented book will make your daily handling of PostgreSQL more efficient and rewarding. You will learn about optimization, bottleneck detection, backup and recovery, replication, logfile management, indexing, and much more in a systematic and carefully structured manner. This invaluable guide will enable you to develop the fundamental skills required to deploy PostgreSQL in order to efficiently manage your databases.

"synopsis" may belong to another edition of this title.

About the Author:

Hans-Jurgen Schonig

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 problems—especially on large-scale systems and analytical problems. When he is not visiting customers, he is based in Wiener Neustadt, Austria.

"About this title" may belong to another edition of this title.

Buy New View Book
List Price: US$ 27.99
US$ 27.67

Convert currency

Shipping: FREE
From United Kingdom to U.S.A.

Destination, rates & speeds

Add to Basket

Top Search Results from the AbeBooks Marketplace

1.

Hans-Jurgen Schonig
Published by Packt Publishing Limited, United Kingdom (2014)
ISBN 10: 1783988983 ISBN 13: 9781783988983
New Paperback Quantity Available: 10
Print on Demand
Seller:
The Book Depository
(London, United Kingdom)
Rating
[?]

Book Description Packt Publishing Limited, United Kingdom, 2014. Paperback. Condition: New. Language: English . Brand New Book ***** Print on Demand *****.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. Seller Inventory # AAV9781783988983

More information about this seller | Contact this seller

Buy New
US$ 27.67
Convert currency

Add to Basket

Shipping: FREE
From United Kingdom to U.S.A.
Destination, rates & speeds

2.

Hans-Jurgen Schonig
Published by Packt Publishing Limited, United Kingdom (2014)
ISBN 10: 1783988983 ISBN 13: 9781783988983
New Paperback Quantity Available: 10
Print on Demand
Seller:
Book Depository International
(London, United Kingdom)
Rating
[?]

Book Description Packt Publishing Limited, United Kingdom, 2014. Paperback. Condition: New. Language: English . Brand New Book ***** Print on Demand *****. 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. Seller Inventory # AAV9781783988983

More information about this seller | Contact this seller

Buy New
US$ 31.31
Convert currency

Add to Basket

Shipping: FREE
From United Kingdom to U.S.A.
Destination, rates & speeds

3.

Hans-Jurgen Schonig
Published by Packt Publishing Limited (2014)
ISBN 10: 1783988983 ISBN 13: 9781783988983
New Quantity Available: > 20
Print on Demand
Seller:
Pbshop
(Wood Dale, IL, U.S.A.)
Rating
[?]

Book Description Packt Publishing Limited, 2014. PAP. Condition: New. New Book. Shipped from US within 10 to 14 business days. THIS BOOK IS PRINTED ON DEMAND. Established seller since 2000. Seller Inventory # IQ-9781783988983

More information about this seller | Contact this seller

Buy New
US$ 27.33
Convert currency

Add to Basket

Shipping: US$ 3.99
Within U.S.A.
Destination, rates & speeds

4.

Hans-Jurgen Schonig
Published by Packt Publishing Limited (2014)
ISBN 10: 1783988983 ISBN 13: 9781783988983
New Quantity Available: > 20
Print on Demand
Seller:
Books2Anywhere
(Fairford, GLOS, United Kingdom)
Rating
[?]

Book Description Packt Publishing Limited, 2014. PAP. Condition: New. New Book. Delivered from our UK warehouse in 4 to 14 business days. THIS BOOK IS PRINTED ON DEMAND. Established seller since 2000. Seller Inventory # LQ-9781783988983

More information about this seller | Contact this seller

Buy New
US$ 23.69
Convert currency

Add to Basket

Shipping: US$ 11.76
From United Kingdom to U.S.A.
Destination, rates & speeds

5.

Schonig, Hans-Jurgen
Published by Packt Publishing 10/17/2014 (2014)
ISBN 10: 1783988983 ISBN 13: 9781783988983
New Paperback or Softback Quantity Available: 10
Seller:
BargainBookStores
(Grand Rapids, MI, U.S.A.)
Rating
[?]

Book Description Packt Publishing 10/17/2014, 2014. Paperback or Softback. Condition: New. PostgreSQL Administration Essentials. Book. Seller Inventory # BBS-9781783988983

More information about this seller | Contact this seller

Buy New
US$ 36.68
Convert currency

Add to Basket

Shipping: FREE
Within U.S.A.
Destination, rates & speeds

6.

Hans-Jurgen Schonig
ISBN 10: 1783988983 ISBN 13: 9781783988983
New Quantity Available: 5
Seller:
ReadWhiz
(Portland, OR, U.S.A.)
Rating
[?]

Book Description Condition: New. Seller Inventory # ria9781783988983_ing

More information about this seller | Contact this seller

Buy New
US$ 37.75
Convert currency

Add to Basket

Shipping: FREE
Within U.S.A.
Destination, rates & speeds

7.

Hans-Jürgen Schönig
Published by Packt Publishing (2014)
ISBN 10: 1783988983 ISBN 13: 9781783988983
New Softcover Quantity Available: 1
Print on Demand
Seller:
Rating
[?]

Book Description Packt Publishing, 2014. Condition: New. This item is printed on demand for shipment within 3 working days. Seller Inventory # GM9781783988983

More information about this seller | Contact this seller

Buy New
US$ 36.66
Convert currency

Add to Basket

Shipping: US$ 3.52
From Germany to U.S.A.
Destination, rates & speeds

8.

Hans-Jürgen Schà nig
Published by Packt Publishing - ebooks Account
ISBN 10: 1783988983 ISBN 13: 9781783988983
New Paperback Quantity Available: > 20
Seller:
BuySomeBooks
(Las Vegas, NV, U.S.A.)
Rating
[?]

Book Description Packt Publishing - ebooks Account. Paperback. Condition: New. With more than a quarter of a century of development and innovation, PostgreSQL has gained a reputation for stability, robustness, and ease of use. The variety of features available within PostgreSQL make it a powerful tool for your professional relational database infrastructure. Now is the time for you to benefit from the power of PostgreSQL. With you, the database administrator, in mind, this compact, easy to read, and most importantly practically-oriented book will make your daily work more efficient and rewarding. Learn optimization, bottleneck detection, backup and recovery, replication, log file management, indexing, and much more, in a systematic and well structured manner. This invaluable guide will enable you to develop the fundamental skills required to deploy PostgreSQL in order to efficiently manage your database. This item ships from multiple locations. Your book may arrive from Roseburg,OR, La Vergne,TN. Paperback. Seller Inventory # 9781783988983

More information about this seller | Contact this seller

Buy New
US$ 41.21
Convert currency

Add to Basket

Shipping: FREE
Within U.S.A.
Destination, rates & speeds

9.

Hans-Jurgen Schonig
Published by Packt Publishing - ebooks Account (2014)
ISBN 10: 1783988983 ISBN 13: 9781783988983
New Softcover Quantity Available: 1
Seller:
Irish Booksellers
(Portland, ME, U.S.A.)
Rating
[?]

Book Description Packt Publishing - ebooks Account, 2014. Condition: New. book. Seller Inventory # M1783988983

More information about this seller | Contact this seller

Buy New
US$ 44.64
Convert currency

Add to Basket

Shipping: US$ 3.27
Within U.S.A.
Destination, rates & speeds

10.

Schonig, Hans-Jurgen
Published by Packt Publishing - ebooks Account
ISBN 10: 1783988983 ISBN 13: 9781783988983
New PAPERBACK Quantity Available: > 20
Seller:
Russell Books
(Victoria, BC, Canada)
Rating
[?]

Book Description Packt Publishing - ebooks Account. PAPERBACK. Condition: New. 1783988983 Special order direct from the distributor. Seller Inventory # ING9781783988983

More information about this seller | Contact this seller

Buy New
US$ 41.99
Convert currency

Add to Basket

Shipping: US$ 7.00
From Canada to U.S.A.
Destination, rates & speeds