南開科技大學圖書館 |

Language: 繁體中文

說明(常見問題)

南開科技大學

圖書館首頁

編目中圖書申請

登入

回首頁

切換: 標籤 | MARC模式 | ISBD

PostgreSQL configuration :best pract...

Shaik, Baji.

PostgreSQL configuration :best practices for performance and security /

紀錄類型:	書目-語言資料,印刷品 : 單行本
正題名/作者:	PostgreSQL configuration :/ Baji Shaik.
其他題名:	best practices for performance and security /
作者:	Shaik, Baji.
出版者:	[Berkeley, Calif.] :Apress,c2020.
面頁冊數:	xviii, 226 p. :ill. ;23 cm.
附註:	Includes index.
標題:	Database management. -
ISBN:	9781484256626 (pbk.) :

PostgreSQL configuration :best practices for performance and security /
Shaik, Baji.

PostgreSQL configuration :best practices for performance and security /Baji Shaik. - [Berkeley, Calif.] :Apress,c2020. - xviii, 226 p. :ill. ;23 cm.

Includes index.

Best ways to install PostgreSQL -- Configure your database for better performance -- User management and securing databases -- Backup and restore best practices -- Enable logging of your database and monitoring PostgreSQL instances -- Execute maintenance -- High availability procedures and implementing a pooler -- 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. 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.

ISBN: 9781484256626 (pbk.) :NT894Subjects--Uniform Titles:

PostgreSQL.
Subjects--Topical Terms:

146657
Database management.

Dewey Class. No.: 005.74

PostgreSQL configuration :best practices for performance and security /
LDR:02408cam a2200205 a 4500 001 1000117204
003 OCoLC
005 20201026043704.0
008 191227s2020 caua 001 0 eng d
020 $a 9781484256626 (pbk.) : $c NT894
020 $z 9781484256633 (ebook)
035 $a (OCoLC)1133128146
035 $a on1133128146
040 $a YDX $b eng $c YDX $d BDX $d SINLB $d OCLCF $d OCLCQ $d JRZ $d XCA
082 0 4 $a 005.74 $2 23
100 1 $a Shaik, Baji. $3 1000141442
245 1 0 $a PostgreSQL configuration : $b best practices for performance and security / $c Baji Shaik.
260 # $a [Berkeley, Calif.] : $b Apress, $c c2020.
300 $a xviii, 226 p. : $b ill. ; $c 23 cm.
500 $a Includes index.
505 0 # $a Best ways to install PostgreSQL -- Configure your database for better performance -- User management and securing databases -- Backup and restore best practices -- Enable logging of your database and monitoring PostgreSQL instances -- Execute maintenance -- High availability procedures and implementing a pooler -- 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. 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.
630 0 0 $a PostgreSQL. $3 1000066089
650 # 0 $a Database management. $3 146657