Wentworth
Institute of Technology
PostgreSQL Administration Cookbook, 9.5/9.6 Edition /
Over 150 recipes to help you administer your PostgreSQL database more efficiently About This Book Get to grips with the capabilities of PostgreSQL 9.6 to administer your database more efficiently Monitor, tune, secure and protect your database A step-by-step, recipe-based guide to help you tackle an...
Saved in:
| Main Authors: | , , |
|---|---|
| Format: | Electronic eBook |
| Language: | English |
| Published: |
Birmingham :
Packt Publishing,
2017.
|
| Subjects: | |
| Online Access: |
Full text (Wentworth users only) |
| Local Note: | ProQuest Ebook Central |
MARC
| LEADER | 00000cam a2200000ui 4500 | ||
|---|---|---|---|
| 001 | in00000197236 | ||
| 006 | m o d | ||
| 007 | cr ||||||||||| | ||
| 008 | 170526s2017 enk o 000 0 eng d | ||
| 005 | 20240805164443.3 | ||
| 016 | 7 | |a 018354663 |2 Uk | |
| 020 | |a 178588980X | ||
| 020 | |a 9781785889806 |q (electronic bk.) | ||
| 029 | 1 | |a AU@ |b 000060975343 | |
| 029 | 1 | |a CHNEW |b 000965910 | |
| 029 | 1 | |a CHVBK |b 495237647 | |
| 029 | 1 | |a UKMGB |b 018354663 | |
| 035 | |a (OCoLC)989062583 | ||
| 035 | |a (OCoLC)ocn989062583 | ||
| 037 | |a 9781785889806 |b Packt Publishing Pvt. Ltd | ||
| 040 | |a NLE |b eng |e rda |e pn |c NLE |d EBLCP |d MERUC |d IDB |d CHVBK |d OCLCQ |d OCLCO |d OCLCF |d OCLCQ |d UKMGB |d OCLCQ |d LVT |d CNCEN |d NLW |d OCLCQ |d N$T |d OCLCQ |d UKAHL |d OCLCQ |d OCLCO | ||
| 050 | 4 | |a QA76.9.D3 |b .R544 2017eb | |
| 082 | 0 | 4 | |a 005.74 |2 23 |
| 100 | 1 | |a Riggs, Simon, |e author. | |
| 245 | 1 | 0 | |a PostgreSQL Administration Cookbook, 9.5/9.6 Edition / |c Simon Riggs, Gianni Ciolli, Gabriele Bartolini. |
| 264 | 1 | |a Birmingham : |b Packt Publishing, |c 2017. | |
| 300 | |a 1 online resource (556 pages) | ||
| 336 | |a text |b txt |2 rdacontent | ||
| 337 | |a computer |b c |2 rdamedia | ||
| 338 | |a online resource |b cr |2 rdacarrier | ||
| 505 | 0 | |a Cover -- Copyright -- Credits -- About the Authors -- About the Reviewer -- www.PacktPub.com -- Customer Feedback -- Table of Contents -- Preface -- Chapter 1: First Steps -- Introduction -- Introducing PostgreSQL 9.6 -- What makes PostgreSQL different? -- Robustness -- Security -- Ease of use -- Extensibility -- Performance and concurrency -- Scalability -- SQL and NoSQL -- Popularity -- Commercial support -- Research and development funding -- Getting PostgreSQL -- How to do it ... -- How it works ... -- There's more ... -- Connecting to the PostgreSQL server -- Getting ready -- How to do it ... -- How it works ... -- There's more ... -- See also -- Enabling access for network/remote users -- How to do it ... -- How it works ... -- There's more ... -- See also -- Using graphical administration tools -- How to do it ... -- How it works ... -- See also -- Using the psql query and scripting tool -- Getting ready -- How to do it ... -- How it works ... -- There's more ... -- See also -- Changing your password securely -- How to do it ... -- How it works ... -- Avoiding hardcoding your password -- Getting ready -- How to do it ... -- How it works ... -- There's more ... -- Using a connection service file -- How to do it ... -- How it works ... -- Troubleshooting a failed connection -- How to do it ... -- There's more ... -- Chapter 2: Exploring the Database -- Introduction -- What version is the server? -- How to do it ... -- How it works ... -- There's more ... -- What is the server uptime? -- How to do it ... -- How it works ... -- See also -- Locating the database server files -- Getting ready -- How to do it ... -- How it works ... -- There's more ... -- Locating the database server's message log -- Getting ready -- How to do it ... -- How it works ... -- There's more ... -- Locating the database's system identifier -- Getting ready -- How to do it ... -- How it works ... | |
| 505 | 8 | |a Listing databases on this database server -- How to do it ... -- How it works ... -- There's more ... -- How many tables are there in a database? -- How to do it ... -- How it works ... -- There's more ... -- How much disk space does a database use? -- How to do it ... -- How it works ... -- How much disk space does a table use? -- How to do it ... -- How it works ... -- There's more ... -- Which are my biggest tables? -- How to do it ... -- How it works ... -- How many rows are there in a table? -- How to do it ... -- How it works ... -- Quickly estimating the number of rows in a table -- How to do it ... -- How it works ... -- There's more ... -- Function 1 -- estimating the number of rows -- Function 2 -- computing the size of a table without locks -- Listing extensions in this database -- Getting ready -- How to do it ... -- How it works ... -- There's more ... -- Understanding object dependencies -- Getting ready -- How to do it ... -- How it works ... -- There's more ... -- Chapter 3: Configuration -- Introduction -- Reading the fine manual -- How to do it ... -- How it works ... -- There's more ... -- Planning a new database -- Getting ready -- How to do it ... -- How it works ... -- There's more ... -- Changing parameters in your programs -- How to do it ... -- How it works ... -- There's more ... -- Finding the current configuration settings -- How to do it ... -- There's more ... -- How it works ... -- Which parameters are at non-default settings? -- How to do it ... -- How it works ... -- There's more ... -- Updating the parameter file -- Getting ready -- How to do it ... -- How it works ... -- There's more ... -- Setting parameters for particular groups of users -- How to do it ... -- How it works ... -- The basic server configuration checklist -- Getting ready -- How to do it ... -- There's more ... -- Adding an external module to PostgreSQL -- Getting ready -- How to do it ... | |
| 505 | 8 | |a [Installing modules using a software installer] -- Installing modules using a software installer -- Installing modules from PGXN -- Installing modules from a manually downloaded package -- Installing modules from source code -- How it works ... -- Using an installed module -- Getting ready -- How to do it ... -- How it works ... -- Managing installed extensions -- [How to do it ...] -- How to do it ... -- How it works ... -- There's more ... -- Chapter 4: Server Control -- Introduction -- Starting the database server manually -- Getting ready -- How to do it ... -- How it works ... -- Stopping the server safely and quickly -- How to do it ... -- How it works ... -- See also -- Stopping the server in an emergency -- How to do it ... -- How it works ... -- Reloading the server configuration files -- How to do it ... -- How it works ... -- There's more ... -- Restarting the server quickly -- How to do it ... -- There's more ... -- Preventing new connections -- How to do it ... -- How it works ... -- Restricting users to only one session each -- How to do it ... -- How it works ... -- Pushing users off the system -- How to do it ... -- How it works ... -- Deciding on a design for multitenancy -- How to do it ... -- How it works ... -- Using multiple schemas -- Getting ready -- How to do it ... -- How it works ... -- Giving users their own private database -- Getting ready -- How to do it ... -- How it works ... -- There's more ... -- See also -- Running multiple servers on one system -- Getting ready -- How to do it ... -- How it works ... -- Setting up a connection pool -- Getting ready -- How to do it ... -- How it works ... -- There's more ... -- Accessing multiple servers using the same host and port -- Getting ready -- How to do it ... -- There's more ... -- Chapter 5: Tables and Data -- Introduction -- Choosing good names for database objects -- Getting ready -- How to do it ... | |
| 505 | 8 | |a There's more ... -- Handling objects with quoted names -- Getting ready -- How to do it ... -- How it works ... -- There's more ... -- Enforcing the same name and definition for columns -- Getting ready -- How to do it ... -- How it works ... -- There's more ... -- Identifying and removing duplicates -- Getting ready -- How to do it ... -- How it works ... -- There's more ... -- Preventing duplicate rows -- Getting ready -- How to do it ... -- How it works ... -- There's more ... -- Duplicate indexes -- Uniqueness without indexes -- Real-world example -- IP address range allocation -- Real-world example -- range of time -- Real-world example -- prefix ranges -- Finding a unique key for a set of data -- Getting ready -- How to do it ... -- How it works ... -- Generating test data -- How to do it ... -- How it works ... -- There's more ... -- See also -- Randomly sampling data -- How to do it ... -- How it works ... -- Loading data from a spreadsheet -- Getting ready -- How to do it ... -- How it works ... -- There's more ... -- Loading data from flat files -- Getting ready -- How to do it ... -- How it works ... -- There's more ... -- Chapter 6: Security -- Introduction -- Typical user role -- The PostgreSQL superuser -- How to do it ... -- How it works ... -- There's more ... -- Other superuser-like attributes -- Attributes are never inherited -- See also -- Revoking user access to a table -- Getting ready -- How to do it ... -- How it works ... -- There's more ... -- Database creation scripts -- Default search path -- Securing views -- Granting user access to a table -- Getting ready -- How to do it ... -- How it works ... -- There's more ... -- Access to the schema -- Granting access to a table through a group role -- Granting access to all objects in a schema -- Granting user access to specific columns -- Getting ready -- How to do it ... -- How it works ... -- There's more ... | |
| 505 | 8 | |a Granting user access to specific rows -- Getting ready -- How to do it ... -- How it works ... -- There's more ... -- Creating a new user -- Getting ready -- How to do it ... -- How it works ... -- There's more ... -- Temporarily preventing a user from connecting -- Getting ready -- How to do it ... -- How it works ... -- There's more ... -- Limiting the number of concurrent connections by a user -- Forcing NOLOGIN users to disconnect -- Removing a user without dropping their data -- Getting ready -- How to do it ... -- How it works ... -- Checking whether all users have a secure password -- How to do it ... -- How it works ... -- Giving limited superuser powers to specific users -- Getting ready -- How to do it ... -- How it works ... -- There's more ... -- Writing a debugging_info function for developers -- Auditing DDL changes -- Getting ready -- How to do it ... -- How it works ... -- There's more ... -- Was the change committed? -- Who made the change? -- Can I find this information from the database? -- You may still miss some DDL ... -- Auditing data changes -- Getting ready -- How to do it ... -- Collecting data changes from the server log -- Collecting changes using triggers -- Collecting changes using triggers and saving them in another database -- Always knowing which user is logged in -- Getting ready -- How to do it ... -- How it works ... -- There's more ... -- Not inheriting user attributes -- Integrating with LDAP -- Getting ready -- How to do it ... -- How it works ... -- There's more ... -- Setting up the client to use LDAP -- Replacement for the User Name Map feature -- See also -- Connecting using SSL -- Getting ready -- How to do it ... -- How it works ... -- There's more ... -- Getting the SSL key and certificate -- Setting up a client to use SSL -- Checking server authenticity -- Using SSL certificates to authenticate -- Getting ready -- How to do it ... | |
| 520 | |a Over 150 recipes to help you administer your PostgreSQL database more efficiently About This Book Get to grips with the capabilities of PostgreSQL 9.6 to administer your database more efficiently Monitor, tune, secure and protect your database A step-by-step, recipe-based guide to help you tackle any problem in PostgreSQL administration with ease Who This Book Is For This book is for system administrators, database administrators, data architects, developers, and anyone with an interest in planning for, or running, live production databases. This book is most suited to those who have some technical experience. What You Will Learn Implement PostgreSQL features for performance and reliability Harness the power of the latest PostgreSQL 9.6 features Manage open source PostgreSQL versions 9.5 and 9.6 on various platforms Discover advanced technical tips for experienced users Explore best practices for planning and designing live databases Select and implement robust backup and recovery techniques Explore concise and clear guidance on replication and high availability See the latest details on Logical Replication and Bi-Directional Replication In Detail PostgreSQL is a powerful opensource database management system; now recognized as the expert's choice for a wide range of applications, it has an enviable reputation for performance and stability. PostgreSQL provides an integrated feature set comprising relational database features, object-relational, text search, Geographical Info Systems, analytical tools for big data and JSON/XML document management. Starting with short and simple recipes, you will soon dive into core features, such as configuration, server control, tables, and data. You will tackle a variety of problems a database administrator usually encounters, from creating tables to managing views, from improving performance to securing your database, and from using monitoring tools to using storage engines. Recipes based on important topics such as high availability, concurrency, replication, backup and recovery, as well as diagnostics and troubleshooting are also given special importance. By the end of this book, you will have all the knowledge you need to run, manage, and maintain PostgreSQL efficiently. Style and approach This book takes a step-by-step, recipe-based approach, where each recipe focuses on a particular challenge faced by a PostgreSQL administrator while administering his/her database. Explained in a very easy to follow man ... | ||
| 590 | |a ProQuest Ebook Central |b Ebook Central College Complete | ||
| 630 | 0 | 0 | |a PostgreSQL. |
| 650 | 0 | |a SQL. | |
| 650 | 0 | |a Query languages. | |
| 700 | 1 | |a Ciolli, Gianni, |e author. | |
| 700 | 1 | |a Bartolini, Gabriele, |e author. | |
| 852 | |b Ebooks |h ProQuest | ||
| 856 | 4 | 0 | |u https://ebookcentral.proquest.com/lib/wit/detail.action?docID=4852302 |z Full text (Wentworth users only) |t 0 |
| 884 | |a LDL ebooks ONIX to marcxml transformation using Record_Load-eBooks_Legal_Deposit_onix2marc_v2-0.xsl |g 20170526 |k 9781785889806 |q Uk. | ||
| 947 | |a FLO |x pq-ebc-base | ||
| 999 | f | f | |s 927bf9a0-bda6-494b-810c-24fd7250c07b |i 2a684d03-8e97-41f6-9b02-88830fd9fc8f |t 0 |
| 952 | f | f | |a Wentworth Institute of Technology |b Main Campus |c Wentworth Library |d Ebooks |t 0 |e ProQuest |h Other scheme |
| 856 | 4 | 0 | |t 0 |u https://ebookcentral.proquest.com/lib/wit/detail.action?docID=4852302 |y Full text (Wentworth users only) |