PostgreSQL 14 administration cookbook over 175 proven recipes for database administrators to manage enterprise databases effectively
Administer, monitor, and replicate your PostgreSQL 14 database for efficient database management and maintenance Key Features Troubleshoot and tackle any administration and management problems in PostgreSQL 14 Find expert techniques for monitoring, fine-tuning, and securing your database Adopt effic...
| Otros Autores: | , |
|---|---|
| Formato: | Libro electrónico |
| Idioma: | Inglés |
| Publicado: |
Birmingham :
Packt Publishing, Limited
[2022]
|
| Materias: | |
| Ver en Biblioteca Universitat Ramon Llull: | https://discovery.url.edu/permalink/34CSUC_URL/1im36ta/alma991009657367206719 |
Tabla de Contenidos:
- Cover
- Title page
- Copyright and Credits
- Contributors
- Table of Contents
- Preface
- Chapter 1: First Steps
- Introducing PostgreSQL 14
- What makes PostgreSQL different?
- How to get 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 the pgAdmin4 GUI tool
- How to do it…
- How it works…
- Using the OmniDB GUI tool
- How to do it…
- 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…
- PostgreSQL in the cloud
- Getting ready
- How to do it…
- How it works…
- There's more…
- Chapter 2: Exploring the Database
- What type of server is this?
- How to do it…
- There's more...
- 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...
- See also
- Locating the database's system identifier
- Getting ready
- How to do it…
- How it works…
- Listing databases on the 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…
- Listing extensions in this database
- How to do it…
- How it works…
- There's more…
- See also
- Understanding object dependencies
- Getting ready
- How to do it…
- How it works…
- There's more…
- Chapter 3: Server Configuration
- RTFM
- 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…
- Setting configuration parameters for the database server
- Getting ready
- How to do it…
- How it works…
- There's more…
- Setting configuration parameters in your programs
- How to do it…
- How it works…
- There's more…
- Finding the configuration settings for your session
- How to do it…
- How it works…
- Finding parameters with non-default settings
- How to do it…
- How it works...
- There's more...
- Setting parameters for particular groups of users
- How to do it…
- How it works…
- A 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…
- How it works...
- Using an installed module/extension
- Getting ready
- How to do it…
- How it works...
- Managing installed extensions
- How to do it…
- How it works…
- There's more…
- Chapter 4: Server Control
- Overview of controlling the database server.
- 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 databases
- 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
- Choosing good names for database objects
- Getting ready
- How to do it…
- 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...
- 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…
- Making bulk data changes using server-side procedures with transactions
- Getting ready
- How to do it…
- There's more…
- Chapter 6: Security
- Overview of PostgreSQL security
- Typical user roles
- The PostgreSQL superuser
- How to do it…
- How it works…
- There's more…
- See also
- Revoking user access to a table
- Getting ready
- How to do it…
- How it works…
- There's more…
- Granting user access to a table
- Getting ready
- How to do it…
- How it works...
- There's more…
- Granting user access to specific columns
- Getting ready
- How to do it…
- How it works…
- There's more…
- 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…
- 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…
- Auditing database access
- Getting ready
- Auditing access
- Auditing SQL
- Auditing table access
- Managing the audit log
- Auditing data changes
- Always knowing which user is logged in
- Getting ready
- How to do it…
- How it works…
- There's more…
- Integrating with LDAP.
- Getting ready
- How to do it…
- How it works…
- There's more…
- See also
- Connecting using encryption (SSL/GSSAPI)
- Getting ready
- How to do it…
- How it works…
- There's more…
- Using SSL certificates to authenticate
- Getting ready
- How to do it…
- How it works…
- There's more…
- See also
- Mapping external usernames to database roles
- Getting ready
- How to do it…
- How it works…
- There's more…
- Using column-level encryption
- Getting ready
- How to do it…
- How it works…
- There's more…
- See also
- Setting up cloud security using predefined roles
- Getting ready
- How to do it…
- How it works…
- There's more…
- Chapter 7: Database Administration
- Writing a script that either succeeds entirely or fails entirely
- How to do it…
- How it works…
- There's more…
- Writing a psql script that exits on the first error
- Getting ready
- How to do it…
- How it works…
- There's more…
- Using psql variables
- Getting ready
- How to do it…
- How it works…
- There's more…
- Placing query output into psql variables
- Getting ready
- How to do it…
- How it works…
- There's more…
- Writing a conditional psql script
- Getting ready
- How to do it…
- How it works…
- There's more…
- Investigating a psql error
- Getting ready
- How to do it…
- There's more…
- Setting the psql prompt with useful information
- Getting ready
- How to do it…
- How it works…
- Using pgAdmin for DBA tasks
- Getting ready
- How to do it…
- How it works...
- There's more…
- Scheduling jobs for regular background execution
- Getting ready
- How to do it…
- How it works…
- There's more…
- Performing actions on many tables
- Getting ready
- How to do it…
- How it works…
- There's more…
- Adding/removing columns on a table
- How to do it…
- How it works…
- There's more….
- Changing the data type of a column.
