Cargando…

PostgreSQL Configuration : Best Practices for Performance and Security /

Obtain all the skills you need to configure and manage a PostgreSQL database. In this book you will begin by installing and configuring PostgreSQL on a server by focusing on system-level parameter settings before installation. You will also look at key post-installation steps to avoid issues in the...

Descripción completa

Detalles Bibliográficos
Clasificación:Libro Electrónico
Autor principal: Shaik, Baji (Autor)
Autor Corporativo: Safari, an O'Reilly Media Company
Formato: Electrónico eBook
Idioma:Inglés
Publicado: [New York, NY] : Apress, 2020.
Edición:1st edition.
Temas:
Acceso en línea:Texto completo (Requiere registro previo con correo institucional)

MARC

LEADER 00000cam a2200000 i 4500
001 OR_on1147974997
003 OCoLC
005 20231017213018.0
006 m o d
007 cr cnu||||||||
008 180320s2020 nyu o 000 0 eng
040 |a AU@  |b eng  |e pn  |c AU@  |d EBLCP  |d GW5XE  |d YDX  |d OCLCQ  |d LQU  |d YDXIT  |d OCLCQ  |d OCLCF  |d N$T  |d UKAHL  |d COO  |d OCLCQ  |d OCLCO  |d NLW  |d OCLCO  |d OCLCQ 
019 |a 1145600968  |a 1145899361  |a 1151712300  |a 1152537826  |a 1153158991  |a 1153951037  |a 1154466776 
020 |a 1484256638  |q (electronic book) 
020 |a 9781484256633  |q (electronic bk.) 
020 |z 9781484256626 
024 8 |a 9781484256626 
024 8 |a 9781484256633 
024 8 |a 10.1007/978-1-4842-5 
029 0 |a AU@  |b 000066971933 
035 |a (OCoLC)1147974997  |z (OCoLC)1145600968  |z (OCoLC)1145899361  |z (OCoLC)1151712300  |z (OCoLC)1152537826  |z (OCoLC)1153158991  |z (OCoLC)1153951037  |z (OCoLC)1154466776 
050 4 |a QA76.9.D3  |b S53 2020 
082 0 4 |a 005.74  |2 23 
049 |a UAMI 
100 1 |a Shaik, Baji,  |e author. 
245 1 0 |a PostgreSQL Configuration :  |b Best Practices for Performance and Security /  |c Shaik, Baji. 
250 |a 1st edition. 
264 1 |a [New York, NY] :  |b Apress,  |c 2020. 
300 |a 1 online resource (234 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 
520 |a Obtain all the skills you need to configure and manage a PostgreSQL database. In this book you will begin by installing and configuring PostgreSQL on a server by focusing on system-level parameter settings before installation. You will also look at key post-installation steps to avoid issues in the future. The basic configuration of PostgreSQL is tuned for compatibility rather than performance. Keeping this in mind, you will fine-tune your PostgreSQL parameters based on your environment and application behavior. You will then get tips to improve database monitoring and maintenance followed by database security for handling sensitive data in PostgreSQL. Every system containing valuable data needs to be backed-up regularly. PostgreSQL follows a simple back-up procedure and provides fundamental approaches to back up your data. You will go through these approaches and choose the right one based on your environment. Running your application with limited resources can be tricky. To achieve this you will implement a pooling mechanism for your PostgreSQL instances to connect to other databases. Finally, you will take a look at some basic errors faced while working with PostgreSQL and learn to resolve them in the quickest manner. What You Will Learn Configure PostgreSQL for performance Monitor and maintain PostgreSQL instances Implement a backup strategy for your data Resolve errors faced while using PostgreSQL Who This Book Is For Readers with basic knowledge of PostgreSQL who wish to implement key solutions based on their environment. 
542 |f Copyright © Apress  |g 2020 
550 |a Made available through: Safari, an O'Reilly Media Company. 
588 |a Online resource; Title from title page (viewed March 16, 2020) 
505 0 |a Chapter 01. Installing PostgreSQL the Right Way! -- Chapter 02. Configuring your Database for Performance -- Chapter 03. User management and Securing databases -- Chapter 04. Backup/Restore best practices -- Chapter 05. Enable logging of your database and Monitoring PostgreSQL instances -- Chapter 06. Execute Maintenance -- Chapter 07. High Availability procedures and Implementing Pooler -- Chapter 08. Basic Errors and Handy Queries. 
590 |a O'Reilly  |b O'Reilly Online Learning: Academic/Public Library Edition 
630 0 0 |a PostgreSQL. 
630 0 7 |a PostgreSQL.  |2 fast  |0 (OCoLC)fst01394262 
650 0 |a Database management. 
650 6 |a Bases de données  |x Gestion. 
650 7 |a Databases.  |2 bicssc 
650 7 |a Information technology: general issues.  |2 bicssc 
650 7 |a Computer programming / software development.  |2 bicssc 
650 7 |a Computers  |x Database Management  |x General.  |2 bisacsh 
650 7 |a Computers  |x Data Processing.  |2 bisacsh 
650 7 |a Computers  |x Programming  |x Open Source.  |2 bisacsh 
650 7 |a Database management.  |2 fast  |0 (OCoLC)fst00888037 
710 2 |a Safari, an O'Reilly Media Company. 
776 0 8 |i Print version:  |a Shaik, Baji.  |t PostgreSQL Configuration : Best Practices for Performance and Security.  |d Berkeley, CA : Apress L.P., ©2020  |z 9781484256626 
856 4 0 |u https://learning.oreilly.com/library/view/~/9781484256633/?ar  |z Texto completo (Requiere registro previo con correo institucional) 
938 |a Askews and Holts Library Services  |b ASKH  |n AH37404337 
938 |a ProQuest Ebook Central  |b EBLB  |n EBL6138207 
938 |a EBSCOhost  |b EBSC  |n 2396997 
938 |a YBP Library Services  |b YANK  |n 16702322 
994 |a 92  |b IZTAP