國立虎尾科技大學 |

PostgreSQL Configuration = Best Practices for Performance and Security /

紀錄類型:	書目-語言資料,印刷品 : Monograph/item
正題名/作者:	PostgreSQL Configuration/ by Baji Shaik.
其他題名:	Best Practices for Performance and Security /
作者:	Shaik, Baji.
面頁冊數:	XI, 226 p. 12 illus.online resource. :
Contained By:	Springer Nature eBook
標題:	Computer Applications. -
電子資源:	https://doi.org/10.1007/978-1-4842-5663-3
ISBN:	9781484256633

PostgreSQL Configuration = Best Practices for Performance and Security /
Shaik, Baji.

PostgreSQL ConfigurationBest Practices for Performance and Security /[electronic resource] :by Baji Shaik. - 1st ed. 2020. - XI, 226 p. 12 illus.online resource.

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.

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. You will: Configure PostgreSQL for performance Monitor and maintain PostgreSQL instances Implement a backup strategy for your data Resolve errors faced while using PostgreSQL.

ISBN: 9781484256633

Standard No.: 10.1007/978-1-4842-5663-3doiSubjects--Topical Terms:

669785
Computer Applications.

LC Class. No.: QA76.76.O62

Dewey Class. No.: 006.76

PostgreSQL Configuration = Best Practices for Performance and Security /
LDR:03183nam a22003975i 4500 001 1022772
003 DE-He213
005 20200630002911.0
007 cr nn 008mamaa
008 210318s2020 xxu| s |||| 0|eng d
020 $a 9781484256633 $9 978-1-4842-5663-3
024 7 $a 10.1007/978-1-4842-5663-3 $2 doi
035 $a 978-1-4842-5663-3
050 4 $a QA76.76.O62
050 4 $a QA76.6-76.66
072 7 $a UM $2 bicssc
072 7 $a COM051390 $2 bisacsh
072 7 $a UM $2 thema
082 0 4 $a 006.76 $2 23
100 1 $a Shaik, Baji. $4 aut $4 http://id.loc.gov/vocabulary/relators/aut $3 1203124
245 1 0 $a PostgreSQL Configuration $h [electronic resource] : $b Best Practices for Performance and Security / $c by Baji Shaik.
250 $a 1st ed. 2020.
264 1 $a Berkeley, CA : $b Apress : $b Imprint: Apress, $c 2020.
300 $a XI, 226 p. 12 illus. $b online resource.
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 $b PDF $2 rda
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.
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. You will: Configure PostgreSQL for performance Monitor and maintain PostgreSQL instances Implement a backup strategy for your data Resolve errors faced while using PostgreSQL.
650 2 4 $a Computer Applications. $3 669785
650 2 4 $a Database Management. $3 669820
650 1 4 $a Open Source. $3 1113081
650 0 $a Application software. $3 528147
650 0 $a Database management. $3 557799
650 0 $a Computer programming. $3 527822
650 0 $a Open source software. $3 561177
710 2 $a SpringerLink (Online service) $3 593884
773 0 $t Springer Nature eBook
776 0 8 $i Printed edition: $z 9781484256626
776 0 8 $i Printed edition: $z 9781484256640
856 4 0 $u https://doi.org/10.1007/978-1-4842-5663-3
912 $a ZDB-2-CWD
912 $a ZDB-2-SXPC
950 $a Professional and Applied Computing (SpringerNature-12059)
950 $a Professional and Applied Computing (R0) (SpringerNature-43716)