000930323 000__ 03832cam\a2200529Ma\4500 000930323 001__ 930323 000930323 005__ 20230306151449.0 000930323 006__ m\\\\\o\\d\\\\\\\\ 000930323 007__ cr\cn\nnnunnun 000930323 008__ 180320s2020\\\\xx\\\\\\o\\\\\000\0\eng\d 000930323 019__ $$a1145600968$$a1145899361 000930323 020__ $$a1484256638 000930323 020__ $$a9781484256633 000930323 020__ $$z9781484256633 000930323 020__ $$z148425662X 000930323 020__ $$z9781484256626 000930323 0248_ $$a9781484256626 000930323 0248_ $$a9781484256633 000930323 035__ $$aSP(OCoLC)on1147974997 000930323 035__ $$aSP(OCoLC)1147974997$$z(OCoLC)1145600968$$z(OCoLC)1145899361 000930323 040__ $$aAU@$$beng$$epn$$cAU@$$dEBLCP$$dGW5XE$$dYDX$$dOCLCQ 000930323 049__ $$aISEA 000930323 050_4 $$aQA76.9.D3 000930323 08204 $$a005.74$$223 000930323 1001_ $$aShaik, Baji,$$eauthor. 000930323 24510 $$aPostgreSQL Configuration :$$bBest Practices for Performance and Security /$$cShaik, Baji. 000930323 250__ $$a1st edition. 000930323 264_1 $$bApress,$$c2020. 000930323 300__ $$a1 online resource (234 pages) 000930323 336__ $$atext$$btxt$$2rdacontent 000930323 337__ $$acomputer$$bc$$2rdamedia 000930323 338__ $$aonline resource$$bcr$$2rdacarrier 000930323 347__ $$atext file 000930323 5050_ $$aChapter 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. 000930323 506__ $$aAccess limited to authorized users. 000930323 520__ $$aObtain 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. 000930323 542__ $$fCopyright © Apress$$g2020 000930323 550__ $$aMade available through: Safari, an O'Reilly Media Company. 000930323 588__ $$aOnline resource; Title from title page (viewed March 16, 2020) 000930323 63000 $$aPostgreSQL. 000930323 650_0 $$aDatabase management. 000930323 7102_ $$aSafari, an O'Reilly Media Company. 000930323 77608 $$iPrint version:$$aShaik, Baji.$$tPostgreSQL Configuration : Best Practices for Performance and Security.$$dBerkeley, CA : Apress L.P., ©2020$$z9781484256626 000930323 852__ $$bebk 000930323 85640 $$3SpringerLink$$uhttps://univsouthin.idm.oclc.org/login?url=http://link.springer.com/10.1007/978-1-4842-5663-3$$zOnline Access$$91397441.1 000930323 909CO $$ooai:library.usi.edu:930323$$pGLOBAL_SET 000930323 980__ $$aEBOOK 000930323 980__ $$aBIB 000930323 982__ $$aEbook 000930323 983__ $$aOnline 000930323 994__ $$a92$$bISE