Cargando…
PostgreSQL 13 Cookbook /
Get to grips with building reliable, scalable, and maintainable database solutions for enterprises and production databases Key Features Implement PostgreSQL 13 features to perform end-to-end modern database management Design, manage, and build enterprise database solutions using a unique recipe-bas...
| Clasificación: | Libro Electrónico |
|---|---|
| Autor principal: | |
| Autor Corporativo: | |
| Formato: | Electrónico eBook |
| Idioma: | Inglés |
| Publicado: |
Packt Publishing,
2021.
|
| Edición: | 1st edition. |
| Temas: | |
| Acceso en línea: | Texto completo Texto completo |
Tabla de Contenidos:
- Intro
- Title Page
- Cover
- Copyright and Credits
- Contributors
- Table of Contents
- Preface
- Chapter 1: Cluster Management Fundamentals
- Technical requirements
- Installing PostgreSQL 13 using RPMs on CentOS
- Getting ready
- How to do it...
- How it works...
- Initializing a PostgreSQL cluster using initdb
- Getting ready
- How to do it...
- How it works...
- Starting a PostgreSQL cluster using pg_ctl
- Getting ready
- How to do it...
- How it works...
- Clusters in PostgreSQL
- Databases in PostgreSQL
- There's more...
- Shutting down a PostgreSQL cluster using different shutdown modes
- Getting ready
- How to do it...
- How it works...
- There's more...
- Identifying a PostgreSQL data directory and its contents
- Getting ready
- How to do it...
- How it works...
- There's more...
- Moving pg_wal to another location
- Getting ready
- How to do it...
- How it works...
- Running the psql client and some psql shortcuts
- Getting ready
- How to do it...
- How it works...
- Running a SQL server using psql
- Getting a list of databases
- Finding the database's size
- Connecting to a database
- Getting the list of schemas in a database
- Getting the list of tables
- Describing a table
- There's more...
- SQLs behind the shortcuts
- Locating the Postgres configuration file
- Getting ready
- How to do it...
- How it works...
- There's more...
- include_dir
- include
- Modifying the location of a postgresql.conf file in PostgreSQL
- Getting ready
- How to do it...
- How it works...
- Modifying the postgresql.auto.conf file in PostgreSQL
- Getting ready
- How to do it...
- How it works...
- There's more...
- Enable archiving in PostgreSQL
- Getting ready
- How to do it...
- How it works...
- There's more...
- Chapter 2: Cluster Management Techniques
- Technical requirements
- Creating and dropping databases
- Getting ready
- How to do it...
- How it works
- There's more
- Locating a database and a table on the file system
- Getting ready
- How to do it...
- How it works...
- Creating a schema in PostgreSQL
- Getting ready
- How to do it...
- How it works...
- There's more...
- Checking table and index sizes in PostgreSQL
- Getting ready
- How to do it...
- How it works...
- There's more...
- Creating tablespaces
- Getting ready
- How to do it...
- How it works
- There's more...
- Moving tables to a different tablespace
- Getting ready
- How to do it...
- How it works
- Creating a user in PostgreSQL
- Getting ready
- How to do it...
- How it works
- There's more...
- Dropping a user in PostgreSQL
- Getting ready
- How to do it ...
- How it works ...
- Assigning and revoking a privilege to/from a user or a role
- Getting ready
- How to do it
- How it works
- Creating a group role for role-based segregation
- Getting ready
- How to do it
- How it works